Sr. Data Engineer

Job Title: Senior Data Engineer

Location: Markham, ON

Model: Hybrid - 3 Days a week (Mon/Tue/Wed Mandatory)

Job Type: Contract

Job Summary

This job posting is for an existing, active vacancy and 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

You Will

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

• 8+ years of professional experience in data engineering, with a proven track record of delivering 3+ high-impact data projects from inception to warranty.
• Deep expertise in relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (MongoDB).
• Advanced proficiency in data visualization tools such as Snow sight, Streamlit, Qlik, and SAP Business Objects.
• Expert level coding skills in SQL, Python, Glue, DBT, Shell, and Terraform, with a focus on maintainability and performance.
• Experience with data orchestration and pipeline tools, including Zena and AWS Managed Airflow.
• High resilience and adaptability in ambiguous or high-pressure environments.
• A customer-first mindset, using data-driven insights to deliver impactful solutions.
• Strong collaboration and communication skills, with the ability to lead teams and influence stakeholders.
• Insurance knowledge is an asset – ability to foundationally understand complex business processes driving technical systems.
• Prior experience in AI/ML model operationalization is an asset.
• Any or all of the following certifications will be nice to have:
• SnowPro Core
• SnowPro Advanced: Data Engineer (DEA-C01 or DEA-C02)
• dbt Developer
• AWS Cloud Practitioner