Senior Data Engineer

Role overview

Key accountabilities

• Build and productionize scalable ELT/ETL pipelines and data infrastructure across organizational data sources.
• Implement ingestion and curation pipelines that provide integrated data for BI, reporting, and downstream systems.
• Work with architecture, infrastructure, and cyber teams to secure data in transit and at rest.
• Clean, prepare, and optimize datasets, applying lineage and quality controls.
• Support BI analysts with dimensional modeling and aggregation optimization.
• Provide production support for ingestion, transformation, performance, accuracy, and integrity issues.
• Collaborate with data and solution teams on pipelines feeding the data marketplace.
• Automate manual processes, improve data delivery, and redesign infrastructure for scalability.
• Use Microsoft data technologies including Azure Data Factory, Azure Data Lake, Azure SQL, Azure Data Warehouse, Synapse, Databricks, Collibra, and Power BI.
• Contribute to Scrum delivery, feature and user story backlogs, and Kanban/Scrum tools.
• Maintain data catalogs and metadata; document pipelines and data products; use source control.
• Develop and orchestrate optimized pipelines and models; contribute to CI/CD, DevOps, testing, code review, access control, and Tier 2 production support.

Qualifications

• Four-year university education in computer science, computer/software engineering, or a relevant data, AI, or machine learning program.
• Over four years building data pipelines and processing frameworks with Python, PySpark, SparkSQL, and SQL.
• Data Engineer experience building pipelines, including for data lakehouses and data warehouses.
• Experience with Azure Data Factory, ADLS, Synapse Analytics, and Databricks.
• Understanding of data structures, processing frameworks, data governance, and data quality.
• Ability to communicate technical details to non-technical stakeholders.

Position details

• Temporary position with a stated duration of 36 months.
• Base location is in Oshawa, Ontario; 10% travel is required.
• Day shift.
• Salary range is $2,751.92–$3,227.88; the posting does not specify a pay cadence.