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 maintainPower BI dashboards reports scorecards and visual analytics solutionsthat provide clear accurate and actionable insights to business stakeholders.
- Build enhance and support modern data transformation and reporting solutions usingDatabricks SQL and enterprise BI tools.
- Understanding or experience of developing optimizing and maintainingSSIS ETL workflowsto support the extraction transformation and loading of data from multiple internal and external systems.
- SAP Business Objects development experience or SAP Business Objects to PowerBI transition experience
- Create and manage robustdata models semantic layers and reporting datasetsthat 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 includingInfrastructure Networks Web/Application Development Data Engineering and other IT teamsto 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 thepharmaceutical industry includingpharmacy 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 clearfunctional 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 includingoccasional travel up to 5%.

MINIMUM SKILLS KNOWLEDGE AND ABILITY REQUIREMENTS:

Required Qualifications

- Bachelors degree in information systems Computer Science Data Analytics or a related field.
- 7 to 10 years of directly related experiencein 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 withPower BI including dashboard development report design DAX Power Query data modelling and publishing best practices.
- Strong experience withSQLfor querying data transformation validation and performance optimization.
- Demonstrated experience withSSISand traditional ETL/data integration workflows.
- Experience or strong exposure to SAP Business Objects and Crystal reports
- Strong knowledge ofdata modellingdata 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 explicit business-friendly manner.
- Proven ability to work independently while also collaborating effectively across technical and business teams.

Preferred Qualifications

- Experience in thepharmaceutical healthcare or related regulated industry environment.
- Knowledge ofpharmacy services specialty pharmacy patient support programs reimbursement services or related business functions.
- Experience with legacy or complementary BI/reporting tools such asSAP BusinessObjectsCrystal Reports or advanced Excel-based reporting.
- Experience supporting bothinternal operational reportingandexternal 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

What Cencora offers

We provide compensation benefits and resources that enable a highly inclusive culture and support our team members ability to live with purpose every addition to traditional offerings like medical dental and vision care we also provide a comprehensive suite of benefits that focus on the physical emotional financial and social aspects of wellness. This encompasses support for working families which may include backup dependent care adoption assistance infertility coverage family building support behavioral health solutions paid parental leave and paid caregiver leave. To encourage your personal growth we also offer a variety of training programs professional development resources and opportunities to participate in mentorship programs employee resource groups volunteer activities and much more.

Full time

Equal Employment Opportunity

Cencora is committed to providing equal employment opportunity without regard to race color religion sex sexual orientation gender identity genetic information national origin age disability veteran status or membership in any other class protected by federal state or local law.

The companys continued success depends on the full and effective utilization of qualified individuals. Therefore harassment is prohibited and all matters related to recruiting training compensation benefits promotions and transfers comply with equal opportunity principles and are non-discriminatory.

Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment please call (phone hidden) or email . We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned

Accessibility Policy

Cencora is committed to fair and accessible employment requested Cencora will accommodate people with disabilities during the recruitment assessment and hiring processes and during employment.

This posting is intended to fill an existing vacancy for our Business Insights Developer role.

Affiliated Companies:

Affiliated Companies: Innomar Strategies

Required Experience:

IC

📌 Business Insights Developer (Oakville)
🏢 Cencora
📍 Oakville