Data Architect

Corevia Staffing; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Corevia Staffing is seeking a Senior Data Architect for a 12-month contract-to-hire engagement, fully remote. The role demands 10+ years of Data Engineering/Architecture experience with hands-on ETL/ELT, Python, and SQL, plus enterprise data warehouse/lakehouse proficiency.

Expertise in Treasure Data CDP, real-time analytics, Kafka, and cloud platforms (AWS/Azure/GCP) is essential. The candidate should design scalable data architectures supporting AI/GenAI applications, including RAG and

Qualifications

• 10+ years of Data Engineering/Data Architecture experience with hands-on ETL/ELT, Python, and SQL.
• Experience with Enterprise Data Warehouses/Lakehouses and modern AI/GenAI data platforms.
• Production experience with Treasure Data/CDP, real-time analytics, and streaming pipelines.
• Strong background in Kafka, Snowflake, Databricks, and cloud data services (AWS/Azure/GCP).
• Experience designing cloud data architectures and RAG/vector-search pipelines.

Responsibilities

• Design and implement enterprise data architectures for batch and real-time workloads.
• Build and optimize AI-ready data pipelines including RAG infrastructure.
• Lead streaming data pipelines using Apache Kafka and related tech.
• Ensure integration of Treasure Data CDP with AI/ML platforms.
• Collaborate with teams to align data platforms with AI/GenAI needs.

Skills

ETL/ELT

Python

SQL

Real-time analytics

Event-driven architecture

Treasure Data CDP

Apache Kafka

Data warehousing

Snowflake

Databricks

Cloud platforms

CDC/ Debezium

AI-ready data pipelines

RAG / vector-search

LangChain / LangGraph

AI Agents

Azure OpenAI / AWS Bedrock

Terraform / Infrastructure as code

Tools

Treasure Data CDP

Apache Kafka

Snowflake

Databricks

AWS

Azure

GCP

Job description

Job title: Data Architect

Location: 100% Remote

Duration: 12 months | Contract to Hire

Interview Type: Virtual

Position Overview:

• 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.
• 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? 15. Has the candidate personally designed and implemented production-grade data architecture, rather than only maintaining existing ETL jobs

Pre-Screening Questions:

• 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?
• Does the candidate have hands-on production experience with Treasure Data / Treasure Data CDP, including designing, implementing, or supporting enterprise data pipelines/platforms?
• Does the candidate have hands-on experience designing and implementing real-time analytics, event-driven architectures, and streaming data pipelines, including Apache Kafka?
• 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?
• 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?