## Business Intelligence Architect/Data ModelerPostuler: Oakville, ON: Remote, ON: Temps Plein: Publié aujourd'hui: R2616131**À propos de Cencora**Cherchez-vous à faire une différence dans la vie d’un patient? Chez AmerisourceBergen, vous trouverez une culture innovante et collaborative, 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 clear 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 modern 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 setting.* 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 Reports, or advanced Excel-based reporting.* Experience supporting both internal operational reporting and external client-facing analytics solutions.* Familiarity with data governance, reporting controls, and enterprise reporting standards.* Experience training users and supporting BI adoption across diverse stakeholder groups. **Key Skills and Competencies** Technical Skills* Power BI* Databricks* SQL* SSIS* Data modelling* Data warehousing* ETL development* Dashboard and report design* Business analytics* Data validation and quality assurance **Business and Professional Skills** * Requirements gathering and business analysis* Stakeholder management* Client-facing communication* Problem-solving and analytical thinking* Documentation and process design* Presentation and data storytelling* Cross-functional collaboration* End-user training and support**Ce qu’AmerisourceBergen offre** Nous offrons une rémunération globale concurrentielle. Notre engagement envers nos associés comprend l’offre de programmes d’avantages sociaux complets, diversifiés et conçus pour répondre aux divers besoins de l’ensemble de nos associés. Grâce à notre présence mondiale et nos diverses unités commerciales, nous avons une approche équilibrée des avantages que nous offrons. De nombreux avantages sociaux sont payés par l’entreprise, tandis que d’autres sont offerts par les cotisations des associés. Les offres d’avantages sociaux spécifiques peuvent varier selon l’emplacement, le poste ou l’unité d’affaires.Temps Plein**Égalité d’accès à l’emploi**AmerisourceBergen s'engage à offrir des possibilités d'accès à l'emploi égales sans égard à l’origine ethnique, à la couleur, à la religion, au sexe, à l’orientation sexuelle, à l’identité de sexe, aux renseignements génétiques, à la nationalité, à l'âge, aux handicaps, au statut de vétéran ou à l’adhésion à toute autre classe protégée par la loi fédérale, d’État ou locale.# **Politique sur l’accessibilité***AmerisourceBergen a adopté des pratiques d’emploi justes et accessibles.* Sur demande, AmerisourceBergen offrira des mesures d’adaptation aux personnes handicapées durant les processus de recrutement, d’évaluation et d’embauche et tout au long de leur emploi.This posting is intended to fill an existing vacancy for our Business Intelligence Architect/Data Modeler role.
#J-18808-Ljbffr

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