Data Analyst - Infrastructure, Reporting, Strategic Sourcing
Job Details
- Req ID:
- 109122
- Supported Practice:
- Heartland Dental
- Category:
- Procurement
- Location:
- 1200 Network Centre Drive, Effingham, IL 62401
- Salary:
- $72,000.00 - $90,000.00 per year
Position Summary:
Data Analyst – Infrastructure, Reporting, Strategic Sourcing
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.
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.
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.
Below is an overview of the duties and responsibilities you would take on in this role:
- 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
Minimum Requirements
- 3+ 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.
- 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
- 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
Physical Requirements
- Ability to perform essential duties satisfactorily with or without reasonable accommodation. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties of the position.
- 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.
Featured Jobs
Dental Hygienist
- Supported Practice:
- Cincinnati Dental Services
- Job Location:
- 599 Freedom Park Dr., Crestview Hills, KY 41017
- Category:
- Dental Hygienist
Join Cincinnati Dental Services - Edgewood - Freedom Park where you can make a significant impact on the dental field and be part of a team that values your expertise! Learn more about our flexible schedule, continuing education, daily hygiene …
Dental Hygienist
- Supported Practice:
- New Mark Dental Care
- Job Location:
- 8603 North Oak Traffic Way, Kansas City, MO 64155
- Category:
- Dental Hygienist
Dental Hygienist Full-Time New Mark Dental Care 8603 North Oak Traffic Way Kansas City, MO 64155 As an elite clinical provider and patient advocate for New Mark Dental Care , you’ll receive best in class non-clinical support to provide exceptional …
General Dentist - Broomfield, CO
- Supported Practice:
- Heartland Dental - Broomfield, CO
- Job Location:
- Heartland Dental, Broomfield, CO 80021
- Category:
- General Dentist
General Dentist Opportunity Broomfield, CO $175,000 Total Compensation Package Work in an environment that encourages full clinical autonomy, balanced with the ability to tap into a robust mentor program and a network of more than 2,300 doctors. Experience a schedule …
Benefits
-
Paid Vacation & Holidays
-
Access to Daily Pay
-
Sponsored Continuing Education Opportunities
-
Bonus Program
-
Retirement and College Savings Plans
-
Referral Bonus
-
Health, Vision, Dental, & Life Benefits
-
Fitness and Mental Wellness Programs
Personal Stories
“I joined Heartland Dental in 2018 with 13 years of dental experience in search of career and leadership growth, and I’ve gotten that in abundance. The support is never-ending. If you have a vision or a dream, Heartland supports it wholeheartedly. I am blessed to be a part of such an amazing Supported Practice!”
- 2023 Joined the Communications Team
- 2021 Promoted to Regional Manager of Operations supporting Columbia and Aiken, SC and Evan, GA
- 2020 Expanded PMO role to support a second office
- 2018 Promoted to become the office’s Practice Manager of Operations (PMO)
- 2018 Joined Heartland Dental as a Business Assistant
“I joined Heartland Dental in search of a new opportunity and have found so much more than I could have ever imagined. Heartland has provided me invaluable education opportunities that have allowed me to achieve things I never thought possible and do things I never would have imagined.”
- 2023 Promoted to Regional Manager of Operations supporting Charlotte, North Carolina
- 2020 Transitioned to a PMO role supporting newly affiliated practices and new, or De Novo, offices in Charleston, SC
- 2017 Promoted to Practice Manager of Operations (PMO) supporting offices in Melbourne, FL
- 2015 Joined Heartland Dental as an Office Manager
“Beyond supporting me professionally, Heartland allows me to make a difference in my community. Being able to volunteer in Free Dentistry Days has been a huge motivator for me. I am proud to make a difference by helping empower providers to give back.”
- 2023 Founding member of Alliance, Heartland Dental’s gender and sexuality employee-led community
- 2022 Transitioned to Digital Marketing
- 2022 Promoted to Field Marketing Strategist
- 2018 Transitioned to the Regional Marketing Strategist
- 2017 Promoted to Practice Manager of Operations
- 2016 Promoted to Office Manager
- 2014 Joined Heartland Dental as a Business Assistant
“I joined Heartland Dental in search of a new career opportunity. Thanks to the great leaders and developmental courses Heartland offers, I have grown both personally and professionally. I never imagined I would become part of a new and growing department!”
- 2022 Promoted to Payor Relations Supervisor
- 2018 Joined a new, growing department as Payor Relations Lead
- 2016 Promoted to Fee Schedule Manager
- 2014 Promoted to Fee Schedule Supervisor
- 2011 Moved to Dental Insurance Administration department as a Fee Schedule Coordinator
- 2008 Transitioned to a role as a Dental Assistant
- 2007 Joined Heartland Dental as a Business Assistant
Heartland Dental
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.
Each Heartland Dental supported office is unique to the community and the patients they serve. Supported doctors are the leaders of their practice and set forth their own clinical care philosophies. But all our partners are united by a common goal: delivering the highest quality dental care and experience.
At Heartland Dental, we’re committed to living our core values which promote diversity and inclusion. We provide all employees and applicants for employment the protections of federal, state, and local laws affording equal opportunity in employment.