Data Analytics Engineer

Build and enhance the Gold layer within the Snowflake Medallion Architecture. Develop and maintain data pipelines using Snowpark and APIs. Create and manage data models that support business reporting and analytics. Build and refine Sigma dashboards and reporting solutions. Work with healthcare operational data, including offices, patients, and appointment-related information. Consume API data sources and build ingestion pipelines within Snowflake. Potentially perform API post calls directly from Snowflake as part of pipeline development. Translate existing data structures into business-ready reporting tables. Compare legacy and modernized datasets during migration efforts and identify discrepancies. Validate KPI calculations and ensure business definitions are applied consistently. Flag data inconsistencies and proactively identify issues that “don’t look right.” Support governance and security initiatives within Snowflake. Present technical findings and recommendations through an established request process managed by Paul. Collaborate with existing Snowflake resources while independently owning assigned deliverables.

Current Environment & Challenges: Client is building out its Snowflake analytics environment and implementing Sigma as its reporting platform. The majority of the initial work will focus on the Gold layer. Core data and foundational architecture are already in place; the challenge is producing business-ready tables and reporting assets. The organization is migrating away from a legacy system (Jarvis, a Henry Schein product). Data inconsistencies exist between legacy and new environments and need to be identified and reconciled. KPI definitions are not always standardized. For example, “new patient” may be defined in several different ways: Appointment scheduled Visit completed Revenue earned Success in this role requires someone who can identify and challenge inconsistent business logic rather than simply building to specification. Previous offshore resources required significant oversight or were not delivering at the desired pace, increasing the need for a more independent contributor.

1 Snowflake 2 Snowpark 3 SQL 4 DBT 5 API Integration 6 Data Modeling 7 Sigma Analytics 8 Medallion Architecture 9 Gold Layer and KPI Validation