Senior Data Engineer

IKO Sales Inc.; Mississauga; In loco; CAD 130.000 - 140.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health Insurance

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

Descrizione del lavoro

IKO Industries Ltd. in Mississauga, Ontario is seeking a Senior Data Engineer to design, build, and optimize scalable data systems that support our global operations. You will ensure data quality, integrate diverse sources, and enable actionable insights across the business.

The role is onsite at our Mississauga office. You will lead ETL/ELT development with Azure Data Factory, Synapse, and Databricks, mentor teammates, and drive governance and reliability across the data platform.

Competenze

• Minimum 10 years of professional data engineering experience.
• Experience with large-scale ETL pipelines and data processing automation.
• Strong knowledge of data warehousing and lakehouse architectures.
• Experience with Azure ecosystem and Microsoft data tools.

Mansioni

• Lead design and implementation of scalable, high-performance data systems for global operations.
• Develop and optimize ETL/ELT pipelines using Azure Data Factory.
• Implement data reliability, testing, and validation frameworks.
• Support data governance for data integrity, security, and compliance.
• Collaborate with stakeholders to translate business needs into technical solutions.
• Mentor junior team members and promote technical excellence.
• Evaluate tools like Azure Synapse, Data Lake Storage, Fabric, and Databricks.

Conoscenze

Advanced SQL

PySpark

Python

Azure Data Factory

Fabric Data Factory

Databricks

Data Warehousing

CI/CD

Leadership

Communication

Strumenti

Azure Synapse Analytics

Data Lake Storage

Microsoft Fabric

Databricks

Git & Azure DevOps

Descrizione del lavoro

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.