Data Analytics Engineer

Position: Data Analytics Engineer

Location: Remote, India

• 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