Data Management Analyst (12-Month Fixed Term)
Job description
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 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 or call Human Resources at for assistance.
Vacancy:
This posting is for an existing vacancy
Job details
- Published
- October 21, 2026
- Job source
- myworkdayjobs
- Workplace
- On-site · Toronto, CA
- First seen
- October 22, 2026
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at CAAT Pension Plan
Similar jobs from this company
- Pension Analyst, Employer Services (18-Month Contract, Two Vacancies)CAAT Pension PlanToronto, CAOn-site
- Pension Analyst, Operational Acceptance Testing (Contract until December 2027)CAAT Pension PlanToronto, CAOn-site$81,700–$96,000 per year
- HRIS AnalystCAAT Pension PlanToronto, CAOn-site$84,100–$98,900 per year
- Pension Analyst, Employer ServicesCAAT Pension PlanToronto, CAOn-site$73,200–$86,100 per year
- Senior Manager, Cybersecurity Operations & Vulnerability ManagementCAAT Pension PlanToronto, CAOn-site
Across the market
Similar jobs from other companies
- Business Analyst - Fixed Term (6-month term)ProphixEtobicoke, CAHybrid
- Content Management Analyst (Fixed Term, 6 months)Wolters Kluwer Professional Services Romania SRLROU - Cluj-NapocaOn-site
- Laboratory Analyst - Fixed-term 12 MonthsAbbVieAprilia, ITOn-site
- Royalty Analyst - Fixed Term (6 months)CAA Brands UK LTDLondon, United KingdomOn-site
- Business Analyst - Fixed Term 12 MonthsGuzman y GomezLevel 2, 64-76 Kippax Street, Surry Hills, AustraliaRemote
- FP&A Analyst - (Fixed Term 6 Months)Johnson & Johnson MedTech Colombia S.A.S.Bogota, Distrito Capital, ColombiaOn-site
Related job searches
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.