Heartland Dental is looking for a Data Analyst to transform supplier and transactional data into structured, business-ready insights to support the development of reliable data pipelines, contribute to ELT workflows, and lead reporting efforts for sourcing and procurement.
Requirements
- 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.
- Familiarity with dbt or similar transformation tools within modern data stacks.
- Exposure to procurement, sourcing, or finance data sets.
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
- 3+ years in a Data Analyst or hybrid Data Analyst/Engineer role
- 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.
- Ability to work from office 3 days/week
