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.
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
- 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.
Similar Jobs
Computer Vision • Hardware • Machine Learning • Robotics • Software
Lead electromagnetic design of custom BLDC and PMSM motors for humanoid robot joints from concept through prototype and volume manufacturing. Perform advanced simulations, define motor performance targets, validate designs using motor dyno testing, and correlate models with hardware. Collaborate with mechanical, thermal, electrical, controls, manufacturing, vendors, and university partners to optimize torque density, ensure design-for-manufacturing, manage technical requirements, and support technology transfer.
Top Skills:
Altair FluxAnsys MaxwellBldc MotorsFocInverter SystemsJmagMatlabMotor DynoMotor-CadPmsm MotorsPython
Computer Vision • Hardware • Machine Learning • Robotics • Software
Leads a team developing real-time control software for humanoid robots. Responsibilities include hiring and mentoring engineers, managing controls roadmap delivery, reviewing designs and code, maintaining testing and release quality, validating simulation-to-hardware performance, and collaborating with firmware, embedded software, learning, teleoperation, systems, and test teams. The role requires hands-on expertise in robot controls, C++ real-time software, physical robot deployment, and engineering leadership.
Top Skills:
C++Continuous IntegrationDrakeHardware-In-The-Loop TestingIsaac SimMujocoReinforcement LearningRos 2
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Owns digital architecture and synthesizable SystemVerilog RTL for high-speed interface ASICs from micro-architecture through tape-out. Responsibilities include CDC strategy, synthesis, timing constraints and closure, physical-design coordination, self-verification, assertions, DFT support, documentation, and mixed-signal integration. The role collaborates closely with analog, layout, verification, and characterization teams on PHY-adjacent silicon development.
Top Skills:
AtpgCadence GenusCadence InnovusCadence TempusDdrDftDveI2CJaspergold CdcLibertyMentor CalibrePrbsSerdesSpfSpyglassSvaSynopsys Design CompilerSynopsys PrimetimeSystemverilogVcsVerdiXcelium
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
