Nuvia Dental Implant Center is seeking an Analytics Engineer to transform raw data into clean, reliable datasets for business intelligence and AI initiatives. The role involves designing and maintaining data pipelines, ensuring data quality, and collaborating with internal stakeholders to meet data needs.
Responsibilities:
- Build and maintain ETL pipelines moving data from silver to gold layers using Python, SQL, and Windmill
- Design and implement data models that serve reporting, dashboard, and AI enablement use cases
- Own and improve gold-layer data quality — including testing, validation, and documentation
- Translate business reporting requirements into reliable, performant data models
- Support internal AI initiatives by ensuring data is structured, consistent, and accessible for downstream AI consumption
- Collaborate with internal stakeholders to understand data needs and deliver accurate, timely datasets
- Support and contribute to our visualization layer (currently Zoho Analytics; additional tools possible)
- Participate in code reviews and contribute to team data standards and best practices
- Monitor pipeline health and proactively address data issues before they impact downstream consumers
Requirements:
- 2–4 years of experience in an Analytics Engineer, Data Engineer, or Senior Data Analyst role
- Strong SQL skills — writes clean, optimized queries with a solid understanding of how data warehouses execute them
- Python proficiency for data transformation and pipeline work
- Experience working within a layered data architecture (bronze/silver/gold or equivalent)
- Familiarity with workflow orchestration tools (Windmill, Airflow, Prefect, or similar)
- AWS experience (S3, Glue, Lambda, or similar services)
- Solid understanding of data modeling concepts — dimensional modeling, grain, and slowly changing dimensions
- Strong documentation habits — writes for the next person, not just themselves
- Effective communication skills with the ability to translate technical concepts for non-technical stakeholders
- Experience with dbt or similar transformation frameworks
- Exposure to Zoho Analytics or other BI/visualization platforms
- Familiarity with AI/ML workflows — understanding how clean, structured data feeds LLMs, RAG pipelines, or ML models
- Experience building data products with AI enablement in mind (feature stores, semantic layers, structured outputs for LLM consumption)
- Experience in healthcare, dental, or services industries