Jr. Data Architect/Engineer

BTI Solutions; Plano (TX); Sur place; USD 120 000 - 160 000; Plein temps

Résumé du poste

BTI Solutions, Inc. seeks a skilled Data Engineer to design and implement end-to-end data pipelines.

You will ingest data from SQL Server and Oracle into the Bronze layer using CDC-based incremental ingestion, and build dbt models for the Silver layer including cleansing, standardization, and quality tests. You will migrate Alteryx logic to Gold layer, configure Iceberg tables and a REST Catalog, and develop Airflow DAGs to manage dependencies, scheduling, and failures.

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

Responsabilités

• Ingest data from sources such as MS SQL Server and Oracle into Bronze with CDC-based ingestion.
• Develop dbt models for the Silver layer including cleansing, standardization, deduplication, and data quality testing.
• Develop Gold layer data marts and migrate existing Alteryx transformation logic.
• Configure Iceberg tables and REST Catalog with schema evolution and time travel.
• Develop and operate Airflow DAGs with dependency management, scheduling, and failure notifications.
• Develop an MCP server enabling AI agents to query Gold-layer data marts and access catalog/metadata.
• Manage metadata and data lineage using OpenMetadata.
• Automate Excel reporting using Python and openpyxl.

Connaissances

SQL

Window functions

CTEs

Python

pandas

dbt

Airflow

Spark/Presto/DuckDB

Iceberg/Delta/Hudi

Kubernetes

MinIO

Outils

dbt

Airflow

Apache Iceberg

OpenMetadata

Description du poste

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

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