Data Analyst

7 days ago

Effingham, IL, United States Heartland Dental Full time
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.

  • Financial Data Analyst

    4 days ago

    Effingham, IL, United States J & J Ventures Inc Full time

    Description Since 1929, J&J Gaming has been a leader in Gaming and Amusements and a trusted partner. Today, our focus remains steadfast: to provide world-class service to help businesses succeed. Our customers and our team members have been, and will always be, #1 priority. We are looking to expand our workforce with team-oriented individuals with a positive...

  • Financial Data Analyst

    6 days ago

    Effingham, IL, United States J & J Ventures Inc Full time

    Description Since 1929, J&J Gaming has been a leader in Gaming and Amusements and a trusted partner. Today, our focus remains steadfast: to provide world-class service to help businesses succeed. Our customers and our team members have been, and will always be, #1 priority. We are looking to expand our workforce with team-oriented individuals with a positive...

  • Financial Data Analyst

    18 hours ago

    Effingham, IL, United States J & J Ventures Inc Full time

    Description Since 1929, J&J Gaming has been a leader in Gaming and Amusements and a trusted partner. Today, our focus remains steadfast: to provide world-class service to help businesses succeed. Our customers and our team members have been, and will always be, #1 priority. We are looking to expand our workforce with team-oriented individuals with a positive...

  • Financial Data Analyst

    10 hours ago

    Effingham, IL, United States J & J Ventures Inc Full time

    Description Since 1929, J&J Gaming has been a leader in Gaming and Amusements and a trusted partner. Today, our focus remains steadfast: to provide world-class service to help businesses succeed. Our customers and our team members have been, and will always be, #1 priority. We are looking to expand our workforce with team-oriented individuals with a positive...

  • Business Systems Analyst

    1 week ago

    Effingham, IL, United States Dieterich Bank Full time

    Dieterich Bank is seeking a Business Systems Analyst to join our team in Effingham, IL. This is an in-person role based at our Corporate Center in Effingham, IL, requiring daily on-site attendance. The Business Systems Analyst is responsible for end user support, ongoing system maintenance, solution implementation, and training for business units. The...

  • Business Systems Analyst

    2 weeks ago

    Effingham, IL, United States Dieterich Bank Full time

    Dieterich Bank is seeking a Business Systems Analyst to join our team in Effingham, IL. This is an in-person role based at our Corporate Center in Effingham, IL, requiring daily on-site attendance. The Business Systems Analyst is responsible for end user support, ongoing system maintenance, solution implementation, and training for business units. The...

  • Business Systems Analyst

    2 days ago

    Effingham, IL, United States Dieterich Bank Full time

    Dieterich Bank is seeking a Business Systems Analyst to join our team in Effingham, IL. This is an in-person role based at our Corporate Center in Effingham, IL, requiring daily on-site attendance. The Business Systems Analyst is responsible for end user support, ongoing system maintenance, solution implementation, and training for business units. The...

  • Credit Analyst-Ag Lending Focus

    1 week ago

    Effingham, IL, United States gpac Full time

    Job Description Credit Analyst - Ag Lending Focus Southern Illinois Full-Time | Competitive Compensation | On-Site or Hybrid A relationship-centered financial institution in Southern Illinois is looking to add an experienced Credit Analyst to its growing credit team. This role is ideal for a motivated analyst with commercial and ag credit experience who...

  • Credit Analyst

    6 days ago

    Effingham, United States Gpac Full time

    Credit Analyst – Commercial & Agricultural LendingHybrid / Remote Option | Compensation up to $90,000Are you a detail-driven Credit Analyst who enjoys deep financial analysis, diverse credit exposure, and partnering directly with lenders—without being stuck in a rigid underwriting box?A well-established, relationship-focused community bank in rural...

  • Business Systems Analyst

    7 days ago

    Effingham, United States Dieterich Bank Full time

    Dieterich Bank is seeking a Business Systems Analyst to join our team in Effingham, IL. This is an in-person role based at our Corporate Center in Effingham, IL, requiring daily on-site attendance.The Business Systems Analyst is responsible for end user support, ongoing system maintenance, solution implementation, and training for business units. The...

  • Credit Analyst

    3 weeks ago

    Effingham, United States GPAC Full time

    Credit Analyst Commercial & Agricultural LendingHybrid / Remote Option | Compensation up to $90,000Are you a detail-driven Credit Analyst who enjoys deep financial analysis, diverse credit exposure, and partnering directly with lenderswithout being stuck in a rigid underwriting box?A well-established, relationship-focused community bank in rural downstate...

  • Financial Analyst I

    2 weeks ago

    Effingham, United States Midland States Bank Full time

    Position Title: Financial Analyst I Locations: Effingham_IL Time Type: Full time Req ID: JR1195-Effingham_IL At Midland, we’re proud to be a little different. You can see it in our bright orange signs-but there’s more to it than that. With our heartfelt and personalized approach, we’re focused on meeting every customer’s needs with the brightest...

  • Finance Manager

    7 days ago

    Effingham, United States Johnson & Johnson Innovative Medicine Full time $102,000 - $177,100

    At Johnson & Johnson, we believe health is everything. Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments are smarter and less invasive, and solutions are personal. Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to...