Senior Analytics Data Engineer – Warehousing

VNS Health; New York (NY); Hybrid; USD 98,200 - 130,800; Full time

Benefits offered by this job

Referral bonus opportunities

PTO 30 days + 9 holidays

Health insurance for you and family

Employer‑matched retirement funds

Wellness programs

Pre‑tax FSAs

Tuition reimbursement

Professional growth opportunities

Internal mobility & CEU credits

Job summary

VNS Health’s SciTech organization seeks an experienced Analytics Data Engineer to join our hybrid team. You will own ingestion, transformation, and modeling pipelines powering advanced analytics and ML products, beginning with the Care Transitions Platform.

You will work end-to-end on data interfaces (claims, membership) and contribute to scalable ETL/ELT workflows, data quality, and governance while collaborating with data scientists and analysts in a fast-paced agile environment.

Qualifications

• Three+ years in data/analytics engineering or equivalent.
• Experience building robust ETL/ELT pipelines conforming to healthcare data standards (HL7, X12).
• Advanced SQL and data modeling experience; Python proficiency.
• Experience with cloud data engineering (AWS preferred).
• Familiarity with CI/CD and Git-based collaboration.
• Healthcare data experience and HIPAA knowledge are a plus.

Responsibilities

• Develop and orchestrate scalable ETL/ELT processes using AWS services and Redshift.
• Apply healthcare data standards (EDI 834/835/837, FHIR) to build compliant data interfaces.
• Implement automated data quality checks for raw and transformed data.
• Collaborate with data scientists to design clean data marts supporting ML pipelines, including Generative AI/LLMs.
• Deploy data marts to Redshift and Snowflake using dbt.
• Manage source control and deployment using GitLab CI/CD.
• Apply IaC and DevOps practices to automate deployment across environments.
• Support data pipelines powering analytics products and maintain service levels.
• Participate in agile sprints and cross-functional reviews.
• Ensure PHI/HIPAA compliance in data handling.

Skills

Python

Advanced SQL

Data modeling

ETL/ELT pipelines

Agile environment

Education

Bachelor's degree in Computer Science/Statistics/Informatics/Information Systems or related field

Master's degree preferred

Tools

AWS

Glue

Redshift

dbt

GitLab CI/CD

S3

Snowflake

Job description

Overview

The SciTech organization at VNS Health is seeking an experienced Analytics Data Engineer to join our team. This hybrid role combines data engineering and analytics engineering - with the ideal candidate working end to end on ingestion, transformation, and data modeling workflows to power VNS's advanced analytics and machine learning products. The Data Analytics Engineer will initially focus on developing the Care Transitions Platform, ensuring reliable ingestion and transformation of claims and membership data for downstream analytics and ML scoring.

What We Provide

• Referral bonus opportunities
• Generous paid time off (PTO), starting at 30 days of paid time off and 9 company holidays
• Health insurance plan for you and your loved ones, Medical, Dental, Vision, Life and Disability
• Employer-matched retirement saving funds
• Personal and financial wellness programs
• Pre-tax flexible spending accounts (FSAs) for healthcare and dependent care
• Generous tuition reimbursement for qualifying degrees
• Opportunities for professional growth and career advancement
• Internal mobility, generous tuition reimbursement, CEU credits, and advancement opportunities

What You Will Do

• Develop and orchestrate scalable ETL/ELT processes using AWS B2B Data Interchange, Glue, Step Functions, and Redshift, ensuring data integrity, reliability, and performance.
• Apply advanced knowledge of healthcare data standards (e.g. EDI 834/835/837, FHIR) to build compliant data interfaces.
• Implement automated data quality checks and validation processes to ensure completeness and accuracy of raw and transformed healthcare data.
• Collaborate with data scientists and analysts to design clean, reusable, and well-documented data marts that support ML pipelines and other advanced analytics, including Generative AI and large language model applications.
• Implement, document, and deploy data marts to Redshift and Snowflake using dbt.
• Manage source control, testing, and deployment using GitLab CI/CD, supporting collaborative, version-controlled data development.
• Apply Infrastructure as Code (IaC) and DevOps principles to automate and scale data pipeline deployment across environments.
• Support and enhance the data pipelines powering VNS Commercial Analytics products, ensuring consistent service levels.
• Work collaboratively within an agile development environment, participating in sprint planning, code reviews, and backlog grooming.
• Ensure compliance with data security, privacy, and governance standards, particularly those applicable to PHI and HIPAA.
• Participates in special projects and performs other duties as assigned.

Qualifications

Licenses and Certifications:
AWS Certified Data Engineer preferred

Education:
Bachelor's Degree in Computer Science, Statistics, Informatics, Information Systems or a related field required Master's Degree preferred

Work Experience:

• Three plus years in data engineering, analytics engineering, or equivalent experience required Experience building robust ETL/ELT pipelines that conform to industry data standards (e.g., HL7, X12), for healthcare or a related sector (e.g., finance, insurance) required
• Advanced SQL skills and experience with data modeling concepts (SCDs, normalization, dimensional modeling) required
• Proficiency in Python (for data manipulation, automation, or orchestration) required
• Experience with Git-based collaboration and CI/CD automation (preferably GitLab CI) required
• Experience with cloud data engineering (AWS, GCP, or Azure), with a preference for prior AWS Data Engineering experience (e.g., using S3, Glue, Lambda, Step Functions, Redshift) required
• Experience working in agile environments with cross-functional data teams required
• Familiarity with data governance, role-based access controls (RBAC), and HIPAA compliance preferred Significant experience working with healthcare data in industry preferred
• Standard formats (HL7, X12), and familiarity with healthcare data sources (e.g., EMR data, claims) preferred

Pay Range

USD $98,200.00 - USD $130,800.00 /Yr.
About Us

VNS Health has been committed to meeting the needs of New Yorkers for over 130 years. We're one of the largest nonprofit home- and community-based health care organizations in the country, and today, more than 11,500 team members work together to make a difference in the lives of more than 99,000 patients and members on any given day.