Jr. Data Architect/Engineer

SBT Global, Inc.•Plano, TX
•Onsite

About The Position

The Jr. Data Architect/Engineer will build a greenfield data platform that integrates internal systems, including GSCM, SEASI, SMART, and BOSS, using a Medallion Architecture. The role owns the end-to-end data pipeline, from ingestion through Bronze, Silver, and Gold transformations, and migrates existing Alteryx workflows to code-based dbt and Python implementations. It will also develop an MCP server that enables AI agents to query business-specific data marts and supports the organization's AI-driven analytics initiatives. The goal is to deliver a scalable, governed data foundation that accelerates business insights and AI adoption. The position is based in Plano, Texas, at a stated pay rate of $10,371.64 per month (DOE), for a one-year contract period.

Requirements

  • At least 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.
  • 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, and MinIO (S3-compatible storage).

Nice To Haves

  • 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 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.
  • Preferred technical skills: Java or Python, Generative AI and LLM integration, LangChain, LangGraph, RAG and AI agent pipelines, MCP server development, Airbyte, Fivetran, Apache Polaris, OpenMetadata, DataHub, Cube.dev, Alteryx, and openpyxl.

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 that enables AI agents to query Gold-layer data marts, including catalog and metadata access, ontology integration, and query execution.
  • Manage metadata and data lineage using OpenMetadata.
  • Automate Excel reporting using Python and openpyxl.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service