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 design and development of data pipelines for complex business and technology initiatives, analytical and reporting solutions, along with providing thought leadership, navigating us through production issues and investigations, and being a key advocate of efficiency and continual improvement as we work to modernize.

Major Responsibilities

Collaborate with stakeholders to understand their data requirements and translate them into effective data solutions
Provide technical design, coding, testing, implementation, maintenance, system, and technical support for BI initiatives
Design and development ETL solutions on multiple complex initiatives
Develop and maintain automated data pipelines
Investigate the data platform failures, perform root cause analysis, and implement fixes
Relational and multidimensional data models design and development
SPs optimization
Reports re-design and new reports development
Ensure that applications are followed best data engineering practices and standards
Collaborate with business partners and technical teams on data quality to ensure data accuracy, integrity, consistency, and security
Support self-service reporting and resolve issues in a timely fashion towards a stable BI environment
Develop and update technical documentation
Stay up-to date with best data engineering practices

Education and Experience

Degree in Computer Science, Information Technology, or related discipline
8+ years of progressive experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server, Microsoft CP, tools and services
Extensive automated data pipelines development in the past 5 years
Experience in data modelling and reports development
Experience with various data types and associated lifecycles
Strong T-SQL skills
Solid knowledge of database fundamentals and performance tuning
Solid knowledge of relational and dimensional modelling concepts
Expert with Microsoft suite – SSIS, SSRS, Power BI
Experience with Azure data services and applications Azure Data Factory, Azure Data Lake, Azure Databricks, Synapse
Experience with medallion data architecture
Experience in supply chain industry and multi-echelon inventory optimization is an asset
Microsoft Certified

Qualifications

Strong attention to detail and the ability to prioritize and manage multiple tasks simultaneously
Excellent communication skills and ability to work collaboratively with a wide range of stakeholders
Ability to work in a team environment, as well as independently with minimal supervision

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.

Jobs at Kohl & Frisch Ltd

Apply to Business Intelligence Engineer