Senior Data Engineer

Senior Data Engineer Location: Mississauga, ON 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 At IKO, we’re more than a roofing manufacturer—we’re innovators, transforming raw materials into products that shelter families, businesses, and communities. Our Analytics team is integral to this process, turning raw data into actionable insights that drive efficiency, reduce waste, and enhance product quality. Just as innovation drives our production line, our Analytics team powers IKO’s success by enabling strategic decisions that keep us at the forefront of the industry. By living our purpose, we bring data to life and help shape IKO’s future, ensuring we remain a global leader in roofing, insulation, and waterproofing solutions. Shape the Future of Analytics: Be part of a growing dynamic team where you'll have the opportunity to help define and shape IKO’s analytics strategy, making a lasting impact on the business. Empowered by Data: Just like the precision that goes into producing each shingle, our analytics team turns raw data into precision-driven strategies that impact every facet of the business. Innovation in Action: We work at the intersection of data and technology, constantly evolving our techniques and tools to drive innovation across IKO’s global footprint. Global Reach, Local Impact: From supply chain optimization to customer satisfaction, our insights make a difference across the world. Are you passionate about working with data and learning from experienced data professionals through hands-on mentorship and real-world projects? Do you enjoy solving complex problems and creating seamless data flows? If so, we have the perfect opportunity for you! As a Senior Data Engineer, you will ensure scalable and efficient data systems by addressing global operational demands, maintaining high data quality, and integrating diverse data sources. Navigate regulatory landscapes and implement robust governance frameworks to support long-term technical strategies. This role is basedfully onsiteat ourMississauga, ONoffice location. Compensation: $130,000 - $140,000 WHAT’S IN IT FOR YOU? Competitive compensation/pay package \ Dental/Vision/Medical benefits Life Insurance Health Spending Account Employee Support and Mental Wellness Competitive matched retirement savings program – RRSP Be part of a long standing and stable industry leader WHEN YOU JOIN US, YOU WILL BE; Lead the design and implementation of scalable, high-performance data systems to meet the evolving needs of IKO’s global operations. Develop and optimize ETL/ELT pipelines using modern data integration solutions like Azure Data Factory to integrate complex data sources, ensuring accuracy, reliability, and performance. Ensure reliability by implementing robust frameworks and testing methodologies, providing trustworthy insights for decision-making. Support enterprise-level data governance initiatives by implementing frameworks and practices that align with organizational standards, ensuring data integrity, security, and compliance. Collaborate with cross-functional stakeholders to translate business objectives into technical solutions. Support the administration of Azure-based databases, including performance tuning, backup/recovery, and maintenance, ensuring database reliability and functionality. Mentor junior team members, fostering a culture of technical excellence and continuous improvement. Evaluate and implement industry-leading tools like Azure Synapse Analytics, Data Lake Storage, and Databricks to enhance the data ecosystem. Analyze and resolve intricate data challenges, employing problem-solving and critical thinking to optimize engineering processes. OUR IDEAL CANDIDATE; 10+ years of professional experience in data engineering or a related field. Advanced proficiency in SQL, including writing and optimizing complex queries, window functions, CTEs, and query tuning for large datasets. Strong experience in database design and managing transactions. Proven expertise in developing large-scale ETL pipelines and data processing automation using PySpark and Python within Microsoft Fabric Notebooks, integrated across the Azure ecosystem. Extensive experience with Microsoft data integration tools, specifically 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/snowflake schemas, Slowly Changing Dimensions (SCD), and data governance frameworks to ensure high-quality, compliant data solutions. Hands-on experience with modern DevOps and CI/CD frameworks, utilizing Git workflows (branching, merging, PRs) and Azure DevOps to automate pipelines, manage environment configurations, and deploy Azure resources. Solid communication skills, with the ability to translate technical concepts into actionable business insights. Demonstrated leadership and strategic capabilities, including mentoring team members, taking ownership of projects, and collaborating effectively with stakeholders to balance deep technical details with overarching business objectives. Microsoft Certified: Fabric Data Engineer Associate (DP-700) is preferred Proficiency in spoken and written French is a plus. WORK AUTHORIZATIONS AND TRAVEL; Travel estimated at 5%, within North America and Europe #LI-SM2 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.