What are the responsibilities and job description for the Business Intelligence Engineer position at Kohl & Frisch Ltd?
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, a long 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
Qualifications
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.
