Senior Data Engineer

STACK IT Recruitment • Markham, ON

1d • CA$90,000 - CA$120,000 • Hybrid

About The Position

We're hiring a Senior Data Engineer for a full-time permanent position with a fast-growing Canadian consumer goods distributor that is investing seriously in its data, analytics, and AI capabilities. In this role, you'll design, build, and scale the pipelines, warehouse, and lakehouse architecture that connect ERP, CRM, eCommerce, WMS, and point-of-sale systems into a single trusted source of truth. You'll set the standards for data quality, governance, and observability, partner with stakeholders across Sales, Operations, Supply Chain, and Finance, and lay the foundations that the organization's analytics and AI initiatives will run on.

Requirements

• 4+ years of progressive experience in data engineering or a closely related discipline, ideally within a fast-moving, commercially driven environment
• Advanced SQL proficiency, including the ability to write, debug, and tune complex queries against large and imperfect datasets
• Strong Python skills applied to data transformation, automation, and pipeline development
• Demonstrated experience building and orchestrating production-grade pipelines using modern transformation tooling such as dbt
• Hands-on experience with cloud data platforms, particularly BigQuery and Azure Fabric
• Practical working knowledge of at least one major cloud ecosystem such as Azure or GCP
• A thorough grounding in data modeling, warehousing concepts, and dimensional design, with a clear point of view on when each approach applies
• Proven experience integrating REST APIs, streaming sources, and third-party SaaS platforms into enterprise data environments
• Familiarity with CI/CD pipelines, Git-based workflows, infrastructure-as-code, and the application of software engineering rigor to data work
• Strong analytical and problem-solving ability, paired with the communication skills to explain technical trade-offs to a non-technical audience
• A demonstrated ability to work autonomously and manage competing priorities without losing delivery momentum

Nice To Haves

• Experience supporting AI/ML workloads, including feature engineering and the preparation of model-ready datasets
• Proficiency with Power BI or comparable modern BI platforms
• Industry exposure to retail, distribution, supply chain, or consumer packaged goods
• Familiarity with event-driven architectures and real-time analytics patterns
• Experience implementing MDM, data governance frameworks, or data catalog solutions

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines and data workflows that the business can rely on daily
• Design and evolve enterprise data warehouse and lakehouse architectures, applying dimensional modeling principles that hold up as data volume and business complexity grow
• Lead integration across ERP, CRM, eCommerce, warehouse management, and point-of-sale platforms, reconciling the structural and semantic differences between systems never designed to work together
• Develop both batch and real-time processing pipelines, serving day-to-day operational reporting alongside deeper analytical work
• Establish and uphold standards for data quality, governance, lineage, and security across the platform, so that trust in the numbers is engineered rather than assumed
• Tune database performance, query efficiency, and cloud consumption, balancing delivery speed against long-term infrastructure cost
• Implement monitoring, alerting, and observability so pipeline issues are identified and resolved before they surface in front of business users
• Work directly with analysts, data scientists, and stakeholders across Sales, Operations, Supply Chain, and Finance to translate open-ended business questions into well-defined data requirements
• Build the scalable, well-governed data foundations that the organization's AI and machine learning initiatives will depend on
• Raise engineering maturity through documentation, code review, version control discipline, and DevOps/DataOps practice
• Mentor junior engineers and help define how the data engineering function is structured as the team scales

Benefits

• Base Salary: $90,000 – $120,000
• Paid Time Off: Competitive vacation and personal days to maintain a healthy work-life balance
• Comprehensive Health Benefits: Medical, dental, and vision benefits to support your overall well-being
• Culture & Team: Be a part of a supportive cross-functional team, that thrives on collaboration and innovation, where every member's ideas are valued and contribute to shared goals and success

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed