Job description

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,800 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 Senior Data Analyst to help transform lab and transactional data into structured, business-ready insights. You’ll work closely with our internal and external personnel 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. This role requires the ability to work independently while being able to communicate with various stakeholders. We prefer this role be based in St. Louis, Indianapolis or Effingham, IL, or within reasonable commuting distance to one of those offices. What You’ll Do • Collaborate with the internal Data Services team to enhance and optimize ELT processes (Extract, Load, Transform) for transactional and supplier data. • Perform data validation, cleaning, and transformation to ensure reporting accuracy • Define, document and help implement best practices for data governance and definitions • Support integration of new supplier or product datasets by structuring and transforming raw data into clean, analysis-ready format • 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 to support sourcing and procurement metrics. • Provide ad hoc reporting and analytics requests to support business and procurement decision making • Other projects as assigned Minimum Requirements • 5+ years in a Data Analyst or hybrid Data Analyst/Engineer role with a Bachelor’s in Data Science, Information Systems, Computer Science, Data Analytics, or a related field. • Strong SQL skills and hands-on experience working with relational databases on Microsoft SQL Server Mgt 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 at a time. • Self-starter with strong analytical thinking and a collaborative approach. Desirable Qualifications • 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 up to 3 days/week 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.

Requirements