Business Intelligence Architect, Data Modeler

🕒 October 28

🇨🇦 Canada – Remote

⏰ Full Time

🟠 Senior

📚 Business Intelligence Analyst

Where this job comes from

Posted on Cencora's careers page ↗Cencora's careers page, not through a job board

First seen by Remote Rocketship October 28

Still open on Cencora's site. Checked 2 hours ago.

Apply Now
Logo of Cencora

Cencora

10,000+ employees

💼 Consulting

📦 Logistics

🏥 Healthcare

Consulting • Logistics • Healthcare

Cencora is a company dedicated to improving the health and well-being of both people and animals globally. Built on the legacy of AmerisourceBergen, Cencora offers a wide range of industry-leading solutions that encompass specialty logistics, warehousing, drug research, clinical development support, and more. They provide commercialization and patient access support and offer wholesale and specialty distribution services. Cencora serves a diverse clientele, including pharmaceutical companies, physician practices, pharmacies, and health systems. The company also extends its services to animal health, managing operations and delivering products for animal pharmaceutical care. With a strong global footprint, Cencora aims to reshape healthcare delivery through innovative products and solutions, striving to create healthier futures for all.

📋 Description

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and visual analytics solutions • Build, enhance, and support data transformation and reporting solutions using Databricks, SQL, and enterprise BI tools • Develop, optimize, and maintain SSIS ETL workflows • Create and manage data models, semantic layers, and reporting datasets • Gather and clarify business requirements and translate them into technical solutions • Partner with Infrastructure, Networks, Web/Application Development, Data Engineering, and other IT teams • Establish standardized methods for extracting, integrating, and structuring enterprise and operational data • Analyze complex datasets and present business-relevant findings • Develop datasets supporting AI enablement • Apply pharmaceutical industry and pharmacy services knowledge to reporting solutions • Develop reporting for business performance management, customer reporting, operational analytics, and strategic initiatives • Ensure data quality, consistency, integrity, and governance • Produce functional and technical documentation • Deliver training, support, and knowledge transfer to end users • Communicate technical concepts and data insights to technical and non-technical stakeholders • Contribute to BI standards, development processes, reporting frameworks, and analytics capabilities • Support special projects and occasional travel up to 5%

🎯 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 • 5+ years' experience with Databricks • 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 business users, leadership teams, and external clients • Excellent written and verbal communication skills • Ability to work independently and collaborate across technical and business teams • Databricks-related certifications are highly desirable • Preferred: experience in pharmaceutical, healthcare, or regulated industry environments; pharmacy services; SAP BusinessObjects; Crystal Reports; advanced Excel reporting; data governance; reporting controls; enterprise reporting standards; user training and BI adoption

🏖️ Benefits

• Medical, dental, and vision care • Backup dependent care • Adoption assistance • Infertility coverage • Family building support • Behavioral health solutions • Paid parental leave • Paid caregiver leave • Training programs • Professional development resources • Mentorship programs • Employee resource groups • Volunteer activities

Apply Now

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Developed by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok