Loading, Please wait..!!
Jr. Data Architect/Engineer
-
Posted on: Nov 19, 2026
-
Plano, Texas
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Jr. Data Architect/Engineer roles in Texas.
View Salary Guide →Find your match !
Job Title :
Jr. Data Architect/Engineer
Job Type :
Full-Time
Job Location :
Plano Texas United States
Remote :
No
Job Description :
Job Description
\n
\n
Payrate: $10,371.64/m DOE
\nWork Location: Plano, TX
\nContract Period: 1 year
\n\n
We are seeking a mid-level Data Platform Engineer to build a new greenfield data platform integrating internal systems (GSCM, SEASI, SMART, and BOSS) using a Medallion Architecture.
\nThis role owns the end-to-end data pipeline—from ingestion through Bronze/Silver/Gold transformation—while migrating existing Alteryx workflows to code-based dbt and Python implementations.
\nThe engineer will also develop an MCP server enabling AI agents to query business-specific data marts, directly supporting the organization's AI-driven analytics initiatives.
\nSuccess in this role will deliver a scalable, governed data foundation that accelerates business insights and AI adoption.
Job Description\n\n
\n
- \n
- \n
Ingest data from sources such as Microsoft SQL Server (BOSS) and Oracle into the Bronze layer, implementing CDC-based incremental ingestion
\n - \n
Develop dbt models for the Silver layer including cleansing, standardization, deduplication, and data quality testing
\n - \n
Develop Gold layer business-specific data marts and migrate existing Alteryx transformation logic
\n - \n
Configure Apache Iceberg tables and a REST Catalog, including schema evolution and time travel support
\n - \n
Develop and operate Apache Airflow DAGs, managing dependencies, scheduling, and failure notifications
\n - \n
Develop an MCP server enabling AI agents to query Gold-layer data marts, including catalog/metadata access, ontology integration, and query execution
\n - \n
Manage metadata and data lineage using OpenMetadata
\n - \n
Automate Excel reporting using Python and openpyxl
\n
\n
\n
- \n
- \n
3+ years of hands-on data engineering experience in production environments
\n - \n
Advanced SQL skills, including window functions, CTEs, and query tuning
\n - \n
Hands-on dbt experience, including model design, incremental strategies, macros, and tests
\n - \n
Python proficiency for data processing and automation, including libraries such as pandas
\n - \n
Experience developing Apache Airflow DAGs
\n - \n
Experience with at least one analytical engine: Trino/Presto, Apache Spark, or DuckDB
\n - \n
Experience with at least one lakehouse table format: Apache Iceberg, Delta Lake, or Apache Hudi
\n - \n
Experience with Medallion Architecture and star schema/dimensional modeling
\n - \n
Experience integrating relational database sources, such as Microsoft SQL Server and Oracle, using CDC or batch processing
\n
\n
Required Technical Skills
\n- \n
- \n
SQL
\n - \n
dbt
\n - \n
Python
\n - \n
pandas
\n - \n
Apache Airflow
\n - \n
Trino/Presto or Apache Spark or DuckDB
\n - \n
Apache Iceberg or Delta Lake or Apache Hudi
\n - \n
Microsoft SQL Server
\n - \n
Oracle
\n - \n
Kubernetes
\n - \n
MinIO (S3-compatible storage)
\n
\n
Preferred Qualifications
\n- \n
- \n
Experience with EL tools such as Airbyte or Fivetran, and Iceberg REST Catalog implementations such as Apache Polaris
\n - \n
Experience with governance tools such as OpenMetadata or DataHub, and semantic layers such as Cube.dev
\n - \n
Ability to interpret Alteryx workflows (.yxmd) and migrate their logic to SQL/dbt
\n - \n
Experience developing MCP servers or building LLM, RAG, or AI agent pipelines
\n - \n
Experience developing applications, APIs, or backend services using Java and/or Python
\n - \n
Experience building Generative AI (GenAI) applications, including LLM integration, retrieval-augmented generation (RAG), and AI agent workflows
\n - \n
Hands-on experience with LangChain and/or LangGraph for developing tool-enabled AI agents and orchestrating multi-step workflows
\n - \n
Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics
\n - \n
Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics
\n
\n
Preferred Technical Skills
\n- \n
- \n
Java or Python
\n - \n
Generative AI (GenAI) and LLM integration
\n - \n
LangChain
\n - \n
LangGraph
\n - \n
RAG and AI agent pipelines
\n - \n
MCP server development
\n - \n
Airbyte
\n - \n
Fivetran
\n - \n
Apache Polaris
\n - \n
OpenMetadata
\n - \n
DataHub
\n - \n
Cube.dev
\n - \n
Alteryx
\n - \n
openpyxl
\n
\n
\nAdditional Information\n
\n
\n
All your information will be kept confidential according to EEO guidelines.
Similar Jobs You May Be Interested In
Position Details
Posted:
Nov 19, 2026
Reference Number:
1820f4d9
Employment:
Full-time
City:
Plano
Job Origin:
ziprecruiter
Share this job:
Please wait..!!

