Back to Jobs

Data Architect

Not Disclosed

Job Description & Details

The contract Data Architect role is based in Alpharetta, GA and sits at the intersection of business analytics and cloud data engineering. You’ll own the end‑to‑end data blueprint, from high‑level models down to the ETL/ELT pipelines that feed the warehouse. It’s a hands‑on gig that matters because the company’s reporting and decision‑making depend on the architecture you design.

What You'll Actually Be Doing

You’ll start by translating business KPIs into a logical data model, then materialize that model into physical tables optimized for Snowflake, Redshift, or Synapse. Day‑to‑day you’ll be sketching schema diagrams, writing dbt models or Informatica mappings, and wiring Airflow DAGs that move data from on‑prem sources to the cloud. Expect to troubleshoot pipeline bottlenecks, enforce governance policies, and fine‑tune storage costs while keeping security controls tight.

The Core Tech Stack

The non‑negotiables are a solid grasp of cloud data warehouses—Snowflake, AWS Redshift, or Azure Synapse—and the ability to design scalable ETL/ELT flows with dbt, Informatica, or Airflow. You must also be fluent in relational modeling (conceptual, logical, physical) because the team relies on you to keep the schema performant and future‑proof. Data governance, access control, and security aren’t afterthoughts; they’re baked into every pipeline you ship.

Interview Expectations

  1. Design a Snowflake data model for a multi‑tenant SaaS product. The interviewer will look for how you partition data, handle semi‑structured JSON, and minimize cross‑cluster traffic while preserving tenant isolation. 2. Explain how you would orchestrate an incremental load from an on‑prem Oracle DB to Azure Synapse using Airflow. They want to see your approach to change‑data‑capture, idempotent DAG design, and error‑handling strategies.

Application Advice

Tailor your resume to shout out the exact tools the JD lists: “Data architecture”, “ETL/ELT pipelines”, “Snowflake”, “AWS Redshift”, “Azure Synapse”, “dbt”, “Informatica”, “Airflow”, “data governance”, and “data modeling”. Highlight any end‑to‑end projects where you built a cloud warehouse from scratch and enforced security policies. Quantify impact—e.g., reduced pipeline latency by 30% or cut storage costs by 20%—to make the ATS and hiring manager see you as the right fit.