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
- Degree in Computer Science, Information Technology, or a related field
- 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.