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  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.

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.

• 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.

• 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 (Git Hub, Bitbucket, Terraform)
• Solid background in data modeling, complex transformations, production deployments, and reverse‑engineering existing integrations

The target hiring salary for this position is $ - $. 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.

• 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…