Logo of Huzzle

Home

Matches

Explore

Manage

Business Intelligence Analyst

image

Cencora

Sep 10, 2024

  • Job
    Full-time
    Senior & Expert Level
  • Data
    Business, Operations & Strategy
  • Oakville
  • Quick Apply

AI generated summary

  • You need a bachelor’s degree, 7-10 years in business analytics, advanced SQL/Business Objects skills, strong analytical abilities, and experience in the pharmaceutical or wholesale distribution industry.
  • You will analyze data for reports, develop client solutions, gather requirements, document processes, manage BI projects, collaborate on design, standardize data extraction, and train end users.

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 position(s)
  • Advanced working knowledge of Business Objects, MS Office, SQL, Crystal Reports
  • Knowledge of Microsoft Word, Excel, PowerPoint
  • Must possess strong analytical and problem-solving skills
  • Strong ability to gather and analyze report requirements
  • Strong oral and written presentation skills
  • Good understanding and knowledge of working with Databases, SQL and scripts
  • Works well cross-functionally and within a small team
  • Excellent team player, and is not afraid to offer feedback
  • Familiar with Database design and modeling techniques, and ETL process
  • 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
  • Any additional industry certifications would be an asset
  • Knowledge of at least one business intelligence tool
  • Strong analytical and mathematical skills
  • Knowledge of other Microsoft Office Programs
  • Excellent problem-solving skills; ability to resolve issues effectively and efficiently
  • Effective organizational skills; attention to detail
  • Ability to consistently meet deadlines
  • Strong business and financial acumen
  • Ability to communicate effectively both orally and in writing
  • Effective interpersonal and leadership skills
  • Advanced knowledge of pharmaceutical distribution industry
  • Working knowledge of automated warehouse operating system
  • Excellent presentation skills

Responsibilities

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

FAQs

What is the primary role of the Business Intelligence Analyst at Cencora?

The primary role of the Business Intelligence Analyst is to work with internal and external clients to develop reporting and analytics solutions, analyzing large data sets and creating targeted reports in various formats.

What qualifications are required for this position?

Candidates should have a Bachelor’s degree in Information Systems, Computer Science, or a related field, along with 7 to 10 years of relevant experience in Business Analytics.

What technical skills are essential for this position?

Essential technical skills include advanced knowledge of Business Objects, SQL, Crystal Reports, and MS Office applications, particularly Excel.

Is experience in the pharmaceutical industry preferred?

Yes, experience in the pharmaceutical industry or wholesale distribution is considered an asset.

What kind of projects will the Business Intelligence Analyst manage?

The Business Intelligence Analyst will provide project management for BI solutions, particularly for new customer implementations and the development of reporting analysis tools.

Are training opportunities available for new hires?

Yes, Cencora offers a variety of training programs, professional development resources, and mentorship opportunities to support personal growth.

Does the job involve any travel?

Yes, the position may require occasional travel, estimated at around 5%.

What kind of environment does Cencora promote?

Cencora promotes an inclusive culture with a focus on supporting the physical, emotional, financial, and social aspects of wellness for all team members.

What additional certifications would be considered an asset?

Any additional industry certifications relevant to Business Intelligence, analytics, or the pharmaceutical distribution industry would be considered an asset.

What is the company's stance on equal employment opportunity?

Cencora is committed to providing equal employment opportunity without discrimination based on race, color, religion, sex, sexual orientation, gender identity, and other protected classes.

image

Cencora

Science & Healthcare
Industry
10,001+
Employees

Mission & Purpose

Cencora, a company building on the legacy of AmerisourceBergen, is a leading global pharmaceutical solutions organization centered on improving the lives of people and animals around the world. We connect manufacturers, providers, and patients to ensure that anyone can get the therapies they need, where and when they need them. We also help our partners bring their innovations to patients more efficiently to accelerate positive outcomes. Becoming Cencora has allowed us to combine all the companies and services of AmerisourceBergen. Now, as a unified and internationally inclusive brand, we’re continuing to invest in and focus on our core pharmaceutical distribution business, while also growing our platform of pharma and biopharma services to support pharmaceutical innovation and access. Our 46,000+ worldwide team members are shaping the future of healthcare through the power of our purpose: We are united in our responsibility to create healthier futures.