SBT Global, Inc.

Jr. Data Architect/Engineer

SBT Global, Inc.
Apply
1 day ago
Plano, TX, USAEntry Level

Responsibilities

  • Ingest data from Microsoft SQL Server and Oracle into Bronze-layer storage using CDC-based incremental ingestion or batch processing.
  • Develop dbt Silver-layer models for cleansing, standardization, deduplication, incremental processing, macros, and data quality testing.
  • Build Gold-layer business-specific data marts using star schema and dimensional modeling practices.
  • Configure Apache Iceberg tables and a REST Catalog with schema evolution and time-travel support.
  • Develop and operate Apache Airflow DAGs, including dependencies, scheduling, and failure notifications.
  • Migrate Alteryx transformation workflows into SQL, dbt, and Python implementations.
  • Develop an MCP server that enables AI agents to query Gold-layer data marts with metadata, ontology, and query-execution capabilities.
  • Manage metadata and data lineage using OpenMetadata and automate Excel reporting with Python and openpyxl.

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 with model design, incremental strategies, macros, and tests.
  • Python proficiency for data processing and automation, including 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, star schema, and dimensional modeling.
  • Experience integrating relational database sources using CDC or batch processing.
  • Experience with Kubernetes and MinIO or equivalent S3-compatible storage.
  • Preferred experience with Airbyte or Fivetran, Apache Polaris, OpenMetadata or DataHub, Cube.dev, and Alteryx workflow migration.
  • Preferred experience developing MCP servers, applications, APIs, backend services, LLM or RAG pipelines, AI-agent workflows, LangChain, and LangGraph.
  • Preferred understanding of retail and home-appliance domains, including PSI and sales analytics.
  • Preferred Java and/or Python application development experience.

Benefits

  • One-year contract period.
  • Work location: Plano, Texas.
  • Pay rate stated as $10,371.64 per month, depending on experience.

Tech Stack

AirbyteApache AirflowApache SparkdbtJavaKubernetesMicrosoft SQL ServerPandasPrestoPython

Categories

Data Engineering
SBT Global, Inc.

About SBT Global, Inc.

11-50 employees

SBT Global, Inc. provides consulting, implementation, and managed services for enterprise systems, focusing on SAP S/4HANA, SAP-centric add-ons, and Salesforce CRM. The company supports full life-cycle delivery—from data/BI-driven design to operations and maintenance—and also staffs on-site network operations for enterprise environments. Founded in 2004 and headquartered in Seongnam-si, Gyeonggi-do, South Korea, it serves enterprises seeking ERP/CRM modernization and ongoing application management.

Contact me