Business Intelligence Architect/Data Modeler

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 standardiz