Junior Data Architect/Engineer
1-year contract role in Plano, TX building a greenfield medallion-architecture data platform: ingesting from SQL Server/Oracle, dbt/Python Silver-Gold transformations, Iceberg lakehouse with Airflow orchestration, plus an MCP server letting AI agents query data marts. Pays $10,400/month DOE.
- Compensation
- $10.4K / mo
- Location
- Plano, TX, US
- Work setup
- Not specified
- Seniority
- Junior
- Employment
- Contract
- Experience
- 1+ years
- Category
- Architecture
- Posted
Skills
Must have
- 3+ years of hands-on data engineering experience in production environments
- Advanced SQL including window functions, CTEs, and query tuning
- Hands-on dbt experience: model design, incremental strategies, macros, tests
- Python proficiency for data processing and automation, including 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 (Microsoft SQL Server, Oracle) using CDC or batch processing
- Experience with Kubernetes
- Experience with MinIO (S3-compatible storage)
Nice to have
- 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 GenAI applications including LLM integration, RAG, and AI agent workflows
- Hands-on experience with LangChain and/or LangGraph for AI agents and multi-step workflows
- Understanding of retail and home appliance business domains, including PSI and sales analytics
Full description
Jr. Data Architect/Engineer
Location: Plano, TX, us
Company Description
Payrate: $10,400/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.
Job Description
- 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
Qualifications
- 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