Data Management Analyst (12-Month Contract)

CAAT Pension Plan•Toronto, ON

About The Position

We are seeking a Data Management Analyst to work closely with our stakeholders to evaluate business requirements from a data requirement perspective. You will implement data integrations, develop data models and ensure BI reports are aligned with business objectives. You will build advanced SQL scripts and programs, ETL pipelines, reports and dashboards within various platforms such as Oracle databases, MS- Fabric, Power BI and different enterprise IT systems.

Requirements

A university degree or college diploma in related discipline or a combination of education, training and experience deemed equivalent.
A minimum of 5 years of experience (MS SQL, T-SQL, or Oracle PL-SQL), Python, working with data warehouse, dimensional / semantic modelling and BI development.
A minimum of 3 years experience with ETL development, Power BI development, DAX, Power Query, data modeling and dashboard design.
Strong experience in analyzing varying levels of business needs and developing appropriate data models.
Proven ability to communicate effectively clearly with team members and be able to convey technical concepts into clear, simple language.
Excellent analytical thinking skills for translating data into informative visuals and reports.
Ability to prioritize and manage multiple tasks in a fast-paced environment.

Nice To Haves

Certifications in DP-600 Microsoft Fabric Analytics Engineer Associate or DP-700: Microsoft Fabric Data Engineer Associate are considered assets.

Responsibilities

Develop and implement BI solutions using different frameworks, technologies and best practices.
Create and manage datasets by writing scripts and programs using SQL, Python, excel and other reporting tools.
Develop business-focused reports and dashboards using Power BI, leveraging data models aligned with organizational objectives.
Design and Develop ETL processes and unit tests in a data warehouse environment.
Measure and ensure Data Quality improvements by identifying and resolving Data Quality issues.
Participate in data requirements analysis for new projects and enhancement requests and produce technical specification documentation.
Support the overall BI and data solutions delivery and on-going operations.
Effectively collaborate with team members and people from different departments with varying degrees of business and/or technical experience.