Senior Data Architect

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.

Current Need:

The Senior Data Engineer/Solution Architect will be responsible for implementing, managing the overall data architecture, and developing advanced data analytics tools to facilitate GPO Team complex business functions.

* This is a Hybrid role and requires the candidate to reside within a commutable distance to our office in The Woodlands, TX.

Job Summary:

The role will support McKesson GPO Analytics processes and will provide process automation solutions to other GPO stakeholders, including topics such as:

• ETL Data processing using SAP BW, Snowflake
• Creating data model, data mart based on complex business requirements
• Transform raw data into actionable insights and provide strategic recommendations
• Support GPO technology roadmap
• Other analytical support including ad-hoc reporting, data extracts on demand
• AI Modeling and building Agents

Key Responsibilities:

• Developing advanced SQL Script to facilitate business functions.
• Maintain, enhance existing data model process and BI data extracts.
• Collaborate with other teams for data acquisition.
• Coordinate system development with IT to enhance automation and visibility.
• Collaborating with business stakeholders to understand their data needs and define the organization's data strategy. This involves identifying data requirements, establishing data governance policies, and defining data standards and best practices.
• Create conceptual and logical to represent the team's data assets. This includes designing data schemas, data flows, and data integration patterns to ensure data integrity, consistency, and accessibility.
• Overseeing the implementation of data modeling, database optimization and servers maintenance.
• Design and implement efficient and scalable data integration processes, including extraction, transformation, and loading (ETL) processes. This involves understanding data sources, defining data mappings and transformations, and ensuring data accuracy and consistency.
• Collaborate with data analysts to define data requirements for analytics and reporting purposes. This includes designing data marts to support business intelligence and reporting needs.
• Evaluate and recommend data effective management technologies, tools, and platforms that best fit the organization's needs. This involves staying up-to-date with industry trends and emerging technologies in data management and analytics.
• Create visually appealing and informative reports, dashboards, and presentations to communicate findings to both technical and non-technical stakeholders.
• Provide actionable recommendations and strategic insights to support business planning, forecasting, and decision-making processes.

Minimum Requirement:

• Degree or equivalent and typically requires 7+ years of data architecture and/or data modeling experience.

Critical Skills:

• Projects with related skills such as programming, Advanced SQL, Reporting
• Comfortable working with complex SQL Script
• Database management and good practice with data governance
• Fast learner and able to work independently
• Outstanding problem solving and analytical skills
• Demonstrated proficiency analyzing and manipulating large data sets
• Excellent verbal and written communication skills
• Good working knowledge in Excel, Power BI and/or Tableau
• Familiarity AI modeling, building Agents

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

$130,400 - $217,300

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!