Heartland Dental is looking to transform lab and transactional data into structured, business-ready insights to support strategic reporting 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.
- Experience working within Google Cloud Platform environments
- Familiarity with dbt or similar transformation tools within modern data stacks.
Responsibilities
- 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
- 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
- Define, document and help implement best practices for data governance and definitions
- 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.
- Exposure to procurement, sourcing, or finance data sets.
