Senior Engineer, Data Analytics Warehousing

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.

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