Dbt Developer Jobs in Ontario (NOW HIRING)

Choose a workplace that empowers your impact.

Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be - and deliver - your best.

We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 665,000 members, placing their best interests at the heart of everything we do.

Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.

Don't just work anywhere - come build tomorrow together with us.

Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.

Role Summary

The Senior Data Engineer will join the Software Engineering team that leads the delivery of data and application solutions that enable OMERS Global Investments (GI) and Corporate teams to analyze opportunities, support investment decision-making, optimize portfolio insights, and strengthen enterprise management capabilities.

Reporting to the Manager, Software Engineering, the Senior Data Engineer works across investment teams including Capital Markets, Infrastructure, Private Equity, Private Capital and Ventures, and Corporate, in close collaboration with Finance, Risk & Compliance teams.

As a key member of the Software Engineering team, the Senior Data Engineer will be hands-on across the full data solution delivery lifecycle, leading the design, development, deployment, and operation of scalable data solutions. This role requires the ability to build trusted relationships with business and technology stakeholders, understand business priorities, define solution architectures, and deliver reliable data products that enable analytics, AI-driven capabilities, and operational excellence. The individual will collaborate closely with Power BI developers, Data Scientists, Investment Professionals, Architects, and Platform Teams, providing technical leadership and integration expertise across one or more application teams.

You will be responsible for:

• Translate business requirements into scalable, secure, and reliable data solutions.

• Lead the design, development, deployment, and operational support of data platforms, pipelines, and products using modern cloud and engineering practices.

• Define and execute testing strategies, including unit, integration, performance, data quality, and automated regression testing.

• Source, transform, and deliver structured and unstructured data assets for analytics, reporting, operational, and AI-enabled use cases.

• Develop and maintain ELT/ETL pipelines that achieve high levels of reliability, scalability, performance, and security.

• Optimize data pipelines, data models, and platform components for performance, cost efficiency, and operational excellence.

• Implement and maintain CI/CD practices, monitoring, observability, auditing, and operational controls to support production-grade solutions.

• Provision and manage Azure resources, ensuring appropriate security, governance, and cost management.

• Troubleshoot complex technical issues and drive continuous improvement across data solutions and platforms.

Required Skills & Experience

• 5+ years delivering complex data engineering and analytics solutions using Microsoft Azure. Experience in the financial services or investment industry is preferred.

• Strong understanding of data engineering, cloud, and software engineering best practices, with experience developing and implementing operational procedures, standards, and documentation.

• Consistent track record of building deep technical relationships. Experience in aligning expectations across various partners

• Strong analytical and troubleshooting skills, with the ability to trace data lineage, investigate complex workflows, and resolve technical issues with minimal direction.

• Motivated and keen to work in a collaborative environment with a focus on team success, knowledge sharing, continuous improvement, and delivering business value.

• Enterprise-scale experience designing, building, and supporting cloud-based data platforms, data products, and scalable ELT/ETL solutions on Microsoft Azure.

• Strong experience with data architecture, data modeling, data warehousing, and dimensional modeling methodologies such as Kimball and Data Vault 2.0.

• Strong hands-on experience with Python, PySpark, and SQL.

• Deep expertise and Subject Matter Expertise (SME) in Snowflake and dbt, including data modeling, transformation, testing, deployment and performance optimization

• Experience with data orchestration tools such as Prefect, Dagster, Airflow, ADF, or Synapse.

• Experience designing and developing Azure Functions and Azure Logic Apps for data integration, automation, and event-driven solutions.

• Experience designing data solutions that support AI-enabled use cases, semantic search, or unstructured data processing.

• Proven experience implementing and maintaining CI/CD pipelines using GitHub Actions.

• Experience translating business requirements into scalable technical solutions and collaborating effectively with business and technology stakeholders.

• Experience working in the financial services, asset management, pension, investment management, or similar data-intensive industries.

Preferred Skills & Experience

• Experience with Snowflake.

• Experience with Azure Databricks.

• Experience with Microsoft Fabric.

• Experience with Power BI report development, semantic models, and dashboard design.

• Experience with containerization and container orchestration technologies.

• Experience with Infrastructure-as-Code (IaC) and cloud automation practices.

• Post-secondary education in Computer Science, Software Engineering, Information Technology, or a related discipline.

We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other,our flexible hybrid work guideline requires teams to come in to the office4 daysper week.

You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans - details on these elements of compensation are included within OMERS & Oxford offer letters.

As one of Canada's largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work - and the members we proudly serve.

From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition programs.

Artificial intelligence (AI) tools are used to support certain stages of the OMERS recruitment process. While AI assists us in our process, human judgment and decision-making remain central to our candidate experience.