For companies:
For professionals:
For everyone:
For developers:
Responsibilities
Responsibilities:
* Define end-to-end architecture for cloud-based healthcare management system ingestion into AWS and Snowflake, including landing, raw, staging, and curated layers.
* Establish canonical data models, dimensional schemas, and data contracts aligned to analytics, reporting, and downstream ML needs.
* Select and standardize ingestion patterns from the cloud-based healthcare management system (batch, CDC, file exports, APIs) with idempotent and auditable designs.
* Author reference implementations for S3 landing, Snowpipe, Streams & Tasks, and transformation workflows.
* Set enterprise standards for data quality, validation, reconciliation to the cloud-based healthcare management system, and SLAs for freshness and availability.
* Design security and compliance controls for PHI under HIPAA, including IAM, RBAC, encryption, masking, and audit trails.
* Define observability strategy across pipelines and models, including logging, metrics, lineage, and incident response.
* Partner with clinical, pharmacy, finance, and compliance SMEs to map cloud-based healthcare management system entities and business rules to curated models.
* Lead architecture reviews, pattern libraries, and documentation for data engineering teams to implement at scale.
* Optimize for performance and cost in Snowflake and AWS, including warehouse sizing, clustering, caching, and storage layout.
* Guide governance practices for metadata, cataloging, ownership, and change management.
* Mentor data engineers and analysts on modeling standards, ELT patterns, and secure data usage.
Required Qualifications:
* 8+ years in data architecture and data engineering delivering production data platforms.
* Proven experience designing architectures that extract from complex cloud-based healthcare management system (EMR/PM/pharmacy or similar).
* Expert SQL and strong Python for data design and prototyping.
* Deep Snowflake expertise on AWS: Snowpipe, Streams & Tasks, Time Travel, RBAC, resource monitors.
* Strong AWS background: S3, IAM, Glue or EMR, Lambda, Step Functions, CloudWatch.
* Data modeling mastery across 3NF and dimensional/star; semantic layers and data product design.
* Data quality and testing frameworks with reconciliation to source systems.
* Security-by-design mindset with HIPAA and PHI handling.
* Clear written and verbal communication with the ability to align technical and business stakeholders.
This job post is closed.