You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Company hidden

Jr. Data Architect/Engineer

  • Office
  • 0-3 years

Salary

Not stated

Similar roles pay $60K - 125K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

This is a mid-level position on a brand-new data platform that brings together the company's GSCM, SEASI, SMART and BOSS systems.

You would own the pipeline end to end, from ingestion through the Bronze, Silver and Gold layers, while moving legacy Alteryx workflows into code-based dbt and Python.

You would also build an MCP server so AI agents can query the business data marts, supporting the company's AI analytics work.

The goal is a scalable, governed data foundation that speeds up business insight and AI adoption.

Responsibilities

  • Pull data from Microsoft SQL Server (BOSS) and Oracle into the Bronze layer, using CDC for incremental loads.
  • Build dbt models for Silver that handle cleansing, standardization, deduplication and data quality tests.
  • Create Gold business data marts and port the existing Alteryx logic into them.
  • Set up Apache Iceberg tables and a REST Catalog, including schema evolution and time travel.
  • Build and run Apache Airflow DAGs, covering dependencies, scheduling and failure alerts.
  • Build an MCP server that gives AI agents catalog and metadata access, ontology integration and query execution against Gold marts.
  • Manage metadata and data lineage in OpenMetadata.
  • Automate Excel reporting with Python and openpyxl.

Requirements

  • 3+ years of hands-on data engineering in production environments.
  • Strong SQL, including window functions, CTEs and query tuning.
  • Practical dbt experience with model design, incremental strategies, macros and tests.
  • Python for data processing and automation, including pandas.
  • Experience building 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 or dimensional modeling.
  • Experience integrating relational sources such as Microsoft SQL Server and Oracle through CDC or batch processing.
  • Required 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: experience with EL tools such as Airbyte or Fivetran, and Iceberg REST Catalog implementations such as Apache Polaris.
  • Preferred: experience with governance tools such as OpenMetadata or DataHub, and semantic layers such as Cube.dev.
  • Preferred: ability to read Alteryx workflows (.yxmd) and migrate their logic to SQL or dbt.
  • Preferred: experience developing MCP servers or building LLM, RAG or AI agent pipelines.
  • Preferred: experience developing applications, APIs or backend services in Java and/or Python.
  • Preferred: experience building GenAI applications, including LLM integration, retrieval-augmented generation (RAG) and AI agent workflows.
  • Preferred: hands-on work with LangChain and/or LangGraph for tool-enabled AI agents and multi-step workflows.
  • Preferred: understanding of retail and home appliance domains, including PSI (Production, Sales, and Inventory) and sales analytics.
  • 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.

Conditions

Contract length: 1 year.

Pay: $10,371.64 per month, depending on experience (DOE).

Applicant information is kept confidential under EEO guidelines.

Where you’d work

From the office

About the company

Company hidden

Office in TX, United States

Your chances

Likely still hiring, not crowded yet, and you'd be among the first.

  • 15 checks run
  • 4 good signs
  • 2 red flags

Still hiring?

10 checks

Likely active

In its favour2

  • Still on the company's own careers site, checked 1 h agoModerate evidence
  • Found in the last 48 hours, before the big job boardsModerate evidence

Against it1

  • Listed for the 3rd time after earlier listings of it closedModerate evidence

How crowded?

5 checks

Low

In its favour2

  • In its Early Window: not on the big job boards yetStrong evidence
  • Asks for Airflow, which only 1% of open roles doSlight evidence

Against it1

  • Entry level: the most applied-to level there isModerate evidence

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details11 facts · Role, Location, Compensation, Employment
Tech stack
  • Python
  • SQL
  • Kubernetes
  • dbt
  • Spark
  • Airflow
  • Excel
  • LLMs
  • RAG
  • LangChain
Seniority
Junior
Type
Contract
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 5 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Seniority
Junior
Experience
3+ years
Tech stack
  • Python
  • SQL
  • Kubernetes
  • dbt
  • Spark
  • Airflow
  • Excel
  • LLMs
  • RAG
  • LangChain

Location

Work model
Office
Region
United States
Office
  • TX, United States

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Contract

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason