Data & Application Architect

HMG AMERICA LLC; United States; On-site; USD 108,000 - 180,000; Full time

Job summary

HMG America LLC is seeking a Data & Application Architect to lead architecture for an Ad Tech platform modernization. You will drive design across operational databases, OLTP workloads, data modeling, and AWS data services to support analytics.

The role requires 15+ years in data or application architecture, deep experience with Oracle, Teradata and SQL Server, and concrete AWS expertise (Redshift, Kinesis, Glue, Lake Formation).

Qualifications

• 15+ years in Data Architecture, Application Architecture, or Database Architecture.
• Strong OLTP / application database architecture experience.
• Expertise with Oracle, Teradata, and/or SQL Server.
• Minimum 3+ years AWS experience.
• Strong experience with Aurora, DynamoDB, Kinesis, MSK/Kafka, Glue, EMR, Redshift, S3, Lake Formation, and Athena.
• Strong data modeling: 3NF, Star/Snowflake, SCD, Fact/Dimension.
• Experience with CDC, streaming, microservices, and event-driven architecture.
• Experience with Apache Iceberg / Lakehouse architecture.
• Strong architecture documentation and stakeholder communication skills.

Responsibilities

• Design and govern operational databases for microservices and high-throughput OLTP.
• Design transactional schemas, indexing, concurrency, and performance strategies.
• Architect CDC and event-driven data flows to analytics.
• Develop 3NF, Star/Snowflake, and SCD data models.
• Design modern warehouse/lakehouse architectures on AWS and Iceberg.
• Define batch and real-time data ingestion, transformation, and orchestration.
• Perform current-state assessments, profiling, and modernization planning.
• Establish data governance for lineage, cataloging, access, and PII.
• Design integration between legacy platforms and modern microservices.

Skills

Data Architecture

Application Architecture

Database Architecture

Tools

Oracle

Teradata

SQL Server

AWS

Aurora

DynamoDB

Kinesis

Kafka

Glue

EMR

Redshift

S3

Athena

Apache Iceberg

Lake Formation

CDC

OLTP

OLAP

Data Modeling

Job description

Full-Time and C2C

Up to $180K annually, $80/hr C2C

Role Overview

Role: Data & Application Architect

Employment Type: Full-Time and C2C

Compensation: Up to $180K annually, $80/hr C2C

Role Overview

We are seeking a Data & Application Architect to lead architecture for an Ad Tech platform modernization initiative. The role requires strong expertise across application databases, OLTP, data modeling, AWS data platforms, and analytical architecture.

Key Responsibilities

• Design and govern operational databases supporting microservices and high-throughput OLTP workloads.
• Design transactional schemas, normalization, indexing, concurrency, transaction isolation, and database performance strategies.
• Architect CDC and event-driven data flows from operational systems to downstream analytics.
• Develop 3NF, Star/Snowflake, Fact/Dimension, and SCD data models.
• Design modern warehouse/lakehouse architectures using AWS and Apache Iceberg.
• Define batch and real-time data ingestion, transformation, and orchestration patterns.
• Perform current-state assessment, data profiling, schema analysis, and modernization planning.
• Establish data governance standards for lineage, cataloging, access controls, PII, and retention.
• Design integration between legacy platforms and modern microservices architectures.

Required Skills

• 15+ years in Data Architecture, Application Architecture, or Database Architecture.
• Strong OLTP / application database architecture experience.
• Expertise with Oracle, Teradata, and/or SQL Server.
• Minimum 3+ years AWS experience.
• Strong experience with Aurora, DynamoDB, Kinesis, MSK/Kafka, Glue, EMR, Redshift, S3, Lake Formation, and Athena.
• Strong data modeling: 3NF, Star/Snowflake, SCD, Fact/Dimension.
• Experience with CDC, streaming, microservices, and event-driven architecture.
• Experience with Apache Iceberg / Lakehouse architecture.
• Strong architecture documentation and stakeholder communication skills.

Preferred

• Experience in Ad Tech, Media, Digital Advertising, or Marketing Technology.
• Experience with large-scale platform modernization and cloud migration.
• Experience with campaign reporting, pacing, frequency capping, or advertising analytics.

Core Stack

AWS | Oracle | Teradata | SQL Server | Aurora | DynamoDB | Kinesis | Kafka/MSK | Glue | EMR | Redshift | S3 | Lake Formation | Athena | Apache Iceberg | CDC | OLTP | OLAP | Data Modeling