
Jr. Data Architect/Engineer
SBT Global, Inc.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
Categories
Data Engineering
About SBT Global, Inc.
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.