Job Description

Title: Senior Data Engineer
Job Type: Contract (6 Months, High Potential for Extension)
Location: Markham, ON (Onsite – 4 days per week)

Our client is seeking a Senior Data Engineer to join their expanding data team. The ideal candidate will be results-oriented with strong analytical acumen, handson technical expertise, and a proven ability to build scalable data pipelines, execute advanced analysis, and manage multiple initiatives proactively. This role involves designing, developing, and maintaining cloud-based data solutions while collaborating closely with cross-functional stakeholders.

Key Responsibilities:

• Design, develop, and maintain resilient data pipelines utilizing Azure Data Factory (ADF), Blob Storage, on-premises systems, and Azure Functions.
• Manage end-to end data engineering tasks independently, from requirements gathering through deployment, liaising directly with business stakeholders.
• Collaborate with Data Science, Integration, and Operations teams to assess data needs and deliver high-quality solutions.
• Lead and coordinate multiple projects, ensuring timely execution, effective communication, and alignment with organizational objectives.
• Develop and optimize data models for OLTP systems and relational databases.
• Write optimized SQL queries and scripts for SQL Server (experience with Oracle considered an asset).
• Implement mechanisms for data quality assurance, monitoring, alerting, master data management, and data cleansing strategies.
• Utilize Python for data transformation, automation, and integration activities.
• Ensure compliance with data security, governance, and best practices.

Key Requirements:

• 10+ years of professional experience in data engineering or a related discipline.
• Extensive experience with Azure Cloud Services (ADF and Azure Functions required).
• Proficiency in SQL and relational databases (SQL Server essential; Oracle a plus).
• In-depth knowledge of OLTP systems, data modeling methodologies, and system architecture design.
• Advanced programming skills in Python.
• Experience with CDC processes, master data management, and data cleansing.
• Strong analytical and problem-solving abilities, with the capacity to manage multiple projects simultaneously.
• Excellent communication skills with proven experience engaging stakeholders directly and contributing to architectural discussions.

Preferred Qualifications

• Experience with CI/CD pipelines and Azure DevOps practices.
• Familiarity with data warehousing concepts and associated tools.
• Knowledge of data governance and security standards.