Senior Engineer, Data Analytics Warehousing

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

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. Responsibilities:

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.