Data Analyst

Data Analyst – Infrastructure, Reporting, Strategic Sourcing

Heartland Dental is the nation's largest dental support organization, providing non-clinical administrative support services to more than 3,000 supported doctors across 39 states and the District of Columbia in over 1,900 dental offices. Each Heartland Dental supported office is unique to the community and the patients they serve. Supported doctors are the leaders of their practice and retain clinical autonomy. All Heartland Dental supported Doctors are united by a common goal: delivering the highest quality dental care and experiences to the communities they serve.

We’re looking for a Data Analyst to help transform supplier and transactional data into structured, business-ready insights. You’ll work closely with our Data Services team to support the development of reliable data pipelines, contribute to ELT workflows, and lead reporting efforts for sourcing and procurement.

This is a hybrid role that blends data transformation, modeling, and analytics enablement. The ideal candidate is technically strong, detail-oriented, and capable of supporting scalable data flows that power strategic reporting.

To give you an idea of the team structure, you will work on a team with a senior data analyst, reporting to the Senior Manager, Strategic Sourcing. We prefer this role be based in St. Louis, Indianapolis or Effingham, IL, or within reasonable commuting distance to one of those offices.

• Collaborate with the Data Services team to support and refine ELT processes (Extract, Load, Transform) for transactional and supplier data.
• Assist with integration of new supplier or product datasets; structure and transform raw data into clean, analysis-ready datasets.
• Build and maintain reporting layers and dashboards using BI tools (e.g., SAP Hana models, Power BI, Tableau, Looker).
• Contribute to the development and documentation of data models for sourcing and procurement metrics.
• Perform data validation, cleaning, and transformation to ensure reporting accuracy.
• Help define and implement best practices around data governance and definitions.
• Support ad hoc reporting and analytics requests across procurement and sourcing.
• Other projects as assigned.

• Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field.
• 3+ years in a Data Analyst or hybrid Data Analyst/Engineer role.
• Strong SQL skills and hands‑on experience working with relational databases.
• Experience with Python and familiarity with cloud platforms (GCP, Azure) and modern data stacks (Databricks, Snowflake).
• Demonstrated experience working within an ELT framework—comfortable handling raw ingested data and transforming it for reporting.
• Experience with BI tools such as Power BI, Tableau, or Looker.
• Strong attention to detail, data quality, and documentation practices.
• Ability to travel up to 1 time per month for 2–3 days at a time.
• Self‑starter with strong analytical thinking and a collaborative approach.
• Applicants must be legally authorized to work in the U.S. without current or future sponsorship.

• 5+ years in a data analytics or data engineering support role.
• Familiarity with dbt or similar transformation tools within modern data stacks.
• Exposure to procurement, sourcing, or finance data sets.
• Preference given to candidates that can work from St. Louis, Effingham, or Indianapolis offices.
• Ability to work from office 3 days/week.

• Ability to perform essential duties satisfactorily with or without reasonable accommodation.
• Prolonged periods sitting at a desk and working on a computer.
• Must be able to lift up to 15 pounds at times.

We put our people first at Heartland Dental, and that shows in our generous benefits package.

Company retains the sole discretion to change the duties of the position at any time.

We provide all employees and applicants for employment the protections of federal, state, and local laws affording equal opportunity in employment.