Business Intelligence Developer

McKesson; Columbus (OH); Remote; USD 100,000 - 167,000; Full time

Job summary

An impact-driven company is seeking a BI Developer to enhance its BI platform and support data-driven decisions. This role involves working with IBM Cognos and transitioning to a new cloud-based Power BI Databricks platform. You will collaborate with cross-functional teams to analyze data, design models, and create insightful reports. If you are passionate about data engineering and want to make a difference in healthcare, this is the opportunity for you. Join a team that values innovation and growth, and be part of shaping the future of health for communities and patients alike.

Benefits

Annual bonus opportunities

Competitive compensation package

Remote working flexibility

Diverse and inclusive environment

Qualifications

• 4+ years of relevant experience in data engineering and BI.
• Strong experience in IBM Cognos development and administration.

Responsibilities

• Manage IBM Cognos platform and support BI initiatives.
• Lead technical projects and mentor junior team members.

Skills

IBM Cognos Analytics

Data Modeling

SQL

Troubleshooting

Communication Skills

Education

4-year degree

Tools

IBM Cognos

Oracle 12c/19c

Power BI

Databricks

MicroStrategy

Tableau

Jira

Confluence

Job description

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.

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 and will also assist as we move systems over time to new cloud Power BI Databricks platform.

Key Responsibilities

• Will start as secondary IBM Cognos administrator and move to primary when fully trained.
• 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.
• Work with team to build out new cloud Power BI platform.

Minimum Qualifications:

Degree or equivalent and typically requires 4+ years of relevant experience. Candidate must be based in the metropolitan area of our hub city Columbus, OH. Position will primarily allow for remote working, but candidate must reside in the Columbus, OH area and be willing to come into the office from time to time for key meetings and face time. We are unable to provide sponsorship now or in the future for this position.

Education:

• 4-year degree

Critical Skills:

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

Preferred Skills:

• 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.
• Advanced data troubleshooting skills.
• Comfortable working interactively with Developers, Product Managers, Account Managers, Customer Support, and external customers.
• Great attention to detail.

Additional Knowledge:

• 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 Power BI.
• Experience with Databricks.
• Familiar with Jira and Confluence.
• Familiar with pharmacy real-time transaction standards.
• Familiar with pharmaceutical manufacturer data and marketing methods.

Starting Pay is between $115,000 to $120,000 based on skills and qualifications for this role in Columbus OH.

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. The pay range shown below is aligned with McKesson's pay philosophy, and pay will always be compliant with any applicable regulations. 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!