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

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 standard formats (HL7, X12), and familiarity with healthcare data sources (e.g., EMR data, claims) preferred