McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve – we care.

What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you.

Position Description

The candidate will work on a team interacting with all aspects of the business including external customers to support the BI platform, design data models for new products, analyze data, and build reports and dashboards. The ideal candidate should have a data engineering focus with excellent communication and troubleshooting skills. The BI Developer will focus mainly on our on-prem IBM Cognos platform but will also assist as we move systems to the cloud.

Key Responsibilities

• Will start as secondary IBM Cognos administrator and move to primary over time

• Perform routine system maintenance like patching and reinstalling Cognos occasionally when rebuilding systems (Dev, QA, Prod)

• Work closely with IT team to perform system maintenance

• Will serve as technical project lead providing leadership, mentoring, and work guidance to less experienced personnel.

• Capture and analyze requirements to develop and document designs in a business intelligence/data warehouse environment

• Work closely with Business Analysts, Product Managers, and end users to understand business rules and interpret data

• Manage report security & distribution by working with data source owners to authorize groups or individuals can access data

• HIPAA compliance filtering, which limit report users to only what is required for their job or role

• Troubleshooting and problem solving for production issues and end user inquiries.

• Participate in after-hours support as needed

Minimum Requirements

• 4-year degree

• Minimum of 5 years of strong IBM Cognos Analytics development experience

• Minimum of 3 years of IBM Cognos Administration

• Minimum of 3 years’ working experience with Oracle 12c/19c

• Minimum of 3 years’ working experience in an open source environment (Oracle, Red Hat Linux, OpenLDAP).

• Experience installing and testing Cognos patches

• Strong data modeling experience with Oracle and Framework Manager

• Experience with Cognos tools such as Report Studio, Query Studio, Analysis Studio and Cognos Connection

• Experience building complex reports, dashboards, and scorecards

• Experience analyzing data and interpreting results

• Strong technical, SQL, analytical, troubleshooting and problem solving abilities

• Excellent written, verbal, and interpersonal communication skills

Critical Skills

• Advanced data troubleshooting skills

• Excellent written, verbal, and interpersonal communication skills

• Comfortable working interactively with Developers, Product Managers, Account Managers, Customer Support, and external customers

• Great attention to detail

Nice To Have

• Experience using Motio products

• Experience with the IBM Cognos Java SDK is preferred

• Familiarity with Perl, Javascript, HTML, XML, ETL, and Shell Scripting

• Experience with MicroStrategy

• Experience with Tableau in the cloud

• Experience with BigQuery

• Familiar with Jira and Confluence

• Familiar with pharmacy real-time transaction standards

• Familiar with pharmaceutical manufacturer data and marketing methods

We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, please click here.

Our Base Pay Range for this position

$100,100 - $166,900

McKesson is an Equal Opportunity Employer

 

McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson’s full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.

 

Join us at McKesson!