Data & Application Architect

Employment Type: Full-Time and 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.

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.

Requirements

• 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

• Ad Tech, Media, Digital Advertising, or Marketing Technology.
• Large-scale platform modernization and cloud migration.
• Campaign reporting, pacing, frequency capping, or advertising analytics.

Pay

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

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