IT Talent Acquisition @ Tential Solutions
We are seeking a Data Architect to define the target architecture and lead the design of data models, pipelines, and governance for migrating cloud‑based healthcare management system data into AWS and Snowflake . The role combines architecture ownership with hands‑on prototyping to de‑risk patterns before engineering scales them.
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.#J-18808-Ljbffr