DataJobs.io
← Back to all jobs

Job Description

At Heartland Dental, this role partners closely with Strategic Sourcing to turn purchasing data into actionable insights that support better supplier relationships, stronger negotiations, and measurable improvements to business KPIs. As a Senior Data Analyst, you will lead reporting and analytics, including end-to-end ownership of Strategic Sourcing migration to Google Cloud Platform (GCP), while building trusted data foundations and decision-ready dashboards.

What you’ll do

  • Own analysis of supplies, labs, and equipment spend across 2,000+ offices, covering pricing, supplier performance, and formulary compliance to identify savings and sourcing opportunities.
  • Investigate root causes by finding outliers and explaining drivers behind the numbers so Category Managers can use insights during negotiations and to meet their KPIs.
  • Build the fact base for category strategies, sourcing events, supplier reviews, and negotiations, including baseline spend, benchmarks, and side-by-side scenarios.
  • Lead meetings with both technical and non-technical stakeholders, delivering decision-ready work the first time with key findings, impact, risk, and data limits presented upfront.
  • Quantify, validate, and report realized savings, cost avoidance, working capital gains, and value creation through standard reporting and executive dashboards.
  • Deliver recurring KPI reporting and dashboards for Strategic Sourcing, Operations, and partner organizations supported by the team, ensuring accuracy and on-time delivery.
  • Develop financial models and business cases for major decisions, including total cost of ownership for new equipment and technology and sourcing event scenarios.
  • Drive strategic initiatives and special projects as assigned.

Own the GCP migration and trusted data platform

  • Lead Strategic Sourcing’s migration to Google Cloud Platform (GCP) end to end, from data inventory and mapping through testing and sign-off with IT and senior leadership.
  • Migrate and integrate data from multiple sources, including SAP, the purchasing platform, supplier and distributor feeds, and file-based reports, into a single trusted cloud foundation.
  • Design the GCP data architecture, data model, and pipelines connecting sourcing systems, and address data issues at the source.
  • Define technical requirements and test plans for new data and reporting work, and lead user acceptance testing with IT and partners through delivery.
  • Transform manual reporting into self-service Power BI dashboards, and apply automation and AI tools such as Microsoft Copilot to accelerate analysis.
  • Manage reporting standards and data governance practices to ensure consistent, trusted business intelligence.

Analytics governance, integration, and operational alignment

  • Lead technical engagement with purchasing platform partners, distributors, manufacturers, and labs by setting data requirements and holding partners accountable to delivery.
  • Establish data governance for sourcing data, including definitions, data owners, access rights, and quality rules so teams work from the same numbers.
  • Champion Strategic Sourcing data needs in changes to SAP, the purchasing platform, and other systems so requirements are included from the start.
  • Streamline recurring work by eliminating manual steps, and resolve data problems at their source with IT, Accounts Payable, and Operations.
  • Support adoption of new dashboards and tools by documenting data flows, definitions, and reports, plus training colleagues.
  • Own the team’s data and reporting roadmap and manage data projects end to end.

Required qualifications

  • 5+ years in a Data Analyst role or a hybrid Data Analyst/Engineer role, with a Bachelor’s degree in Data Science, Information Systems, Computer Science, Data Analytics, or related field.
  • Strong SQL skills and hands-on experience working with relational databases on Microsoft SQL Server Management Studio.
  • Demonstrated experience working within an ELT framework, comfortable handling raw ingested data and transforming it for reporting.
  • Experience with SAP Analytics (Hana) and BI tools such as Power BI, Tableau, or Looker.
  • Experience working within Google Cloud Platform environments.
  • Strong attention to detail, data quality, and documentation practices.
  • Ability to travel up to 1 time per month for 2–3 days.
  • Self-starter with strong analytical thinking and a collaborative approach.

Tools and technologies

  • Google Cloud Platform (GCP)
  • SQL
  • Microsoft SQL Server Management Studio
  • ELT
  • SAP Analytics (Hana)
  • Power BI, Tableau, Looker
  • Microsoft Copilot
  • Power Automate

Benefits

  • Generous benefits package

Location: Creve Coeur, MO (onsite). Compensation: USD 90,000 - 115,000 per year.

Similar Jobs