Job Description

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.

Location: Melville, NY

Job Type: Full-Time

Salary: Up to $155,000

About Us

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.

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.

Key Responsibilities

• 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.

Qualifications & Skills

• 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.

Preferred Qualifications

• 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.

Benefits

• 401(k)

• Health Insurance

• Dental/Vision

• Aflac

• Paid time off

Always Compassionate Health provides equal opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, sex, gender identity, sexual orientation, pregnancy, status as a parent, national origin, age, disability (physical or mental), family medical history or genetic information, political affiliation, military service, or any other non-merit based factors protected federal, state, or local law. All employment-related decisions are based solely on relevant criteria including experience and suitability.

CORPWKD

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!