Data Architect​/Engineer

Company Description For More Open Positions Visit us at:
MissionWOONGJIN 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 Open Metadata Automate  Excel reporting using Python and openpyxl

Qualifications3+ 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 DAGsExperience with at least one analytical engine:
Trino/Presto, Apache Spark, or DuckDBExperience 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 Open Metadata or Data Hub, 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 Lang Chain and/or Lang Graph 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 SkillsSQLdbt Pythonpandas Apache  Airflow Trino/Presto or Apache Spark or DuckDBApache Iceberg or Delta Lake or Apache Hudi Microsoft SQL Server Oracle Kubernetes Min IO (S3-compatible storage)
Preferred Technical Skills Java or Python Generative AI (GenAI) and LLM integration

Lang Chain Lang Graph RAG and AI agent pipelinesMCP server development

Airbyte Fivetran Apache  Polaris Open Metadata Data Hub Cube .devAlteryxopenpyxl

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

Summary Type:
Contract Function:
Engineering Experience level:
Mid-Senior Level Industry: Information Technology And Services