Senior Data Engineer

Aarorn Technologies Inc; Markham; On-site; CAD 68,880 - 89,544; Full time

Job summary

A leading tech company is seeking a Senior Data Engineer to lead data pipeline development and ensure high-quality data delivery. The ideal candidate should have over 8 years of experience in data engineering, proficiency in SQL, Python, and relevant tools like Snowflake and dbt. This contract position in Markham, ON, involves mentoring junior engineers and collaborating cross-functionally to enhance data governance and quality. The role requires a strong leader with a customer-focused approach and knowledge in AI/ML operationalization. Competitive pay rate is offered.

Qualifications

• 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.
• Strong collaboration, communication, and leadership skills.

Responsibilities

• Advocate for engineering standards and process efficiencies for timely delivery.
• Lead development of complex, high-performance data pipelines.
• Mentor and support Data Engineers and Associate Data Engineers.

Skills

SQL

Python

Data visualization tools

Leadership skills

Data governance

Tools

dbt Core/Cloud

Snowflake

Hadoop

AWS Managed Airflow

Job description

Senior Data Engineer

Location: Markham, ON (3x onsite a week)

Employment Type: Contract

Pay Rate: CAD$50 - $65/HR INC

Responsibilities

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

Qualifications

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