McKesson Corp is a Fortune 7 company and one of the largest providers of medicines, pharmaceutical supplies and health information technology (IT) products and services in the United States with revenues of $208.4 billion in 2018. The company was founded in 1833 by John McKesson and Charles Olcott in New York with a focus on importing and wholesaling pharmaceutical products. United by our ICARE values, McKesson's 78,000 employees work together every day to make better care possible for patients around the globe.

McKesson is currently seeking a Jr Associate Business Intelligence Analyst for our Scottsdale, AZ office.

Position Description

This position will collect, manipulate and analyze business data from a variety of clients and sources. Preparing reports, in the form of visualizations such as graphs, charts and dashboards, detailing the significant results they deduced. A primary role will be to guard and protect the organization's data, making sure that the data repositories produce consistent, reusable data. You will be required to work closely with both internal teams and external customers to understand, define, and replicate best practices related to data quality and integrity programs. Responsibilities will include interpreting data, creating ad hoc reports, modifying and updating standard reports when applicable.

Key Responsibilities

• Uses Structured Query Language (SQL) to gather and assess data on a daily basis from the reporting database, transactional database, operational data store, and external systems to assist internal and external leadership in decision making. Documents program data requests, results, SQL code, and logs time in the JIRA tracking system.

• Authenticates and interprets data based on results using a variety of techniques, ranging from simple data aggregation, using approved analytical models and ensuring adequate QA of output and results, and that findings, results, methodology, SQL code, and time spent on requests are logged in the JIRA tracking system.
• Communicates and disseminates the results of information gathering using BI software, SSRS, and/or Excel to name a few, as per the agreed timing, whether this is daily, weekly, monthly, yearly, or aggregated level data.
• Continually assesses data quality throughout the database and coordinates with IT in the correction of source data or creation of translation sources, where applicable. Where appropriate update the related reporting BRD and ensure that the new BRD is stored in the shared BRD folder.
• Using specific tool capabilities such as SAP Business Objects, Microsoft PowerBI, Tableau etc., analyze, visualize, and where appropriate publish to internal and external clients the data findings. This includes updating reporting BRD's if applicable.
• Monitor the programs at least monthly to support continuous quality improvement efforts using performance metrics development and monitoring, and effectively communicate this to stakeholders via strategic business reviews, scheduled meetings, or where required appropriate escalation.

Minimum Job Qualifications (Knowledge, Skills, & Abilities):

Typically requires 1- 2+ years of professional experience in addition to data analytics experience.

Education/Training -

4 year degree or equivalent experience. (Computer science, engineering, analytics, finance, or business)

Business Experience -

• 1-2+ years of experience in data analytics.
• Basic skills with SQL, Excel, data visualization and analytics tools.
• Excellent communication and presentation skills in presenting analytic results and findings at all levels internally and externally.
• Detailed understanding and experience with process documentation and improvement for gaining operational efficiency.
• Ability to see the business picture from the analytics data

Specialized Knowledge/Skills -

• SQL

Nice to Have

• Healthcare or pharmaceutical industry, highly preferred
• Python, Tableau, SAS, R, Power BI, SPSS, Stata, BOBJ etc..

Career Level - IC - Professional - P2

McKesson is an Equal Opportunity/Affirmative Action employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status.Qualified applicants will not be disqualified from consideration for employment based upon criminal history.

McKesson is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including job seekers with disabilities. If you need a reasonable accommodation to assist with your job search or application for employment, please contact us by sending an email to McKessonTalentAcquisition@mckesson.com . Resumes or CVs submitted to this email box will not be accepted.

Current employees must apply through the internal career site.

Join us at McKesson!