Data Management Analyst (12-Month Fixed Term)

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 aData 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 [email protected] or call Human Resources at 416-673-9000 for assistance.

Vacancy: