Senior Data Engineer at IKO in Mississauga, ON

Job description

IKO Industries Ltd. is a market leader in the manufacturing of roofing and building materials. IKO is a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry. Quality, integrity, and trustworthiness are the values that underlie this success, and we have built this company by hiring people who hold these values. People like you! Job Description 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. At IKO, we are more than a roofing manufacturer. We are innovators, transforming raw materials into products that shelter families, businesses, and communities. Our Analytics team turns raw data into actionable insights that drive efficiency, reduce waste, enhance product quality, and support strategic decision-making across IKO's global footprint. 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 action