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.