Senior Data Analyst – Infrastructure, Reporting, Strategic Sourcing
Job Details
- Req ID:
- 108060
- Supported Practice:
- Heartland Dental
- Category:
- Procurement
- Location:
- Heartland Dental, St. Louis, MO
- Salary:
- $90,000.00 - $115,000.00 per year
Position Summary:
Senior 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,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.
Featured Jobs
Dental Assistant (or EFDA)
- Supported Practice:
- Pickerington Family Dental
- Job Location:
- 164 Clint Drive, Pickerington, OH 43147
- Category:
- Dental Assistant
Dental Assistant (Open to EFDA's!) Full Benefits Included! This is where patients come first, and continuous learning is encouraged! Hard-working and motivated, the successful candidate will bring a passion for providing the best patient care to the communities they serve. …
Dental Assistant
- Supported Practice:
- A Reason to Smile
- Job Location:
- 2803 N Bogus Basin Rd, Boise, ID 83702
- Category:
- Dental Assistant
Dental Assistant-Experience Required Full Benefits This is where patients come first, and continuous learning is encouraged! Hard-working and motivated, the successful candidate will bring a passion for providing the best patient care to the communities they serve. Benefits from Your …
Dental Front Office Assistant
- Supported Practice:
- Signature Smiles - Lathrup Village
- Job Location:
- 18181 W 12 Mile Rd, Lathrup Village, MI 48076
- Category:
- Business Assistant
Dental Front Office Assistant Full Benefits Included!
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.