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
