Business Intelligence & Automation Analyst

MML McKesson Medical-Surgical Government Solutions LLC; Richmond (VA); Vor Ort; USD 89.000 - 148.000; Vollzeit

Zusammenfassung

McKesson is seeking a Business Intelligence & Automation Analyst to transform complex business needs into scalable reporting, BI dashboards, and automated workflows. You will own dashboards and automated data processes using SQL, Power BI or Looker, Python, and cloud data platforms.

The role partners with business and technical stakeholders, delivering analyses and recommendations while maintaining data quality and production reliability across Snowflake and BigQuery environments in a fast-paced

Qualifikationen

• Bachelor's degree or equivalent experience in analytics or BI.
• Experience with BI/reporting or automation projects.
• Production dashboards using Power BI or Looker.

Aufgaben

• Serve as the primary analytics partner for an assigned business area, understanding processes, data sources, KPIs, and reporting needs.
• Design, develop, test, deploy, and enhance Power BI or Looker dashboards and analytical solutions.
• Own performance and reliability of reporting solutions, including data quality and refresh monitoring.
• Write and optimize SQL in Snowflake or BigQuery with complex joins and transformations.
• Build automation and data-processing solutions using Python, Power Automate, Google Apps Script, JavaScript, and related tools.
• Automate reporting and data ingestion from Excel, Google Sheets, CSV/TXT, APIs, and cloud data warehouses.
• Apply controls, validation, logging, monitoring to production automation solutions.
• Deliver ad hoc analyses, reconciliations, and data extracts for decision support.

Kenntnisse

Advanced SQL

Analytics storytelling

Stakeholder collaboration

Ausbildung

Bachelor's degree

Tools

Power BI

Looker

Python

Power Automate

Google Apps Script

JavaScript

Snowflake

Google BigQuery

Jobbeschreibung

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.

Business Intelligence & Automation Analyst

The Business Intelligence & Automation Analyst will serve as a key analytics partner for an assigned business area, transforming complex business needs into scalable reporting, business intelligence, and automation solutions. In this role, you will own and enhance dashboards, reporting solutions, and automated workflows that improve data accessibility, reduce manual effort, and support better business decisions. You will work with technologies including SQL, Power BI or Looker, Python, Power Automate, Google Apps Script/JavaScript, Snowflake, and Google BigQuery while partnering with business and technical stakeholders. This is an individual-contributor opportunity well suited for an experienced BI or analytics professional who enjoys combining hands‑on technical development with business partnership and end‑to‑end ownership.

What You'll Do

• Serve as the primary analytics partner for an assigned business area, developing an understanding of business processes, data sources, KPIs, and reporting needs.
• Design, develop, test, deploy, and enhance Power BI or Looker dashboards and analytical solutions.
• Own the ongoing performance and reliability of reporting solutions, including data quality, refresh monitoring, troubleshooting, documentation, and enhancements.
• Write and optimize advanced SQL in Snowflake or Google BigQuery, including complex joins, CTEs, window functions, aggregations, and reusable data transformations.
• Build automation and data‑processing solutions using Python, Power Automate, Google Apps Script, JavaScript, and other workflow or RPA technologies.
• Automate reporting and data ingestion from sources including Excel, Google Sheets, CSV/TXT files, APIs, and cloud data warehouses.
• Apply appropriate controls, validation, exception handling, logging, monitoring, and documentation to production automation solutions.
• Deliver complex ad hoc analyses, reconciliations, cost studies, data extracts, and other decision‑support analysis.
• Partner with business leaders and technology teams to define requirements, prioritize solutions, and drive adoption.
• Present analytical findings and recommendations to stakeholders and provide technical guidance to other analysts.

Basic Requirements

• Bachelor's Degree or an equivalent combination of relevant education and professional experience.
• Demonstrated experience in business intelligence, data analytics, reporting, or analytics automation.
• Hands‑on experience developing production dashboards with Power BI or Looker.
• Advanced SQL experience, including complex queries, joins, CTEs, window functions, and data transformation.
• Hands‑on experience using Python for data processing, reporting, or automation.
• Experience with workflow or process automation using Power Automate, RPA tools, Google Apps Script, JavaScript, or comparable technology.
• Experience working with cloud data platforms such as Snowflake or Google BigQuery.

Preferred Skills/Experience

• Experience owning analytics or reporting solutions for a business or functional area.
• Experience with DAX, Power Query, LookML, ETL/ELT, dimensional modeling, semantic models, or source‑to‑target mapping.
• Experience automating Excel or Google Sheets reporting using Python, pandas, openpyxl, Google APIs, or related tools.
• Experience ingesting and transforming structured data from spreadsheets, flat files, APIs, and enterprise systems.
• Familiarity with source control, deployment pipelines, workflow orchestration, job monitoring, or YAML.
• Experience with dashboard governance, documentation, lifecycle management, and data quality controls.
• Experience analyzing ERP, operational, financial, sales, or customer data.
• Experience in healthcare, distribution, finance, retail, or government‑related analytics.
• Relevant certification in business intelligence, analytics, automation, or cloud data technologies.
• Strong stakeholder communication, project management, presentation, and technical mentoring skills.

Compensation

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.
Our Base Pay Range for this position $88,900 - $148,100.

Equal Employment Opportunity

McKesson is an Equal Opportunity Employer. McKesson provides equal employment opportunities to applicants and employees, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, genetic information, or any other legally protected category. 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 (United States) [e-mail] or (Canada) [e-mail].