Senior Engineer, Data Analytics Warehousing

Visiting Nurse Service of New York d/b/a VNS Health•New York, NY

6h•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

AWS Certified Data Engineer preferred
Master's Degree preferred
Familiarity with data governance, role-based access controls (RBAC), and HIPAA compliance preferred
Significant experience working with healthcare data in industry standard formats (HL7, X12), and familiarity with healthcare data sources (e.g., EMR data, claims) preferred

Responsibilities

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.

Benefits

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume