Data Analyst


Our client is looking for an experienced Data Anlayst to join a growing team. The successful candidate will be assigned tasks related to all aspects of the project work required to implement a physical data model, including development and implementation of the design.

The types of development and implementation tasks include:

• Identifying and profiling source data
• Source data mapping and integration
• Physical data modelling
• Report development


1. Profile source systems to ensure data and the necessary relationships exist in source systems
2. Map required data from source to target
3. Develop and implement Physical data models based on logical design
4. Capture metadata for modeled data
5. Implement processes and logic to extract, transform, and load data from a wide variety of sources into the Enterprise Data Warehouse
6. Develop assigned reports\visualizations\dashboards
7. Capture metadata for reports \ data visualizations

Required Experience

Business Analysis

• Expert level experience analyzing data requirements for data modeling and reporting \ analytics projects

Data Modeling

• Expert level experience in modeling data within an Enterprise Data Warehouse
• ERWin Data Modeler
• Microsoft SQL Server

Data Integration

• Expert level experience in building data integrations (MuleSoft v3.8 \ v4.0, SSIS)
• Expert level experience working with API interfaces

Report Development

• Intermediate level knowledge MS PowerBI (including developing reports using DAX), SQL Server Report Server, Reporting Services
• Power Shell
• SharePoint Integration


1.Physical Data Model

• Physical data model in ERWin Data Modeler
• Associated SQL Server database objects created within the EDW
• A metadata record for each object
• The number of data objects created in the physical model will be dependant on data availability

2. Data Integrations

• A Data mapping spreadsheet(s) which will include source, transformation\mapping rules and target details
• Developed and implemented integration code
• The number of integrations to be developed will be between 1 and 3

3. Data Products

• Report, data visualization, dashboard delivered in PowerBI
• A metadata record for the data product
• The number of reports to be developed will be between 1 and 2

Randstad Professionals Canada
Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.

Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.

For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.

View original article here Source