Business Intelligence Engineer at Kohl & Frisch Ltd Ontario, CA

kozmetickesluzby.vecnakraska.sk - Jobboard; Ontario (CA); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Opportunities for growth and learning

Collaborative team environment

Hands-on experience with Microsoft technologies

Job summary

Kohl & Frisch Ltd. is seeking a Business Intelligence Engineer in Ontario, CA, to drive the transition to an Azure-based BI ecosystem. The position requires 5+ years of experience in data engineering.

Responsibilities include developing data pipelines, optimizing reporting solutions, and ensuring data integrity while utilizing Microsoft Fabric and Power BI. This hybrid role emphasizes collaboration, innovation, and professional development.

Qualifications

• 5+ years of experience in data engineering and BI solutions.
• Strong expertise in ETL/ELT, SQL-based data transformation, and data modeling.
• Proficiency in Power BI (DAX, Power Query) and SSRS.

Responsibilities

• Partner with stakeholders to understand data needs and create scalable, efficient solutions.
• Design and maintain automated data pipelines using Microsoft Fabric and Azure Data Factory.
• Optimize SQL queries and stored procedures to improve reporting and data processing performance.

Skills

ETL/ELT

SQL-based data transformation

Proficiency in Power BI

Experience with Azure Data Factory

Microsoft Certification in Azure Data Engineering

Education

5+ years of experience in data engineering

Tools

Microsoft Fabric

Data Lake

Synapse

Databricks

Job description

Business Intelligence Engineer job at Kohl & Frisch Ltd. Ontario, CA.

POSITION: Business Intelligence Engineer

STATUS: Full-Time, Hybrid

LOCATION: Kohl & Frisch Limited (Concord, ON )

REPORTS TO: Manager, IT Business Intelligence Services

DEPARTMENT: IT Systems & Development

Founded in 1916, Kohl & Frisch Limited has a solid reputation in the healthcare industry that distinguishes it as the only national, Canadian-owned and operated wholesale distributor. A family-owned company, it is one of Canada’s leading national distributors and is the essential link between pharmaceutical manufacturers and healthcare providers. Kohl & Frisch is fully equipped to service large chain retailers, independent pharmacies, clinics, and hospitals for all their Rx, OTC, home healthcare, and front shop needs.

Primary Role of This Position

Are you passionate about building modern data solutions in the cloud? Do you thrive in a fast-evolving environment where data is at the heart of business transformation? We’re looking for a skilled Business Intelligence/Data Engineer to help drive our transition to a cutting-edge Azure-based BI ecosystem. As part of our team, you’ll design and develop data pipelines, optimize reporting solutions, and play a key role in evolving our data landscape from legacy systems to the latest Microsoft technologies. While our transition progresses, you’ll be instrumental in ensuring data integrity and supporting seamless reporting. This is an exciting opportunity to work with Microsoft Fabric, Azure Data Factory, and Power BI in a dynamic and forward-thinking environment.

IN OFFICE REQUIREMENTS – Tuesday, Wednesday, Thursday

Major Responsibilities

• Partner with stakeholders to understand data needs and create scalable, efficient solutions
• Design and maintain automated data pipelines using Microsoft Fabric and Azure Data Factory
• Develop and implement ETL/ELT processes to support data migration from SSIS to Fabric and Azure
• Optimize SQL queries and stored procedures to improve reporting and data processing performance
• Renovate and enhance existing Power BI and SSRS reports
• Ensure data accuracy, consistency, and security within BI solutions
• Support self-service BI initiatives, empowering business users with high-quality, accessible data
• Collaborate with business and technical teams to enhance data usability and accessibility
• Document technical designs and contribute to continuous improvement

Beyond the Transition – Your Future Impact

After the successful transition to Microsoft Fabric and Azure-based BI solutions, your role will evolve to:

• Enhance data pipelines for efficiency and scalability
• Maintain and advance data architecture to meet evolving business needs
• Develop advanced analytics and reporting capabilities leveraging Azure technologies and Power BI
• Automate and optimize data processing for peak performance
• Monitor and improve data quality, governance, and security frameworks
• Research and implement cutting-edge Microsoft data solutions
• Provide mentorship and knowledge-sharing to elevate the entire team

What You Bring

• 5+ years of experience in data engineering and BI solutions
• Strong expertise in ETL/ELT, SQL-based data transformation, and data modeling
• Proficiency in Power BI (DAX, Power Query) and SSRS
• Hands-on experience with Azure Data Factory, Data Lake, Synapse, Microsoft Fabric, and Databricks
• Experience with medallion data architecture (preferred)
• Understanding of data governance and security standards
• Supply chain industry data experience is a plus (preferred, not required)
• Microsoft Certification in Azure Data Engineering is a strong asset

Who You Are

• A problem-solver who enjoys tackling complex data challenges
• A self-started who thrives in a fast-paced, evolving environment
• Passionate about efficiency, automation, and innovation in data engineering
• A collaborative team player who enjoys sharing knowledge and learning from others

Why Join Us?

• Work on a high-impact transformation, shaping the future of BI at Kohl & Frisch
• Gain hands-on experience with cutting-edge Microsoft technologies
• Be part of a collaborative, forward-thinking team that values innovation
• Enjoy opportunities for growth, learning, and professional development

If you’re ready to take your data engineering career to the next level, apply now and be part of this exciting transformation!

Kohl & Frisch would like to thank all applicants for their interest. Only those candidates who are selected for an interview will be contacted.

Kohl & Frisch Limited welcomes applications from individuals with disabilities and provides accommodations upon request for candidates taking part in the selection process.