​​​​​JOB SUMMARY The SciTech organization 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 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. JOB FUNCTIONS 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. Required for All Jobs • Participates in special projects and performs other duties as assigned. QUALIFICATIONS Education Education Level Education Details Required/Preferred Bachelor's Degree in Computer Science, Statistics, Informatics, Information Systems or a related field required Master's Degree — preferred Work Experience Experience Details Required/Preferred 3+ 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 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 Licenses and Certifications Licenses/Certifications Details Required/Preferred AWS Certified Data Engineer — preferred Job Family Group Description: Manages or performs work associated with the organization's overall IT infrastructure. Responsible for the analysis, design, implementation, operation, deployment, and support of the organization's technology resources, including computer hardware, operating systems, applications, data processing, network infrastructure, telecommunications systems, security, and software/database products. Trains and supports technology users. Performs IT audit and quality assurance activities. Plans, oversees, and implements telecommunication networks. Develops technology strategies, policies, and plans. Job Family Description: Designs, develops, and tests software products (end user applications, systems software, mobile/web applications, database products, etc.) for use by external customers. Conducts requirements analysis and high-level design/modeling to convert external customer needs into software solutions. Designs the overall software structure, core elements, and properties by analyzing the software requirements, constraints, interfaces, and dependencies using programming, scripting, and/or database languages to write the software code. Plans and conducts software testing to validate product designs. Ensures that products meet specifications and quality requirements.