Senior Data Architect

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

#J-18808-Ljbffr