Snowflake Engineer

Position Overview The Snowflake Data Engineer is responsible for designing, implementing, and optimizing modern cloud-based data platforms that support healthcare and academic medical center environments. This role focuses on the implementation of Snowflake and AWS, as well as the data modernization initiatives, enabling secure, scalable, and high-performance analytics across clinical, operational, and research data domains. The ideal candidate brings deep hands-on Snowflake engineering experience, strong AWS architecture and data engineering expertise, and a strong understanding of healthcare data, including clinical, claims, research, and real-world data in regulated environments. Key Responsibilities Snowflake Platform Engineering • Design, implement, and maintain Snowflake data architectures supporting healthcare and research analytics use cases • Develop and optimize Snowflake objects including databases, schemas, tables, views, streams, tasks, and secure data sharing • Implement performance tuning strategies, query optimization, clustering, and cost-optimization best practices • Manage role-based access control (RBAC), data security, and governance within Snowflake • Support multi-environment deployments (dev/test/prod) and enterprise-scale Snowflake implementations AWS Data Engineering & Modernization • Architect and implement AWS-based data ingestion and processing pipelines using services such as S3, Lambda, Glue, EC2, Step Functions, and SNS/SQS • Lead data modernization initiatives migrating legacy on-prem or EDW platforms (e.g., Oracle, SQL Server, Teradata) to Snowflake on AWS • Design scalable ELT/ETL workflows integrating AWS services with Snowflake • Implement CI/CD pipelines and infrastructure-as-code (e.g., Terraform, CloudFormation) to support Snowflake and AWS environments • Partner with cloud and security teams to ensure alignment with enterprise AWS standards Healthcare & Academic Medical Center Data • Engineer data pipelines supporting healthcare and research data sources, including EHR/EMR, clinical, and operational systems • Work with healthcare data models and standards such as HL7, FHIR, OMOP, i2b2, and other real-world data frameworks • Support academic medical center use cases including clinical research, population health, outcomes research, and regulatory reporting • Ensure data quality, lineage, and traceability to support research reproducibility and compliance • Collaborate with clinical, research, informatics, and analytics stakeholders to translate requirements into scalable data solutions Collaboration & Technical Leadership • Partner with data scientists, analysts, architects, and application teams to deliver end-to-end data solutions • Provide technical guidance and best practices for Snowflake and AWS data engineering • Participate in architecture reviews, design sessions, and modernization roadmaps • Contribute to documentation, data standards, and platform governance efforts Required Qualifications • Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent practical experience) • 5+ years of experience in data engineering, analytics engineering, or data platform development • 3+ years of hands-on Snowflake engineering experience in production environments • Strong experience architecting and building data platforms on AWS • Proven experience supporting healthcare, academic medical center, or life sciences data environments • Strong SQL skills and experience with ELT/ETL frameworks and data pipeline orchestration tools • Experience working in regulated environments requiring strong data security and governance practices Preferred Qualifications • Direct experience supporting academic medical centers, healthcare systems, or clinical research organizations through a Snowflake or cloud implementation • Experience with healthcare data standards (HL7, FHIR, OMOP, i2b2, CDISC, etc.) • Snowflake certifications (SnowPro Core, Advanced Architect, or Data Engineer) • Experience with dbt, Airflow, or similar orchestration and transformation tools • Familiarity with HIPAA, PHI handling, and healthcare compliance requirements • Experience with data sharing or cross-institutional research data collaboration in Snowflake Work Environment & Expectations • Hybrid or remote role with collaboration across technical and clinical stakeholders • Occasional on-site engagement with healthcare or academic partners as needed • Ability to manage multiple concurrent initiatives in a fast-paced, highly regulated environment