Business Intelligence Developer

PRIMARY DUTIES AND RESPONSIBILITIES:

• Proficiency in Power BI Desktop and Power BI Service for creating interactive dashboards and reports.

• Strong understanding of data modeling, data transformation, and DAX (Data Analysis Expressions) for effective data analysis.

• Experience with connecting to various data sources (e.g., SQL databases, Excel, cloud services) and ensuring data integrity.

• Ability to collaborate with stakeholders to gather requirements and translate business needs into analytical solutions.

• Familiarity with Power Query and data visualization best practices to enhance user experience and engagement.

• Advanced development skills using SAP Business Objects Suite

• ETL development skills using SQL server, SSIS

• Advanced data modelling and data warehousing skills

• Creating solutions for clients (internal and external) in a number of formats, including PowerBI, Excel, Crystal Reports, Business Objects Enterprise;

• Work with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions 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;

• Writing functional and/or technical documents

• Analyzing large amounts of data to provide concise, targeted reports for internal and external clients;

• The Business Intelligence Specialist will also be assigned other duties and tasks as required from time to time and including possible travel (5%)

EXPERIENCE AND EDUCATIONAL REQUIREMENTS:

• Bachelor 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 with MS Office, SQL, Business Objects, Crystal Reports

• Good understanding and knowledge of working with Databases, SQL and scripts.

• Must possess strong analytical and problem-solving skills;

• 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;

• Strong oral and written presentation skills;

• Strong ability to gather and analyze report requirements;

• Works well cross-functionally and within a small team;

• Excellent team player, and is not afraid to offer feedback.

• Any additional industry certifications would be an asset

MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

• Advanced knowledge of pharmaceutical distribution industry

• Working knowledge of automated warehouse operating system

• Strong business and financial acumen

• Strong analytical and mathematical skills

• Ability to communicate effectively both orally and in writing

• Effective interpersonal and leadership skills

• Effective organizational skills; attention to detail

• Experience with problem, Change and Incident Management practices (ITIL)

• Ability to consistently meet deadlines

• Excellent problem-solving skills; ability to resolve issues effectively and efficiently

• Excellent presentation skills

• Knowledge of Microsoft Word, Excel, PowerPoint and other Office Programs

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 day. In 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 company’s 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 888.692.2272 or email [email protected]. 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 practices. When requested, Cencora will accommodate people with disabilities during the recruitment, assessment and hiring processes and during employment.

Affiliated Companies:Affiliated Companies: Innomar Strategies