Apply on Employer Site

Heartland Dental · 16 hours ago

Data Analyst

Effingham, IL

Full-time

Hybrid

Mid, Senior Level

3+ years exp

Heartland Dental is the nation's largest dental support organization, providing non-clinical administrative support services to over 3,000 supported doctors. They are seeking a Data Analyst to transform supplier and transactional data into structured insights, support data pipelines, and lead reporting efforts for sourcing and procurement.

ConsultingDentalHealth CareHealth Diagnostics

No H1B

Responsibilities

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

Qualification

SQLData transformationBI toolsPythonCloud platformsELT frameworkAnalytical thinkingAttention to detailCollaboration

Required

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

Preferred

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

Benefits

Generous benefits package

Company

Heartland Dental

Glassdoor3.5

As a leading DSO, Heartland Dental provides supported dentists, hygienists, and non-clinical team members with world-class non-clinical administrative support to help them achieve sustainable professional and personal growth.

Founded in 1997

Effingham, Illinois, USA

10001+ employees