Data Architect/Engineer- Bilingual Korean/ English)

Posted 3 Days Ago
Be an Early Applicant
Plano, TX, USA
In-Office
110K-120K Annually
Mid level
Information Technology • Professional Services
The Role
Build and operate a greenfield data platform using Medallion Architecture, integrating SQL Server and Oracle sources. Develop dbt and Python transformations, Airflow pipelines, Iceberg tables, business data marts, metadata and lineage capabilities, and an MCP server for AI-agent data access. Migrate Alteryx workflows, automate Excel reporting, and support governed analytics and AI adoption.
Summary Generated by Built In
Company Description

For More Open Positions Visit us at:
http://recruiting.woongjininc.com/

Our Mission

WOONGJIN INC. is a rapidly growing team who provides a range of unique, exceptional, and enhanced services to our clients.  We have a strong moral code that includes the service of goodness without expectations of reward.  We are motivated by the sense of responsibility and servant leadership.

Benefits

  • Medical Insurance
  • Vision Insurance
  • Dental Insurance
  • 401(k)
  • Paid Sick hours

 

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

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
  • 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

 

Additional Information

All your information will be kept confidential according to EEO guidelines.

 

Skills Required

  • Bilingual Korean and English
  • 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 pandas
  • Experience developing Apache Airflow DAGs
  • Experience with Trino, Presto, Apache Spark, or DuckDB
  • Experience with Apache Iceberg, Delta Lake, or Apache Hudi
  • Experience with Medallion Architecture and star schema or dimensional modeling
  • Experience integrating relational database sources such as Microsoft SQL Server and Oracle using CDC or batch processing
  • Experience with Airbyte or Fivetran and Iceberg REST Catalog implementations such as Apache Polaris
  • Experience with OpenMetadata or DataHub and semantic layers such as Cube.dev
  • Ability to interpret Alteryx workflows and migrate their logic to SQL or dbt
  • Experience developing MCP servers or building LLM, RAG, or AI agent pipelines
  • Experience developing applications, APIs, or backend services using Java or Python
  • Experience building Generative AI applications, including LLM integration, RAG, and AI agent workflows
  • Hands-on experience with LangChain or LangGraph for tool-enabled AI agents and multi-step workflows
  • Understanding of retail and home appliance business domains, including PSI and sales analytics
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Buena Park, CA
24 Employees
Year Founded: 1976

What We Do

Woongjin Inc. is a Korean based company in the US providing unique IT Consulting and Recruiting/Staffing services.

Similar Jobs

HiBob Logo HiBob

Marketing Manager

HR Tech • Information Technology • Professional Services • Sales • Software
Remote or Hybrid
US
1350 Employees

Sonar Logo Sonar

Technical Account Manager

Artificial Intelligence • Cloud • Security • Software
Easy Apply
Remote or Hybrid
USA
800 Employees

Hewlett Packard Enterprise Logo Hewlett Packard Enterprise

Creative Strategist (Houston, TX / San Jose, CA)

Artificial Intelligence • Cloud • Information Technology • Consulting
Hybrid
2 Locations
85422 Employees
109K-251K Annually

SoFi Logo SoFi

Retail Production Assistant

Fintech • Mobile • Software • Financial Services
Easy Apply
Remote or Hybrid
2 Locations
4500 Employees
27-51 Hourly

Similar Companies Hiring

Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account