Business Intelligence Engineer at Kohl & Frisch
Concord, Ontario, Canada — internship
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
The Business Intelligence Engineer is responsible for
supporting the stability of our current reporting landscape while helping design the next generation of data and reporting solutions. This is an exciting opportunity to work with Microsoft Fabric, Power BI, and Power Automate in a dynamic, collaborative, and forward‑thinking environment.
Major Responsibilities
Learn and navigate the company’s evolving data landscape, including legacy SSRS, new ERP data structures, and Microsoft Fabric components.
Develop data flows, Power BI dashboards and reports for internal and external stakeholders.
Troubleshoot data issues, investigate root causes, and drive resolution across systems and data sources.