Business Intelligence Analyst

Cencora, Inc.; Ontario; On-site; CAD 80,000 - 100,000; Full time

Job summary

Cencora, Inc. is seeking a Business Intelligence Analyst to manage BI projects and collaborate with teams to design reporting tools. The ideal candidate will have extensive experience in Business Analytics and strong analytical skills. The role involves training users, creating solutions, and analyzing data to support decision-making. Join a company committed to improving lives through innovative health solutions.

Benefits

Medical Benefits

Dental Benefits

Vision Care

Wellness Benefits

Paid Parental Leave

Professional Development

Qualifications

• Minimum 7 to 10 years of experience in Business Analytics.
• Advanced knowledge of pharmaceutical distribution industry.

Responsibilities

• Provide project management for BI solutions.
• Collaborate with customers to gather requirements.
• Analyze large amounts of data for reporting.

Skills

Analytical Skills

Problem Solving

Communication

Leadership

Organizational Skills

Education

Bachelor's Degree in Information Systems

Tools

MS Office

SQL

Business Objects

Crystal Reports

Power BI

Job description

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:

• Provide project management for BI solutions for new customer implementations
• Work with the development team and IT group to design reporting analysis tools for internal and external use;
• Collaborate with external and internal customers to gather comprehensive requirements and document them formally
• Work with the technical team to establish protocols to extract data in a standardized process from a variety of data sources;
• Maintain a good understanding and working experience of transactional and dimensional data models
• Create solutions for clients (internal and external) in various formats, including Excel, Crystal Reports, Business Objects Enterprise, Power BI
• Analyze large amounts of data to provide concise, targeted reports for internal and external clients;
• Train end users on the analytical tools developed by the Business Intelligence team;
• Write functional and/or technical documents;
• The Business Intelligence Analyst will also be assigned other duties and tasks as required from time to time, including possible local travel in Greater Toronto Area (5%)

Experience and Educational Requirements:

• Bachelor's degree or above qualification preferably in Information Systems, Computer Science, or equivalent
• Minimum 7 to 10 years of directly related experience in Business Analytics positions;
• Advanced working knowledge of MS Office, SQL, Business Objects, Crystal Reports
• Good understanding and knowledge of working with Databases, SQL, and scripts;
• Strong analytical and problem-solving skills;
• Familiarity with Database design and modeling techniques, and ETL processes;
• Experience with pharmaceutical industry or wholesale distribution industry would be an asset;
• Experience with IT project management would be an asset;
• Ability to read data models and comprehend database structures and relationships;
• Strong oral and written presentation skills;
• Ability to gather and analyze report requirements effectively;
• Works well cross-functionally and within a small team;
• Excellent team player, open to offering feedback;
• Additional industry certifications would be an asset.

Minimum Skills, Knowledge, and Abilities:

1. Advanced knowledge of pharmaceutical distribution industry
2. Working knowledge of automated warehouse operating systems
3. Strong business and financial acumen
4. Strong analytical and mathematical skills
5. Effective communication skills, both orally and in writing
6. Effective interpersonal and leadership skills
7. Excellent organizational skills with attention to detail
8. Ability to meet deadlines consistently
9. Excellent problem-solving skills and issue resolution
10. Strong presentation skills
11. Proficiency in Microsoft Word, Excel, PowerPoint, and other Office programs

What Cencora offers

We provide compensation, benefits, and resources that foster an inclusive culture and support our team members’ purpose-driven lives. Our offerings include medical, dental, vision care, and a comprehensive suite of wellness benefits, such as support for families, backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental and caregiver leave. We also promote personal growth through training, professional development, mentorship, employee resource groups, volunteer activities, and more.

Equal Employment Opportunity

Cencora is committed to providing equal employment opportunity regardless of race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status, or membership in any protected class. We ensure all employment-related practices comply with non-discrimination laws and provide reasonable accommodations for individuals with disabilities upon request. To request accommodations, contact us at 888.692.2272 or [e-mail]. Messages unrelated to accommodation requests will not be responded to.

Accessibility Policy

Cencora is dedicated to fair and accessible employment practices. We will accommodate individuals with disabilities during recruitment, assessment, hiring, and employment processes upon request.

Affiliated Companies:

Innomar Strategies