Job Title: Senior Data Engineer
Location: Markham, ON (3x onsite a week)
Employment Type: Contract
Pay Rate: CAD$50 - $65/HR INC
Job Description
This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, design, analysis, and implementation in a successful and experienced team. As a Senior Data Engineer, you will play a pivotal role in driving the design, development, and delivery of scalable data solutions across the enterprise.
What You’ll Do
Advocate for engineering standards and process efficiencies to ensure high-quality, timely delivery.
Lead the development of complex, high-performance data pipelines using tools like dbt Core/Cloud.
Help design and review data models (conceptual, logical, physical) that meet business and technical requirements.
Own and maintain robust, reusable code in SQL, Python, Shell, and Terraform scripts.
Develop detailed low-level engineering solution design documents to guide implementation and ensure alignment with technical standards.
Create and review data test plans to ensure alignment with solution requirements.
Advocate importance of data catalogs, data governance, and data quality practices.
Conduct root cause analysis and implement effective solutions for technical data issues.
Lead scrum ceremonies and foster an agile mindset across the team.
Mentor and support Data Engineers and Associate Data Engineers, elevating engineering standards and practices.
Collaborate cross-functionally to deliver high-quality data products with strong customer-centric focus.
Drive technical presentations and provide constructive feedback on data designs and processes.
Plan and execute data release activities to ensure smooth and high-performance delivery.
Support talent acquisition by designing interview challenges, conducting interviews, and contributing to hiring decisions.
What You’ll Bring
8+ years of professional experience in data engineering with delivery of multiple high-impact data projects.
Deep expertise in relational databases such as Snowflake, PostgreSQL, and Amazon Aurora.
Experience with big data platforms like Hadoop and NoSQL databases such as MongoDB.
Advanced proficiency in data visualization tools such as Snowsight, Streamlit, Qlik, and SAP Business Objects.
Expert-level coding skills in SQL, Python, Glue, dbt, Shell, and Terraform.
Experience with data orchestration and pipeline tools including Zena and AWS Managed Airflow.
Strong collaboration, communication, and leadership skills.
Insurance domain knowledge is an asset.
Prior experience in AI/ML model operationalization is an asset.
Certifications (Nice To Have)
SnowPro Core
SnowPro Advanced Data Engineer
dbt Developer
AWS Cloud Practitioner
Disclaimer: As part of our hiring process, we may use automated or AI-based tools to support candidate screening and application review. These tools are used to assist decision-making and do not replace human judgment.