Data Engineer

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:

NOTE: This is a 12-month Fixed Term

The role of a Data Engineer is critical for a high performing data management team to support the data infrastructure that is used for building data management solutions. The Data Engineer will design and build processes and systems for collecting, storing, and analyzing data. They also design the data infrastructure that allows data to flow smoothly between different systems and applications and maintain the data pipeline to ensure they are always operational. With deep understanding of data modeling, the Data Engineer will ensure that data is accessible and can support and provide business intelligence and decision-making.

As the Newest Member of our Team, You Will:

• Design and build end‑to‑end data pipelines integrating multiple data sources into a unified platform

• Leverage Azure cloud services to orchestrate, optimize, and scale data workflows

• Develop robust data models to support business intelligence, analytics, and reporting needs

• Implement data integration solutions using Azure Data Factory, Azure Functions, and dataflows

• Optimize data pipelines for performance, cost efficiency, and low latency

• Monitor pipeline performance and proactively troubleshoot issues and bottlenecks

• Build automated data quality and validation processes to ensure reliable ETL outcomes

• Implement and maintain CI/CD pipelines for automated build and deployment

• Support data governance, including data catalog, lineage, privacy, and compliance standards

• Business travel may be required.

To Succeed, You Bring:

• 8+ years of experience building ELT/ETL pipelines from scratch for ODS and data warehouse environments, working with structured, semi‑structured, unstructured, and streaming data (Azure preferred)

• Degree in Computer Science, Engineering, or related field, or equivalent experience; cloud data certifications are an asset

• 5+ years of experience with data ingestion and replication tools (e.g., Informatica, SSIS, Microsoft Fabric, or similar cloud platforms)

• Advanced proficiency in SQL and Python for processing and optimizing large‑scale data sets

• Strong experience with CI/CD pipelines, source control, and infrastructure tools (GitHub, Bitbucket, Terraform)

• Solid background in data modeling, complex transformations, production deployments, and reverse‑engineering existing integrations

The target hiring salary for this position is $103, $129, 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 at or call Human Resources at for assistance.

Vacancy: