Back to jobs

Data Management Analyst (12-Month Fixed Term)

Pay
$96,800–113,800/yearAnnual period assumed — pay source
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. At CAAT, we believe innovation, passion, and purpose are ingredients for a great work environment. We’re incredibly proud of our people and the remarkable impact they have as catalysts for change. We’re committed to attracting and keeping great talent, which means competitive compensation, exceptional benefits, and an environment where people can grow and thrive. When you work with CAAT, you’ll enjoy:
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting

We are seeking a Data Management Analyst to work closely with various stakeholders to evaluate business requirements from a data perspective and implement data integrations, data models, and BI reports aligned with business objectives.

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

Apply at CAAT Pension

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 22, 202630 days ago
Recorded sightings
26
Last seen by us
Nov 17, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 30

Similar jobs usually come down between day 5 and day 43.

At CAAT Pension, jobs usually come down by about day 42.

From 16,009 similar postings that came down, and 5 of CAAT Pension’s. Coming down is not always a hire.

CAAT Pension is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

  • Takes jobs down quickly
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • T-SQL
  • Excel
  • Oracle
  • Power BI
  • Power Query
Where the posting names them
About the Role: We are seeking a Data Management Analyst to work closely with various stakeholders to evaluate business requirements from a data perspective and implement data integrations, data models, and BI reports 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, MS Excel and other reporting tools. - Develop business-focused reports and dashboards using Power BI, leveraging data models aligned with organizational objectives.
- A minimum of five (5) years of experience in working with data warehouse, dimensional / semantic modelling and BI development. - A minimum of five (5) years of experience with SQL (MS T-SQL or Oracle PL-SQL). - Over two (2) years experience, Power BI development, DAX, Power Query, data modeling and dashboard design.
- Create and manage datasets by writing scripts and programs using SQL, MS 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.
- A minimum of five (5) years of experience with SQL (MS T-SQL or Oracle PL-SQL). - Over two (2) years experience, 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.

Your next step

Complete your application on caatpension.wd10.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

At CAAT, we’re passionate about what we do. And it shows!
 

Here, you’ll find a cultural spark in everything we do – from the way we partner with members and employers, to the way we work, collaborate, and grow. It doesn’t just feel different at CAAT. It is different. We’re one of the fastest-growing pensions in the country for a reason. We challenge the status quo, making a real impact on the hundreds of employers we serve – from education institutions to major corporations and household brands. And we’re just getting started. Driven by core values and a shared purpose, we’re fierce champions for better retirement security, known for our can-do culture where everyone plays a role in bringing our vision to life. If this sounds like a fit, we’d love you to be a part of it.

About the Role:

We are seeking a Data Management Analyst to work closely with various stakeholders to evaluate business requirements from a data perspective and implement data integrations, data models, and BI reports 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, MS 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 five (5) years of experience in working with data warehouse, dimensional / semantic modelling and BI development.
  • A minimum of five (5) years of experience with SQL (MS T-SQL or Oracle PL-SQL).
  • Over two (2) years experience, 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.

At CAAT, we believe innovation, passion, and purpose are ingredients for a great work environment. We’re incredibly proud of our people and the remarkable impact they have as catalysts for change. We’re committed to attracting and keeping great talent, which means competitive compensation, exceptional benefits, and an environment where people can grow and thrive. When you work with CAAT, you’ll enjoy:

  • Opportunities to Build a Better You: We never stand still. As we grow, so do you. Enjoy a place that provides endless opportunities to learn and master your skills while cultivating new ones.

  • Comprehensive & Holistic Care: Be at your best with a Total Rewards program that feeds and prioritizes your physical, mental, and financial wellness. From flexible work arrangements, comprehensive benefits to wellness incentives, and a defined benefit pension plan – we have you covered.

  • A Place to Collaborate and Win: We’ve built a lively environment where creativity and open communication thrive. It’s why we’re consistently recognized as one of ‘Canada’s Most Admired Corporate Cultures’, one of ‘Greater Toronto’s Top Employers’, and one of the ‘Best Places to Work’.

  • Work that Truly Matters. You’re giving Canadians the opportunity for better retirement security, and organizations the chance to do more.
     

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.

CAAT Pension Plan is an equal opportunity employer, and we will accommodate any needs under the Accessibility for Ontarians with Disabilities Act and the Ontario Human Rights Code. Hiring processes will be modified to remove barriers to accommodate those with disabilities, if requested. Should any applicant require accommodation through the application processes, please contact us at hr@caatpension.ca or call Human Resources at 416-673-9000 for assistance.

Vacancy:

This posting is for an existing vacancy

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
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. At CAAT, we believe innovation, passion, and purpose are ingredients for a great work environment. We’re incredibly proud of our people and the remarkable impact they have as catalysts for change. We’re committed to attracting and keeping great talent, which means competitive compensation, exceptional benefits, and an environment where people can grow and thrive. When you work with CAAT, you’ll enjoy:
Location & working pattern

Toronto, ON

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.