## Business Intelligence Architect/Data Modeler Apply: Oakville, ON: Remote, ON: Full time: Posted Today: R Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!# **Job Details****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

📌 Business Insights Data Developer (Oakville)
🏢 Cencora
📍 Oakville