Jr. Data Architect/Engineer

Ledgent Technology; Plano (TX); On-site; USD 74,000 - 81,000; Full time

Job summary

Roth Staffing is seeking a mid-level Data Platform Engineer to design a greenfield data platform in Plano, TX. You will own end-to-end data pipelines—from ingestion to Bronze/Silver/Gold layers—using dbt, Python, and Apache Airflow.

The role includes building an MCP server and OpenMetadata data lineage integration to support AI-driven analytics initiatives. You will migrate Alteryx workflows to code-based dbt and Python implementations while ensuring scalable, governed data foundations for

Qualifications

• 3+ years of hands-on data engineering in production
• Advanced SQL with window functions, CTEs, and tuning
• Hands-on dbt experience including models, incremental strategies, macros, tests
• Python proficiency for data processing with pandas
• Experience developing Apache Airflow DAGs
• Experience with Trino/Presto, Apache Spark, or DuckDB
• Experience with lakehouse formats: Iceberg, Delta Lake, or Hudi
• Experience with Medallion Architecture and star schemas
• Experience integrating Microsoft SQL Server and Oracle using CDC or batch processing

Responsibilities

• Ingest data from SQL Server and Oracle into Bronze with CDC-based ingestion
• Develop dbt models for Silver with cleansing and quality tests
• Create Gold layer data marts and migrate Alteryx logic
• Configure Iceberg tables and REST Catalog with schema evolution and time travel
• Develop and operate Airflow DAGs for dependencies and scheduling
• Build MCP server for AI agents to query Gold-layer marts
• Manage metadata and data lineage using OpenMetadata
• Automate Excel reporting using Python and openpyxl

Skills

Advanced SQL

Python programming

dbt

Pandas

Airflow

Data modeling

Tools

Trino/Presto

Apache Spark

DuckDB

Apache Iceberg

Delta Lake

Apache Hudi

Kubernetes

MinIO

Microsoft SQL Server

Oracle

Job description

Salary: USD54 - USD58.66 per hour

Roth Staffing is seekingJr. Data Architect/Engineer contract opportunity with our client in Plano, TX.

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.

Responsibilities

• 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

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

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

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 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