> Markdown version of [/jobs/ext/1009486-data-architect-integrated-data-platform](https://www.wearedevelopers.com/jobs/ext/1009486-data-architect-integrated-data-platform). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Architect, Integrated Data Platform

- **Company:** Alcoa Inc.
- **Location:** San Francisco, CA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Query Performance, Application Programming Interfaces (APIs), Airflow, Algorithm Design, Amazon Web Services, Amazon S3, Apache HTTP Server, Computing Platforms, Audit Trail, Big Data, Clinical Data Repository, Data Architecture, Data Dictionary, Information Engineering, Data Governance, Data Infrastructure, Data Security, Relational Databases, Dicom, Document-Oriented Databases, Apache Hive, PostgreSQL, Meta-Data Management, Query Optimization, SQL Databases, Management of Software Versions, Enterprise Data Management, Data Lakes, Data Lineage, Data Management, Presto, Data Pipelines, GXP
- **Published:** June 2, 2026
- **Apply:** https://www.dice.com/job-detail/4c1353eb-c9ba-43a4-b01e-428106bbb882

## About the Role

10+ years of experience in data architecture, data engineering, or enterprise data platform design
Expert-level proficiency in relational data modeling (PostgreSQL or equivalent), including schema design, normalization, JSONB/semi-structured patterns, and query optimization
Hands-on experience designing and operating modern lakehouse architectures using Apache Iceberg or equivalent open table formats (Delta Lake, Apache Hudi)
Strong background in distributed query engines (Presto, Trino, Spark SQL, or equivalent) and large-scale data partitioning strategies
Experience with data versioning concepts including snapshot isolation, time travel, schema evolution, and catalog management
Demonstrated experience delivering data platforms in regulated environments with GxP, 21 CFR Part 11, or equivalent compliance requirements
Strong written and verbal communication skills, with the ability to document data models and architecture decisions for mixed technical and regulatory audiences, Hands-on experience with Project Nessie or equivalent transactional catalog tooling for Iceberg
Background in medical imaging data (DICOM) or multi-modal clinical data integration including omics or real-world data
Familiarity with FAIR data principles and their application to life sciences data platforms
Experience with workflow orchestration tools (Apache Airflow, Temporal, or equivalent) in the context of data pipeline design
Prior experience in a fixed-fee, milestone-based delivery engagement within a large regulated enterprise environment

## Description

Client is seeking a Senior Data Architect to lead the data modeling and platform design for a next-generation Integrated Data Platform (IDP) supporting a regulated medical imaging program at a global pharmaceutical and diagnostics company. This role is responsible for defining the data architecture across relational and lakehouse layers, governing the structure of versioned study-level data packages, and enabling cross-modal data access for imaging, omics, and real-world data. The architect will design for GxP compliance, FAIR data principles, and scalable query performance within a client-managed AWS environment, working in close partnership with the imaging platform, workbench, and clinical data workstreams., Data Modeling and Architecture
Lead the design of the Integrated Data Package (IDP) data model, covering multi-modal study assets including DICOM imaging, omics, and real-world data sources
Define the two-layer data architecture: operational relational layer for study metadata, cataloging, and access registry; lakehouse layer for versioned study assets at scale
Design schemas, partitioning strategies, and table formats across relational (PostgreSQL) and open table format (Apache Iceberg) layers to support both transactional and analytical access patterns
Establish cross-modal patient and study linkage standards, including integration with the Global Unique Patient Record Identifier (GUPRI) and related master data entities
Define data versioning and snapshot strategies for study-level packages, enabling reproducible dataset construction for algorithm development and regulatory submissions, Architect the Apache Iceberg-based lakehouse layer on S3, including table design, schema evolution governance, compaction policies, and metadata management
Design the version catalog architecture using Project Nessie or equivalent catalog tooling, covering namespace structure, branching strategy, and atomic snapshot tagging
Define query access patterns and optimization strategies across the lakehouse layer using distributed SQL query engines
Govern the data access API surface exposed to downstream consumers including the algorithm development workbench and reporting services

FAIRification and Data Governance
Design proactive FAIRification pipelines that enrich incoming study data with standardized metadata, controlled vocabularies, and linkage keys at ingestion time
Define data quality validation rules, error handling workflows, and observability hooks across the ingestion and enrichment pipeline
Establish data lineage and provenance tracking across the full data lifecycle from ingestion through version snapshot to analytical consumption
Ensure data architecture supports GxP audit trail requirements including ALCOA+ principles for traceability, integrity, and contemporaneity

Stakeholder Collaboration and Governance
Serve as the primary data architecture authority for the program, partnering with imaging platform, workbench, and regulatory workstreams on cross-cutting data decisions
Engage directly with client data, engineering, and architecture stakeholders to align on data models, access patterns, and governance standards
Produce and maintain architecture artifacts including data models, schema documentation, ADRs, and data dictionary
Contribute to milestone delivery planning, technical risk management, and program-level architecture reviews


## Related Videos

- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)
- [ZEISS & Microsoft - Building the Next Generation Medical Ecosystem in the Cloud](https://www.wearedevelopers.com/videos/424-zeiss-microsoft-building-the-next-generation-medical-ecosystem-in-the-cloud)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)
- [Why Event-Driven Architecture Isn’t About Speed (and When You Actually Need It)](https://www.wearedevelopers.com/magazine/745-why-event-driven-architecture-isn-t-about-speed-and-when-you-actually-need-it)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)