Quick overview
Job description
Payrate: $10,371.64/m DOE
Work Location: Plano, TX
Contract Period: 1 year
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.
This 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.
The 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.
Success in this role will deliver a scalable, governed data foundation that accelerates business insights and AI adoption.
Ingest data from sources such as Microsoft SQL Server (BOSS) and Oracle into the Bronze layer, implementing CDC-based incremental ingestion
Develop dbt models for the Silver layer including cleansing, standardization, deduplication, and data quality testing
Develop Gold layer business-specific data marts and migrate existing Alteryx transformation logic
Configure Apache Iceberg tables and a REST Catalog, including schema evolution and time travel support
Develop and operate Apache Airflow DAGs, managing dependencies, scheduling, and failure notifications
Develop an MCP server enabling AI agents to query Gold-layer data marts, including catalog/metadata access, ontology integration, and query execution
Manage metadata and data lineage using OpenMetadata
Automate Excel reporting using Python and openpyxl
3+ years of hands-on data engineering experience in production environments
Advanced SQL skills, including window functions, CTEs, and query tuning
Hands-on dbt experience, including model design, incremental strategies, macros, and tests
Python proficiency for data processing and automation, including libraries such as pandas
Experience developing Apache Airflow DAGs
Experience with at least one analytical engine: Trino/Presto, Apache Spark, or DuckDB
Experience with at least one lakehouse table format: Apache Iceberg, Delta Lake, or Apache Hudi
Experience with Medallion Architecture and star schema/dimensional modeling
Experience integrating relational database sources, such as Microsoft SQL Server and Oracle, using CDC or batch processing
Required Technical Skills
SQL
dbt
Python
pandas
Apache Airflow
Trino/Presto or Apache Spark or DuckDB
Apache Iceberg or Delta Lake or Apache Hudi
Microsoft SQL Server
Oracle
Kubernetes
MinIO (S3-compatible storage)
Preferred Qualifications
Experience with EL tools such as Airbyte or Fivetran, and Iceberg REST Catalog implementations such as Apache Polaris
Experience with governance tools such as OpenMetadata or DataHub, and semantic layers such as Cube.dev
Ability to interpret Alteryx workflows (.yxmd) and migrate their logic to SQL/dbt
Experience developing MCP servers or building LLM, RAG, or AI agent pipelines
Experience developing applications, APIs, or backend services using Java and/or Python
Experience building Generative AI (GenAI) applications, including LLM integration, retrieval-augmented generation (RAG), and AI agent workflows
Hands-on experience with LangChain and/or LangGraph for developing tool-enabled AI agents and orchestrating multi-step workflows
Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics
Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics
Preferred Technical Skills
Java or Python
Generative AI (GenAI) and LLM integration
LangChain
LangGraph
RAG and AI agent pipelines
MCP server development
Airbyte
Fivetran
Apache Polaris
OpenMetadata
DataHub
Cube.dev
Alteryx
openpyxl
All your information will be kept confidential according to EEO guidelines.
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- UP

Senior Backend Software Engineer, Personal LoansRecently posted Auto Apply
Upstart · United States · Remote · Posted 21 Nov 2026 🇺🇸
RubyCADJava+9Technology$166.9k - $230.9k/yr - TW

Principal Engineer, Cloud SecurityRecently posted Auto Apply
Twilio · United States · Remote · Posted 20 Nov 2026 🇺🇸
DockerGCPAWS+8Technology$192.6k - $283.2k/yr - TA

Manager, Solutions ArchitectRecently posted Auto Apply
Together AI · San Francisco · Hybrid · Posted 21 Nov 2026 🇺🇸
Customer SuccessForecastingLLM+2Technology$300k - $325k/yr - TA

Solutions ArchitectRecently posted Auto Apply
Together AI · New York · Hybrid · Posted 21 Nov 2026 🇺🇸
DockerAnsibleCustomer Success+6Technology$250k - $300k/yr - SP

Electrical Design Engineer (Starfall Avionics)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 21 Nov 2026 🇺🇸
AssemblyAltiumElectrical Design+1Technology$105k - $140k/yr - SP

Sr. Electrical Systems Engineer (Falcon & Dragon)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 21 Nov 2026 🇺🇸
MATLABCADC+++1Technology$140k - $230k/yr - SP

Sr. Avionics Systems Engineer (Falcon & Dragon)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 21 Nov 2026 🇺🇸
MATLABCADC+++1Technology$140k - $230k/yr - SP

Electrical Systems Engineer (Special Programs)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 21 Nov 2026 🇺🇸
MATLABC++PythonTechnology$105k - $140k/yr - SP

Electrical Systems Engineer (Falcon & Dragon)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 21 Nov 2026 🇺🇸
MATLABCADC+++1Technology$105k - $122.5k/yr - SP

Sr. Design Reliability Engineer (Falcon & Dragon)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 21 Nov 2026 🇺🇸
MATLABMicrosoft ExcelANSYS+6Technology$135k - $215k/yr - CE

Staff Data EngineerRecently posted Auto Apply
Consumer Edge · United States · Hybrid · Posted 21 Nov 2026 🇺🇸
SQLSnowflakeAirflow+6Technology$175k - $210k/yr - HA

Creative AI EngineerRecently posted Auto Apply
Harvey · San Francisco · Hybrid · Posted 21 Nov 2026 🇺🇸
FigmaLLMTechnology$168.4k - $252.6k/yr