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 Real Estate (RE) Data Analyst is a key contributor to the operational and decision-making processes of the McKesson Real Estate (MRE) Technology Team. The RE Data Analyst will work with a number of technology systems of record, assist with dashboard creation, and deliver reports on scheduled and ad hoc bases.
Data sources range from Computerized Maintenance Management System (CMMS), security badge and access control, real estate portfolio management, operational technology (OT), and more. Analytics tools include Snowflake, PowerBI, Tableau, PowerAutomate, and Excel.
The RE Data Analyst collaborates with managers and leaders to ensure timely delivery of high-quality, accurate reporting to help drive business decisions. The RE Data Analyst will also support the Director of Operations Technology with requirements gathering for new automated data pipelines, data governance, and dashboard standards.
At times this role can be involved in projects across the organization that may have scope outside of their primary responsibilities. This candidate should have the ability to be agile during organizational transformation.
Reports and Analysis
Triage incoming ad hoc report requests in collaboration with Data Analysts
Interpret trends and potential impact to end users based on report output
Design data source schema to allow for multi-variate and historical analysis
Package analytics for internal stakeholders via email and PowerPoint
Creation of PowerBI dashboards consistent with existing visualization standards, connected to live sources across Snowflake, SharePoint, and other sources
Requirements Gathering
Work with end user stakeholders to facilitate and document business and functional requirements for new project initiatives
Help to prioritize various requirements with end users
Contribute to solution comparison and evaluation as part of RFPs and business case creation
Systems Maintenance
Review changes to existing data source schemas to determine impact to automated pipelines
Troubleshoot and remedy automation failures within data source systems and PowerAutomate
Adhere to and contribute to data schema and dashboard standards maintenance
Minimum Job Qualifications:
Critical Skills
Strong verbal and written communication skills with all organizational levels
Comfort with using data for executive-level storytelling
Experience with PowerBI DAX and PowerQuery custom columns and calculations
Problem-solving skills to find multiple viable solutions for a challenge
Analytical skills to process and interpret large amounts of data
Strong multitasking and time management skills
Ability to work independently or across teams
Preferred, Nice to Have, Specialized Knowledge/Skills:
Ability to write and work with SQL queries, nested subqueries, and fun stuff like JOINs
Exposure to data governance programs to optimize data freshness, quality, and accuracy
Knowledge of Office Scripts for dynamic ETL of Excel files
Exposure to real estate technology, operations technology (OT), IoT sensors, etc.
Education/Experience:
Degree or equivalent and 7+ years of relevant experience.
Working Conditions:
Environment (Office, warehouse, etc.) - Office or Remote
(This description is general in nature and is not intended to be an exhaustive list of all responsibilities. Other duties may be assigned as needed to meet company goals.)
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
$79,900 - $133,100
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.
