Senior Data Engineer

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 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
Benefits of Employment: IKO recognizes that its success is due to the strength of its employees. A primary goal of IKO is to promote individual employee's sense of accomplishment and contribution so that employees enjoy their association with IKO. The Company invests in its employees so that they are the most knowledgeable in the industry, and undertakes great efforts to nurture loyalty to, and teamwork at, IKO. We are pleased to offer competitive compensation, health care, a progressive and challenging workplace and a commitment to teamwork and integrity.
Diversity and Equal Opportunity Employment: IKO Industries Ltd. is an equal opportunity employer. We are committed to diversity and inclusion and are pleased to consider all qualified applicants for employment without consideration to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, veteran status or disability.IKO Industries Ltd. encourages and welcomes applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.