Search

Jr. Data Architect/Engineer

PublishedPublished: 6/14/2022
Technology
|

Job Description

Job DescriptionCompany Description\n
\n
\n

Payrate: $10,371.64/m DOE

\n

Work Location: Plano, TX

\n

Contract Period: 1 year

\n

\n

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.

\n

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.

\n

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.

\n

Success in this role will deliver a scalable, governed data foundation that accelerates business insights and AI adoption.

Job Description\n
\n
\n

    \n
  • \n

    Ingest data from sources such as Microsoft SQL Server (BOSS) and Oracle into the Bronze layer, implementing CDC-based incremental ingestion

  • \n

  • \n

    Develop dbt models for the Silver layer including cleansing, standardization, deduplication, and data quality testing

  • \n

  • \n

    Develop Gold layer business-specific data marts and migrate existing Alteryx transformation logic

  • \n

  • \n

    Configure Apache Iceberg tables and a REST Catalog, including schema evolution and time travel support

  • \n

  • \n

    Develop and operate Apache Airflow DAGs, managing dependencies, scheduling, and failure notifications

  • \n

  • \n

    Develop an MCP server enabling AI agents to query Gold-layer data marts, including catalog/metadata access, ontology integration, and query execution

  • \n

  • \n

    Manage metadata and data lineage using OpenMetadata

  • \n

  • \n

    Automate Excel reporting using Python and openpyxl

  • \n

Qualifications\n
\n
\n

    \n
  • \n

    3+ years of hands-on data engineering experience in production environments

  • \n

  • \n

    Advanced SQL skills, including window functions, CTEs, and query tuning

  • \n

  • \n

    Hands-on dbt experience, including model design, incremental strategies, macros, and tests

  • \n

  • \n

    Python proficiency for data processing and automation, including libraries such as pandas

  • \n

  • \n

    Experience developing Apache Airflow DAGs

  • \n

  • \n

    Experience with at least one analytical engine: Trino/Presto, Apache Spark, or DuckDB

  • \n

  • \n

    Experience with at least one lakehouse table format: Apache Iceberg, Delta Lake, or Apache Hudi

  • \n

  • \n

    Experience with Medallion Architecture and star schema/dimensional modeling

  • \n

  • \n

    Experience integrating relational database sources, such as Microsoft SQL Server and Oracle, using CDC or batch processing

  • \n

\n

\n

Required Technical Skills

\n

    \n
  • \n

    SQL

  • \n

  • \n

    dbt

  • \n

  • \n

    Python

  • \n

  • \n

    pandas

  • \n

  • \n

    Apache Airflow

  • \n

  • \n

    Trino/Presto or Apache Spark or DuckDB

  • \n

  • \n

    Apache Iceberg or Delta Lake or Apache Hudi

  • \n

  • \n

    Microsoft SQL Server

  • \n

  • \n

    Oracle

  • \n

  • \n

    Kubernetes

  • \n

  • \n

    MinIO (S3-compatible storage)

  • \n

\n

\n

Preferred Qualifications

\n

    \n
  • \n

    Experience with EL tools such as Airbyte or Fivetran, and Iceberg REST Catalog implementations such as Apache Polaris

  • \n

  • \n

    Experience with governance tools such as OpenMetadata or DataHub, and semantic layers such as Cube.dev

  • \n

  • \n

    Ability to interpret Alteryx workflows (.yxmd) and migrate their logic to SQL/dbt

  • \n

  • \n

    Experience developing MCP servers or building LLM, RAG, or AI agent pipelines

  • \n

  • \n

    Experience developing applications, APIs, or backend services using Java and/or Python

  • \n

  • \n

    Experience building Generative AI (GenAI) applications, including LLM integration, retrieval-augmented generation (RAG), and AI agent workflows

  • \n

  • \n

    Hands-on experience with LangChain and/or LangGraph for developing tool-enabled AI agents and orchestrating multi-step workflows

  • \n

  • \n

    Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics

  • \n

  • \n

    Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics

  • \n

\n

\n

Preferred Technical Skills

\n

    \n
  • \n

    Java or Python

  • \n

  • \n

    Generative AI (GenAI) and LLM integration

  • \n

  • \n

    LangChain

  • \n

  • \n

    LangGraph

  • \n

  • \n

    RAG and AI agent pipelines

  • \n

  • \n

    MCP server development

  • \n

  • \n

    Airbyte

  • \n

  • \n

    Fivetran

  • \n

  • \n

    Apache Polaris

  • \n

  • \n

    OpenMetadata

  • \n

  • \n

    DataHub

  • \n

  • \n

    Cube.dev

  • \n

  • \n

    Alteryx

  • \n

  • \n

    openpyxl

  • \n

\n
\n
\nAdditional Information\n
\n
\n

All your information will be kept confidential according to EEO guidelines.

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...