Data Architect

Daman; United States; Remote; USD 120,000 - 150,000; Full time

Job summary

An IT services and consulting company is seeking a Senior Data Architect to work remotely on the Data Accessibility Program. The candidate will design and operate AWS-based medallion architecture, build ETL/ELT pipelines, and implement data governance. This executive-level position requires experience with AWS, Apache Iceberg, and proficiency in creating data services. Competitive rates and a long-term contract are offered.

Qualifications

• Experience with AWS and Apache Iceberg.
• Familiarity with data governance and cataloging.
• Expertise in designing and building ETL/ELT pipelines.

Responsibilities

• Design and evolve medallion architecture for the enterprise data platform.
• Define and implement strategies for data integrity.
• Build curated Iceberg tables for standardizing data.

Skills

AWS Transfer Family

AWS Database Migration Service

AWS Glue

AWS Lambda

Apache Iceberg

HashiCorp Terraform

Python

Job description

Job Title: Senior Data Architect

Job Location: Remote

Job Type: Long-term Contract

Role Overview

Serve as a full-stack data engineer in the Data Accessibility Program, the foundation platform for the enterprise data portfolio. Design, build, and operate:

• AWS-based medallion architecture (Bronze / Silver / Gold)
• The data lake and data warehouse
• Enterprise ETL/ELT pipelines and data services / APIs
• Data governance, cataloging, and data-as-a-service capabilities

The Full-Stack Data Engineer works within the Data Accessibility Program, supporting the enterprise data platform built on AWS and Apache Iceberg. The engineer designs, builds, and operates the Bronze/Silver/Gold medallion architecture, ingestion frameworks, curated datasets, data services/APIs, and governance‑compliant pipelines.

Core Responsibilities

• Design and evolve medallion architecture for the enterprise data platform (Bronze, Silver, Gold).
• Define and implement SCD (Type 2) and CDC strategies with data integrity, referential integrity from source systems into S3 and Apache Iceberg.
• Perform data mapping from source systems into canonical and analytic models.
• Use AWS Transfer Family, AWS Database Migration Service (DMS), AWS Glue, AWS Lambda, EC2, Sonra Flexter, and Aurora PostgreSQL to ingest and land raw data into S3 (Parquet – data partitioning) and Apache Iceberg.

Silver (Curated on Apache Iceberg)

• Use Upsolver - Qlik Talend Cloud to build curated Iceberg tables that standardize and conform data across domains.
• Apache Iceberg table design and operations: partitioning, schema evolution, compaction, and performance tuning.

AWS & Lakehouse Platform Skills

• Amazon S3 for raw, curated, and derived datasets; including partitioning, lifecycle policies, and storage classes.
• AWS Glue for ETL jobs, crawlers, workflows, and use of Glue Catalog.
• AWS Lambda and EC2 for custom data processing jobs and API hosting.
• AWS Lake Formation and AWS Datazone for refined access management and governance.
• HashiCorp Terraform to provision and manage AWS resources used by the data platform.

Data Services & APIs

• Design and build data services / APIs that expose curated Silver data as reusable data products.
• Implement Python-based APIs and services on AWS compute (Lambda) using API Gateway.
• Ensure services implement observability (logs, metrics, traces) and align with operational SLAs.

Security, Governance & Operations

• Apply tokenization, encryption, masking, and redaction of sensitive data.
• Maintain accurate AWS Glue Catalog entries for all technical assets (S3, Iceberg, Aurora).
• Monitor and optimize performance and cost across S3, Glue, Aurora, Iceberg, and APIs.

Seniority level

• Executive

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting