Jr. Data Architect/Engineer (W2 only)

Marlabs Inc.; Plano (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Marlabs Inc. is building a new greenfield data platform to integrate internal systems using a Medallion Architecture. You will own end-to-end data pipelines from ingestion to Gold data marts, migrating Alteryx workflows to dbt and Python implementations for scalable analytics.

You will also develop an MCP server and leverage OpenMetadata for data governance, enabling AI-driven analytics across the organization. This role emphasizes ownership, scalability, and governance of a modern lakehouse.

Qualifications

• 3+ years of hands-on data engineering in production environments.
• Advanced SQL skills with window functions, CTEs, and query tuning.
• Hands-on dbt experience: model design, incremental strategies, macros, tests.
• Python proficiency for data processing and automation (pandas).
• Experience with Trino/Presto, Apache Spark, or DuckDB.
• Experience with Iceberg, Delta Lake, or Apache Hudi.
• Experience with Medallion Architecture and star schema modeling.
• Experience integrating SQL Server and Oracle via CDC or batch processing.

Responsibilities

• Ingest data from sources like SQL Server (BOSS) and Oracle into Bronze with CDC-based ingestion.
• Develop dbt models for Silver: cleansing, standardization, deduplication, data quality testing.
• Create Gold layer data marts and migrate Alteryx logic to SQL/dbt.
• Configure Iceberg tables and REST Catalog; enable schema evolution and time travel.
• Develop and operate Airflow DAGs; manage dependencies, scheduling, and alerts.
• Develop MCP server to query Gold-layer data marts for AI agents.
• Manage metadata and data lineage using OpenMetadata.
• Automate Excel reporting with Python and openpyxl.

Skills

SQL

dbt

Python

Trino/Presto

Apache Spark

DuckDB

Apache Iceberg

Delta Lake

Apache Hudi

Medallion Architecture

CDC ingestion

OpenMetadata

Apache Airflow

API/Backend

LangChain/LangGraph

Tools

OpenMetadata

Airflow

Job description

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. 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. 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. Success in this role will deliver a scalable, governed data foundation that accelerates business insights and AI adoption.

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 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
• Understanding of retail and home appliance business domains, including PSI (Production, Sales, and Inventory) and sales analytics

Required Technical Skills

• SQL
• dbt
• Python
• Trino/Presto or Apache Spark or DuckDB
• Apache Iceberg or Delta Lake or Apache Hudi