Data Management Analyst (12-Month Contract)

At CAAT were passionate about what we do. And it shows!

Here youll 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 doesnt just feel different at CAAT. It is different. Were 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 were just getting started. Driven by core values and a shared purpose were 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 wed love you to be a part of it.

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 Youll:

• 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 $93900.00-$110400.00. Placement within our salary range will be based on factors such as internal equity market conditions and the candidates experience skills and qualifications relevant to the role.

At CAAT we believe innovation passion and purpose are ingredients for a great work environment. Were incredibly proud of our people and the remarkable impact they have as catalysts for change. Were 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 youll 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: Weve built a lively environment where creativity and open communication thrive. Its why were consistently recognized as one of Canadas Most Admired Corporate Cultures one of Greater Torontos Top Employers and one of the Best Places to Work.

• Work that Truly Matters. Youre 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 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 or call Human Resources at for assistance.

Vacancy: