About the Role:

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.

As the Newest Member of our Team, You'll:

• 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

To Succeed, You Bring:

• 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.
• Certifications in DP-600 Microsoft Fabric Analytics Engineer Associate or DP-700: Microsoft Fabric Data Engineer Associate are considered assets.

The target hiring salary for this position is $96,800.00-$113,800.00. Placement within our salary range will be based on factors such as internal equity, market conditions, and the candidate's experience, skills, and qualifications relevant to the role.

If you believe that Canadians deserve a future where a secure lifetime retirement income contributes to their financial and overall well-being, then CAAT could be the right fit for you. Start your journey with us today. Apply now.

Learn more about us by visiting www.caatpension.ca/careers

No artificial intelligence tools are used to screen, assess, or select applicants for this position. Artificial intelligence tools may be used to help recruiters identify potential candidates on external platforms. All hiring decisions are made by human reviewers.

Diversity, Equity, Inclusion, and Belonging (DEIB):

DEIB at CAAT means we respect and value the broadest range of experiences, geographies, gender, ethnicities, backgrounds, and perspectives as key elements of our culture. Our vision is to provide an environment where employees can bring their best, professional, authentic, selves to work.

Vacancy:
This posting is for an existing vacancy