Data Engineer

PT. Yafii Solusi Internasional; Jakarta Pusat; On-site; IDR 240,000,000 - 420,000,000; Full time

Job summary

PT. Yafii Solusi Internasional is seeking a Data Engineer to own the data engineering parts of AI and data solution projects.

You will build data pipelines, lakehouses, and warehouses in Microsoft Fabric and prepare datasets for AI/ML and analytics, collaborating with data scientists, BI developers, and project managers. You will gather requirements in client sessions, design data models, ensure quality and security, and contribute to code reviews, sprint planning, and team meetings.

Qualifications

• 2–3 years in data engineering or a related role.
• Strong foundation in ETL/ELT, data warehousing, dimensional modeling, data lake concepts, batch vs. streaming.
• Strong SQL and proficiency in Python (or PySpark).
• Hands-on experience with Microsoft Fabric.
• Experience delivering data engineering work in a real project, ideally in a team setting.
• Ability to take part in client requirement gathering and write clear documentation.
• Good teamwork and communication skills.

Responsibilities

• Contribute to the data engineering workstream of AI and data solution projects, from design through deployment.
• Build and maintain data pipelines, lakehouses, and warehouses in Microsoft Fabric (Data Factory, Lakehouse, Warehouse, Notebooks, OneLake).
• Prepare and serve data for AI/ML and analytics use cases, such as feature datasets, curated layers, and data for reporting in Power BI.
• Work closely with AI engineers and Business analysts to understand data needs and deliver usable, well-documented datasets.
• Join client meetings with the team to gather requirements, and help turn them into data requirements, source mappings, data flows, and acceptance criteria.
• Design data models and architecture (e.g., medallion, star schema) with input from the team.
• Ensure data quality, performance, security, and documentation.
• Take part in code reviews, sprint planning, and team meetings.
• Communicate progress, risks, and technical options clearly to teammates and clients.

Skills

SQL

Python / PySpark

ETL/ELT

Data Warehousing

Dimensional Modeling

Data Lake Concepts

Batch vs Streaming

Microsoft Fabric

Communication

Tools

Power BI

Databricks

Azure Data Factory

Git / CI/CD

SQL tooling

Job description

PT. Yafii Solusi Internasional is a dynamic Software Development and System Integrator Consulting company dedicated to delivering innovative solutions. Focused on empowering individuals and organizations, the company leverages cutting-edge technology to address complex challenges. Committed to excellence, Yafii Solusi Internasional collaborates with clients to provide customized services that drive digital transformation and business growth.

About the role

Company Description

PT. Yafii Solusi Internasional is a dynamic Software Development and System Integrator Consulting company dedicated to delivering innovative solutions. Focused on empowering individuals and organizations, the company leverages cutting-edge technology to address complex challenges. Committed to excellence, Yafii Solusi Internasional collaborates with clients to provide customized services that drive digital transformation and business growth.

About the role

We’re looking for a Data Engineer to join our team delivering AI and data solutions for clients. You’ll work alongside data scientists, AI engineers, BI developers, and project managers, and own the data engineering part of each project: getting the right data, in the right shape, reliably, so the team can build analytics and AI on top of it. You’ll also join client sessions to help gather and analyze requirements.

What you’ll do

• Contribute to the data engineering workstream of AI and data solution projects, from design through deployment
• Build and maintain data pipelines, lakehouses, and warehouses in Microsoft Fabric (Data Factory, Lakehouse, Warehouse, Notebooks, OneLake)
• Prepare and serve data for AI/ML and analytics use cases, such as feature datasets, curated layers, and data for reporting in Power BI
• Work closely with AI engineers and Business analysts to understand data needs and deliver usable, well-documented datasets
• Join client meetings with the team to gather requirements, and help turn them into data requirements, source mappings, data flows, and acceptance criteria
• Design data models and architecture (e.g., medallion, star schema) with input from the team
• Ensure data quality, performance, security, and documentation
• Take part in code reviews, sprint planning, and team meetings
• Communicate progress, risks, and technical options clearly to teammates and clients

Requirements

Must have

• [2-3]+ years in data engineering or a related role
• Solid foundation in data engineering: ETL/ELT, data warehousing, dimensional modeling, data lake concepts, batch vs. streaming
• Strong SQL and proficiency in Python (or PySpark)
• Hands-on experience with Microsoft Fabric
• Experience delivering data engineering work in a real project, ideally in a team setting
• Ability to take part in client requirement gathering and requirement analysis, and write clear documentation
• Good teamwork and communication skills

Nice to have

• Experience supporting AI/ML or GenAI projects (data preparation, feature pipelines, vector/RAG data pipelines, MLOps awareness)
• Azure services (Data Factory, Synapse, Databricks, ADLS, Azure AI services)
• Power BI and DAX knowledge
• Git, CI/CD, and DataOps practices
• Fabric or Azure certifications (e.g., DP-600, DP-700, DP-203, AI-102)
• Consulting or client-facing project experience