Data Warehouse Specialist

LanceSoft, Inc.; Jakarta Pusat; On-site; IDR 180,000,000 - 240,000,000; Full time

Job summary

LanceSoft, Inc. is seeking an experienced Data Warehouse / ETL Developer to support enterprise Data Warehouse development and maintenance.

The role emphasizes Oracle-based data development, ETL processes, data modeling, testing, deployment, and troubleshooting to ensure data quality and consistency. Responsibilities include analyzing requirements, designing ER diagrams, implementing Oracle SQL/PL/SQL logic, and deploying changes on on-premise Oracle databases within an Agile team.

Qualifications

• 3+ years of experience in Data Warehouse/ETL development or equivalent roles.
• Fluent English communication, both written and verbal.
• Experience with legacy Data Warehouse systems is a plus.

Responsibilities

• Analyze Data Warehouse requirements and prepare technical documentation for development.
• Develop and maintain Data Warehouse solutions based on business requirements.
• Design ER diagrams for modeled Data Warehouse areas.
• Develop complex data-processing logic using Oracle SQL and PL/SQL.
• Develop, test, document, and deploy database changes on on-premise Oracle databases.
• Design and execute ETL processes to support Data Warehouse requirements.
• Create test scripts and perform testing against business logic.
• Participate in issue resolution by identifying problems and root causes.
• Support maintenance and enhancement of legacy Data Warehouse systems.
• Provide refactoring recommendations on Data Warehouse vs. Data Mart and data modeling.

Skills

English proficiency

Analytical skills

Problem-solving

Agile mindset

Tools

Oracle SQL

PL/SQL

Oracle GoldenGate

ETL tooling

Job description

We are looking for an experienced Data Warehouse / ETL Developer to support the development, maintenance, and enhancement of enterprise Data Warehouse solutions. The role will focus on Oracle-based data development, ETL processes, data modeling, testing, deployment, and troubleshooting while ensuring data quality and consistency.

Key Responsibilities

• Analyze Data Warehouse requirements and prepare technical documentation for development.
• Develop and maintain Data Warehouse solutions based on business requirements.
• Design and provide ER diagrams for modeled Data Warehouse areas.
• Develop complex data-processing logic using Oracle SQL and PL/SQL.
• Develop, test, document, and deploy database changes on on-premise Oracle databases.
• Design and execute ETL processes to support Data Warehouse requirements.
• Create test scripts based on expected business logic and perform testing.
• Participate in issue resolution by identifying problems, addressing immediate impacts, and investigating root causes.
• Support the maintenance and enhancement of legacy Data Warehouse systems.
• Provide refactoring recommendations, including decisions on Data Warehouse vs. Data Mart, data normalization, and data modeling.
• Ensure data quality, consistency, and compliance by applying data governance principles and practices.
• Collaborate with business and technical teams in an Agile environment.
• Maintain proper version control and development documentation.

Requirements

• Fluent in English, both written and verbal.
• Minimum 3 years of experience as a Data Warehouse Developer, ETL Developer, or similar role.
• Experience developing and maintaining legacy Data Warehouse systems is a plus.
• Strong ability to develop complex data-processing logic using Oracle SQL and PL/SQL.
• Hands-on knowledge and experience with ETL processes.
• Good understanding of the business processes and requirements supported by Data Warehouse solutions.
• Awareness of data governance principles and practices to ensure data quality, compliance, and consistency.
• Knowledge and experience with Oracle GoldenGate.
• Comfortable working in an Agile environment.
• Strong analytical and problem-solving skills.