Data Engineer Support

PT Lawencon Internasional; Jakarta Selatan; On-site; IDR 180,000,000 - 320,000,000; Full time

Job summary

PT Lawencon Internasional is seeking a Data Engineer to design, build, and optimize ETL/ELT pipelines and data models. You will work with Spark, SQL, SSIS, and IBM/I Informatica tools to deliver reliable data solutions for business needs.

The role requires collaboration with analysts and tech teams to gather requirements, maintain data quality, and ensure security. Jakarta-based position with a focus on scalable data architectures.

Qualifications

• Minimum 1 year of experience in Data Engineering or related field.
• Degree in Informatics Engineering, CS, or IS or equivalent.
• Strong SQL and database development experience.
• Experience with SSIS and IBM InfoSphere products.
• Hands-on data processing with Apache Spark (PySpark/SparkR/Scala).
• Proficient in Python and/or R.
• Knowledge of data modeling, architecture, and warehousing concepts.
• Ability to collaborate with business users and tech teams.

Responsibilities

• Design, develop, and maintain ETL/ELT processes for data extraction, transformation, and loading.
• Build, optimize, and manage data pipelines for efficient processing.
• Develop and maintain SQL scripts, stored procedures, and DB objects.
• Design data models, warehousing, and architectures to support needs.
• Integrate data across platforms and sources.
• Utilize Apache Spark for large-scale data processing.
• Develop automation for data workflows and integrations.
• Collaborate with users and teams to gather requirements and deliver data solutions.
• Monitor, troubleshoot, and optimize ETL jobs for performance and reliability.
• Ensure data quality, integrity, and security; document procedures.

Skills

SQL

Python

Spark

ETL/ELT

Data modeling

Data warehousing

SSIS

DB2

Communication

Team collaboration

Education

Diploma or Bachelor's degree in Informatics Engineering, Computer Science, Information Systems, or a related field

Tools

IBM InfoSphere DataStage

InfoSphere Information Analyzer

InfoSphere BPM

RAD/Workbench

PME

DB2

Informatica Data Integration / PowerCenter

Job description

• Design, develop, and maintain ETL/ELT processes for data extraction, transformation, and loading.


• Build, optimize, and manage data pipelines to ensure efficient and reliable data processing.


• Develop and maintain SQL scripts, stored procedures, and database objects.


• Design and implement data models, data warehouses, and data architectures to support business needs.


• Perform data integration across multiple platforms and heterogeneous data sources.


• Utilize Apache Spark (PySpark, SparkR, or Scala) for large-scale data processing.


• Develop automation solutions for data workflows and integration processes.


• Collaborate with business users, analysts, and technical teams to gather requirements and deliver data solutions.


• Monitor, troubleshoot, and optimize ETL jobs and data pipelines to ensure performance and reliability.


• Ensure data quality, integrity, security, and compliance with organizational standards.


• Document technical designs, workflows, and operational procedures.

• Minimum 1 year of experience in Data Engineering or a related field, or equivalent practical experience.


• Diploma or Bachelor's degree in Informatics Engineering, Computer Science, Information Systems, or a related field.


• Strong experience with SQL and database development.


• Experience using SQL Server Integration Services (SSIS).


• Hands-on experience with IBM InfoSphere products, including DataStage, Information Analyzer (IA), Business Process Manager (BPM), Rational Application Developer (RAD/Workbench), Performance Management Edition (PME), and DB2.


• Experience with Informatica Data Integration / Informatica PowerCenter or equivalent Informatica solutions.


• Experience using Apache Spark for data processing with PySpark, SparkR, or Scala.


• Proficiency in Python and/or R programming.


• Experience in designing and implementing ETL/ELT processes.


• Solid understanding of data modeling, data architecture, and data warehousing concepts.


• Knowledge of data integration, information management, data processing, and workflow automation across multiple platforms.


• Strong understanding of various database technologies, including relational and non-relational databases.


• Strong analytical, problem-solving, and communication skills.


• Ability to work independently as well as collaboratively in a team environment.