Who we'd reach at 2iSolutions Inc.Found and reached by Power Apply
Best leadTeam lead
Runs the team day to day
Recruiter
In-house, owns the opening
Recent hire
Joined the team recently
From your own Gmail and LinkedIn.
About the role
This is a senior data engineering contract in Oshawa, Ontario, for a candidate with at least eight years of hands-on data engineering experience, working on site three days a week. The three-year contract centers on designing and building production data pipelines and lakehouse architecture on the Microsoft Azure stack. The role includes architecture and design forums, where the engineer defines standards and then implements them.
What you’ll do
- Take part in architecture and design forums and define solutions and standards
- Build and optimize production-grade data pipelines across Azure data services
- Design ETL and ELT architectures covering ingestion, transformation, monitoring and data quality
- Model dimensional data and design data lake and lakehouse layouts
- Set reusable patterns for ingestion, transformation, CI/CD and monitoring
- Troubleshoot and tune SQL, Spark and pipeline workloads in production
What they’re looking for
- Eight or more years of hands-on data engineering or development
- Strong SQL and Python
- Strong Spark and PySpark experience with large datasets
- Deep ETL and ELT architecture experience
- Data architecture experience including dimensional modeling and lakehouse design
- Significant hands-on work with Azure Data Factory, Databricks, ADLS, and Synapse or Fabric
- Ability to make architecture trade-offs rather than only following a design
- Practical understanding of governance, metadata, data quality and security
What’s on offer
- Three-year contract
- Hybrid work, three days per week on site in Oshawa
Skills
Questions about this role
Is this role hybrid?
Yes, it is hybrid with three days a week on site in Oshawa.
How long is the contract?
The contract runs three years.
How much experience is needed?
At least eight years of hands-on data engineering or development.