Role: Senior Data Engineer
Job Summary:The Analytics team is seeking a passionate, inquisitive, detail-oriented, and customer-focused Senior Data Engineer to join our growing team. The successful candidate will be responsible for designing, building, and optimizing scalable data systems that support IKO's global operations. This includes maintaining high data quality, integrating diverse data sources, and enabling actionable insights across the business.
This role is based fully onsite at our Mississauga, Ontario office location.
Compensation: $130,000 - $140,000
Benefits- Health Insurance (includes Virtual Health, and HCSA)
- Dental Insurance
- Vision Insurance
- Life Insurance
- Long-term Disability
- Short-term Disability
- RRSP Match
- Paid Vacation
- Floating Days
- Employee Assistance Program
- Employee Engagement Events
- Awards and Recognition
- Tuition Reimbursement
- Service Awards
- Employee Perks & Discounts
Job Responsibilities- Lead the design and implementation of scalable, high-performance data systems to support IKO's global operations
- Develop and optimize ETL/ELT pipelines using Azure Data Factory and related data integration tools to integrate complex data sources
- Implement robust data reliability, testing, and validation frameworks to ensure accuracy, performance, and trustworthy insights
- Support enterprise data governance initiatives by implementing frameworks and practices aligned with organizational standards for data integrity, security, and compliance
- Collaborate with cross-functional stakeholders to translate business objectives into technical data solutions
- Support the administration of Azure-based databases, including performance tuning, backup and recovery, maintenance, and reliability activities
- Mentor junior team members and foster a culture of technical excellence, knowledge sharing, and continuous improvement
- Evaluate and implement modern data tools such as Azure Synapse Analytics, Data Lake Storage, Microsoft Fabric, and Databricks to enhance the data ecosystem
- Analyze and resolve complex data challenges using critical thinking, technical expertise, and process optimization
- Additional duties as assigned
Qualifications- Minimum 10 years of professional experience in data engineering or a related field
- Advanced SQL skills, including complex queries, window functions, CTEs, query tuning, database design, and transaction management for large datasets
- Proven experience developing large-scale ETL pipelines and data processing automation using PySpark and Python within Microsoft Fabric Notebooks and the Azure ecosystem
- Extensive experience with Microsoft data integration tools, including Azure Data Factory (ADF) and Fabric Data Factory, to orchestrate complex data ingestion pipelines
- Strong foundational knowledge of data warehousing and Lakehouse architectures, including star and snowflake schemas, Slowly Changing Dimensions (SCD), and data governance frameworks
- Hands-on experience with DevOps and CI/CD frameworks, including Git workflows, branching, merging, pull requests, Azure DevOps, automated pipelines, environment configuration, and Azure resource deployment
- Solid communication skills, with the ability to translate technical concepts into actionable business insights
- Demonstrated leadership and strategic capabilities, including mentoring team members, owning projects, and collaborating with stakeholders to balance technical details with business objectives
- Microsoft Certified: Fabric Data Engineer Associate (DP-700) preferred
- Proficiency in spoken and written French considered an asset
- Ability to work fully onsite from the Mississauga, Ontario office location
- Ability to travel approximately 5% within North America and Europe
