Senior Data Platform Engineer, Enterprise Data & Analytics

Always Compassionate Home Care Inc
Melville, United States of America
10 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 155K

Job location

Melville, United States of America

Tech stack

Artificial Intelligence
Airflow
Amazon Web Services (AWS)
Data analysis
Information Systems
Data Architecture
Information Engineering
Data Governance
Data Infrastructure
Data Integration
ETL
Data Structures
Data Warehousing
Dimensional Modeling
Python
Performance Tuning
Query Optimization
SQL Databases
Data Streaming
Enterprise Data Management
Scripting (Bash/Python/Go/Ruby)
Cloud Platform System
EHR Systems
Sql Optimization
System Availability
Snowflake
Electronic Medical Records
Core Data
Infrastructure Automation Frameworks
Information Technology
Data Pipelines

Job description

ACH is seeking a Senior Data Platform Engineer to own and evolve the core data model within our Snowflake cloud data platform. This role is the backbone of our data infrastructure-responsible for maintaining a well-organized ETL system across existing integrations, troubleshooting pipeline issues, enforcing order in the consumption layer, and leading the integration of new data pipelines as the business expands into new Electronic Health Record (EHR) systems and care verticals.

You will serve as the primary technical steward of our data platform, ensuring that data flows reliably from source systems through transformation layers and into analytics-ready structures. This is a hands-on role that blends architecture thinking with day-to-day engineering execution., * Own and maintain the enterprise data model in Snowflake, including staging, transformation, and consumption layers.

  • Troubleshoot and resolve data pipeline issues across ingestion, transformation, and delivery stages.
  • Maintain an organized, well-documented ETL/ELT system across all existing integrations and source systems.
  • Enforce consistency and governance in the consumption layer to ensure downstream reporting and analytics are built on trusted data.
  • Lead the technical integration of new data pipelines as ACH expands into additional EHR platforms and business verticals.
  • Optimize SQL queries, warehouse configurations, and storage structures for performance and cost efficiency.
  • Manage Snowflake platform operations including warehouse sizing, access control, object management, and resource monitoring.
  • Collaborate with analytics and business stakeholders to ensure data structures support reporting, dashboarding, and AI-driven use cases.
  • Create and maintain documentation of data flows, pipeline configurations, data models, and platform standards.

Requirements

Do you have experience in Technical architecture?, * Bachelor's degree in computer science, engineering, information systems, or a related technical field.

  • 3-7 years of experience in data engineering, data architecture, platform engineering, or similar roles.
  • Advanced SQL proficiency including complex joins, CTEs, window functions, and performance tuning.
  • Hands-on experience with Snowflake, including data modeling, warehouse management, and query optimization.
  • Strong understanding of data warehousing concepts, ELT/ETL patterns, and dimensional modeling (star/snowflake schemas).
  • Proficiency in Python or another scripting language for pipeline development and automation.
  • Experience integrating data from healthcare systems (EHRs, claims, billing) is strongly preferred.
  • Ability to work independently and take ownership of platform reliability and data quality., * Experience with cloud ecosystems (AWS preferred) and infrastructure-as-code practices.
  • Familiarity with data orchestration tools (e.g., Airflow, dbt, Fivetran).
  • Exposure to data governance, security, and compliance requirements in regulated industries.
  • Experience in healthcare, home care, or other operationally complex environments., If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Benefits & conditions

Pulled from the full job description

  • 401(k)
  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance, * 401(k)
  • Health Insurance
  • Dental/Vision
  • Aflac
  • Paid time off

About the company

Always Compassionate Health (ACH) is a leading integrated home and community-based healthcare provider committed to exceptional, patient-centered care. We are building a modern, data-driven organization to support growth across home care, pharmacy, mental health, and emerging care models. Our Enterprise Data & Analytics function plays a critical role in enabling operational efficiency, regulatory compliance, and strategic decision-making through scalable, cloud-based data platforms.

Apply for this position