## Business Intelligence Architect/Data ModelerPostuler:

Oakville, ON:

Remote, ON:

Temps Plein:

Publié aujourd'hui:

R2616131À propos de CencoraCherchez-vous à faire une différence dans la vie d’un patient?

Chez AmerisourceBergen, vous trouverez une culture innovante et team-oriented, axée sur le patient et soucieuse de faire la différence.

En tant qu’organisation nous sommes unis par notre responsabilité d’œuvrer pour des vies plus saines. Joignez-vous à nous et postulez dès aujourd’hui# **Ce que vous ferez**PRIMARY DUTIES AND RESPONSIBILITIES:

* Design, develop, and maintain Power BI dashboards, reports, scorecards, and visual analytics solutions that provide clear, accurate, and actionable insights to business stakeholders.* Build, enhance, and support modern data transformation and reporting solutions using Databricks, SQL, and enterprise BI tools.* Understanding or experience of developing, optimizing, and maintaining SSIS ETL workflows to support the extraction, transformation, and loading of data from multiple internal and external systems.* Create and manage robust data models, semantic layers, and reporting datasets that enable scalable analytics, self-service reporting, and trusted decision-making.* Work directly with internal and external clients to gather and clarify business requirements, identify reporting needs, and translate those needs into effective technical solutions.* Partner with cross-functional teams including Infrastructure, Networks, Web/Application Development, Data Engineering, and other IT teams to design and deliver end-to-end BI solutions.* Establish and support standardized methods for extracting, integrating,



and structuring data from a variety of enterprise and operational data sources.* Analyze large and complex datasets to identify patterns, trends, risks, and performance opportunities, and present findings in a concise, business-relevant format.* Develop dataset to support models for AI enablement* Apply knowledge of the pharmaceutical industry, including pharmacy services operations where applicable, to ensure reporting solutions are meaningful, relevant, and aligned to business realities.* Develop reporting solutions in support of business performance management, customer reporting, operational analytics, and strategic initiatives.* Ensure data quality, consistency, integrity, and governance across BI environments by applying best practices in reporting design, documentation, and validation.* Produce and maintain transparent functional and technical documentation, including report logic, data definitions, ETL processes, and solution specifications.* Deliver training, support, and knowledge transfer to end users to increase adoption, understanding, and effective use of BI tools and reporting assets.* Communicate effectively with both technical and non-technical stakeholders, serving as a trusted partner who can explain technical concepts and data insights in a clear and practical way.* Contribute to continuous improvement of BI standards, development processes, reporting frameworks, and analytics capabilities.* Support additional duties and special projects as assigned,



including occasional travel up to 5%.MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

* Bachelor’s degree in information systems, Computer Science, Data Analytics, or a related field.* 7 to 10 years of directly related experience in business intelligence, business analytics, reporting, or data development roles.* Strong hands-on 5+ years' experience with Databricks - related Certifications will be highly desirable* Strong hands-on 5+ years' experience with Power BI, including dashboard development, report design, DAX, Power Query, data modelling, and publishing best practices.* Strong experience with SQL for querying, data transformation, validation, and performance optimization.* Demonstrated experience with SSIS and traditional ETL/data integration workflows.* Experience with Databricks or similar up-to-date data platform technologies for analytics engineering or data transformation.* Strong knowledge of data modelling, data warehousing concepts, and BI solution design.* Experience developing solutions for a range of stakeholders, including business users, leadership teams, and external clients.* Excellent written and verbal communication skills, with the ability to present complex information in a clear, business-friendly manner.* Proven ability to work independently while also collaborating effectively across technical and business teams.

Preferred Qualifications

* Experience in the pharmaceutical, healthcare, or related regulated industry environment.* Knowledge of pharmacy services, specialty pharmacy, patient support programs, reimbursement services, or related business functions.* Experience with legacy or complementary BI/reporting tools such as SAP BusinessObjects, Crystal Rep

📌 Business Intelligence Architect/Data Modeler (Winnipeg)
🏢 Cencora
📍 Winnipeg