BI Analytics & Automation Architect

McKesson; Richmond (VA); On-site; USD 89,000 - 148,000; Full time

Job summary

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

Qualifications

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

Responsibilities

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

Skills

Advanced SQL

Analytics storytelling

Stakeholder collaboration

Education

Bachelor's degree

Tools

Power BI

Looker

Python

Power Automate

Google Apps Script

JavaScript

Snowflake

Google BigQuery

Job description

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