Senior Data Architect

ZealHire Inc.; Northern (KY); Hybrid; USD 150,000 - 210,000; Full time

Job summary

ZealHire Inc. seeks a Senior Data Architect for a contract engagement in the United States. The role demands hands-on expertise in ETL/ELT, Python, SQL, and enterprise data warehousing, with a focus on AI-enabled data platforms.

Candidates should bring real-time analytics, streaming pipelines, and experience with Treasure Data CDP, Kafka, Snowflake/Databricks, and cloud data services (AWS/Azure/GCP). Preference for those who have designed production-grade AI-ready data architectures and

Qualifications

• 10+ years of Data Engineering/Data Architecture experience.
• Hands-on ETL/ELT, Python, SQL, and Enterprise Data Warehouse/Lakehouse work.
• Experience with Treasure Data CDP in production environments.
• Real-time analytics, event-driven architectures, and streaming pipelines.
• Kafka experience, and Snowflake/Databricks proficiency.
• Cloud data architectures on AWS/Azure/GCP and AI-ready data pipelines.
• Experience with Generative AI data architectures and RAG/vector-search pipelines.
• Familiarity with LangChain/LangGraph/LlamaIndex and AI Agents is a plus.

Skills

ETL/ELT

Python

SQL

Real-time analytics

Streaming data pipelines

Apache Kafka

Treasure Data CDP

Snowflake/Databricks

Cloud data platforms (AWS/Azure/GCP)

CDC/ Debezium

AI-ready data pipelines / RAG

LangChain / LangGraph / AI Agents

Vector search

Tools

Treasure Data CDP

Apache Kafka

Snowflake

Databricks

Azure OpenAI / AWS Bedrock / GCP Vertex AI

Job description

Job Description

We are looking for a 10+ years experienced Senior Data Architect for a contract role.

• Must have strong hands-on ETL/ELT, Python, SQL, and Enterprise Data Warehousing experience.
• AI/Generative AI data engineering experience is strongly required - RAG, vector databases, LangChain/LangGraph, AI Agents, Azure OpenAI, AWS Bedrock, etc.
• We are specifically interested in candidates who understand how enterprise data platforms support modern AI/ML and Generative AI applications.
• Treasure Data / Treasure Data CDP experience is a key requirement - please prioritize candidates with real production experience.
• Strong experience with real-time analytics, event-driven architecture, and streaming data pipelines.
• Hands-on Apache Kafka experience is highly preferred.
• Experience with Snowflake, Databricks, or equivalent cloud data platforms.
• Strong experience with AWS, Azure, or GCP data engineering services.
• CDC or Debezium and incremental data processing experience is required.
• Candidate should have experience designing batch + real-time enterprise data architectures.
• Experience building AI-ready data pipelines / semantic search / RAG infrastructure will be a major plus.
• Please do not submit traditional ETL/BI only profiles.

Specific Ask: Please submit candidates who have Treasure Data + Real-Time Analytics + Enterprise ETL/Data Warehouse experience, ideally combined with Kafka and Generative AI.

Please provide Yes/No + years of experience for each:

• Does the candidate have 10+ years of Data Engineering / Data Architecture experience?
• Does the candidate have strong hands-on ETL/ELT, Python, and SQL experience?
• Does the candidate have enterprise Data Warehouse / Lakehouse experience?
• Does the candidate have hands-on Treasure Data / Treasure Data CDP experience?
• How many years of Treasure Data experience does the candidate have?
• Does the candidate have real-time analytics / streaming experience?
• Does the candidate have hands-on Apache Kafka experience?
• Does the candidate have CDC / Debezium experience?
• Does the candidate have strong Snowflake or Databricks experience?
• Does the candidate have experience designing cloud data architectures on AWS, Azure, or GCP?
• Does the candidate have Generative AI data engineering experience?
• Does the candidate have experience building RAG or vector-search pipelines?
• Does the candidate have experience with LangChain, LangGraph, LlamaIndex, or AI Agents?
• Does the candidate have experience integrating enterprise data with Azure OpenAI, AWS Bedrock, Vertex AI, Databricks Mosaic AI, or Snowflake Cortex?
• Has the candidate personally designed and implemented production-grade data architecture, rather than only maintaining existing ETL jobs?

Pre-Screening Questions

Q1: Does the candidate have 10+ years of Data Engineering/Data Architecture experience, with strong hands-on ETL/ELT, Python, SQL, and Enterprise Data Warehouse/Lakehouse architecture experience?

Q2: Does the candidate have hands-on production experience with Treasure Data / Treasure Data CDP, including designing, implementing, or supporting enterprise data pipelines/platforms?

Q3: Does the candidate have hands-on experience designing and implementing real-time analytics, event-driven architectures, and streaming data pipelines, including Apache Kafka?

Q4: Does the candidate have hands-on experience with CDC/incremental data processing (or Debezium) and designing enterprise cloud data architectures using AWS, Azure, GCP, Snowflake, or Databricks?

Q5: Does the candidate have hands-on experience building AI-ready data pipelines, RAG/vector-search infrastructure, or Generative AI data architectures, including technologies such as LangChain, LangGraph, LlamaIndex, AI Agents, Azure OpenAI, AWS Bedrock, Vertex AI, or similar platforms?

$000,000 - $000,000 Salary range is not shown on the candidate portal