Jr. Data Architect-Must be local to TX

Job Title: Jr. Data Architect/Engineer

Contract Period: 1 year

Work location: Plano, Texas (Onsite)

Position Summary

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.

Required 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

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