Data Engineer: Build, Optimize Pipelines & BI Dashboards

TOG Indonesia; Jakarta Pusat; On-site; IDR 240,000,000 - 420,000,000; Full time

Job summary

TOG Indonesia is seeking a data engineer to gather requirements, design technical solutions, and build robust data pipelines using SSIS and SQL. The role emphasizes data quality, governance, and analytics to support business decisions.

You will develop dashboards with Tableau and other BI tools, participate in SDLC processes, and collaborate with vendors and teams to deliver high-quality data solutions.

Qualifications

• Bachelor's Degree in IT, CS, or related field.
• 3 years of experience in Data Engineering in financial services or similar sector.
• Strong understanding of SDLC.
• Proficient in SQL Server, Oracle SQL, and PL/SQL.
• Hands-on experience with data integration tools, especially SSIS; Talend or Pentaho is a plus.
• Proficient in BI tools, especially Tableau; Power BI or Qlik Sense is a plus.
• Strong teamwork and communication skills.
• Proficient in Microsoft Office Suite (Word, Excel, PowerPoint).
• Strong analytical thinking and problem-solving skills.
• Ability to create mocks, data pipelines, ERD, and Star Schema models.
• Detail-oriented with high accuracy.
• Ability to prepare and maintain project and data documentation.

Responsibilities

• Gather and analyze user requirements and design appropriate technical solutions.
• Develop, test, and monitor approved solutions before delivering to end users.
• Develop and maintain data pipelines from source systems to the data warehouse using SSIS and build data marts.
• Troubleshoot issues within existing data pipelines and document problems with resolutions.
• Manage data quality processes, including validation, cleansing, and monitoring.
• Optimize data pipeline performance and SQL queries.
• Support Data Governance practices including metadata management and data catalog maintenance.
• Serve as first-level support for data pipeline issues.
• Participate in strategic planning for data engineering and analytics.
• Prepare and maintain comprehensive project documentation.
• Provide recommendations for policies, guidelines, and procedures.
• Perform data analysis to generate actionable insights for decision-making.
• Develop dashboards and visualizations using Tableau or other BI tools; design interactive dashboards.
• Validate results and present findings clearly; evaluate dashboard performance and iterate.

Skills

SDLC understanding

Data analysis

Teamwork

Communication skills

Analytical thinking

Attention to detail

Education

Bachelor's Degree in IT / CS

Tools

SSIS

SQL Server

Oracle SQL

Talend

Pentaho

Tableau

Power BI

Job description

TOG Indonesia is seeking a data engineer to gather requirements, design technical solutions, and build robust data pipelines using SSIS and SQL. The role emphasizes data quality, governance, and analytics to support business decisions.

You will develop dashboards with Tableau and other BI tools, participate in SDLC processes, and collaborate with vendors and teams to deliver high-quality data solutions.