Data Engineer (SQL)
Posted Updated
Summary
Data Engineer in Central Jakarta who designs, builds, and maintains data pipelines and writes and optimizes complex SQL for extraction, transformation, and reporting. Needs 2-3 years of data engineering experience and strong relational database skills (PostgreSQL, MySQL, SQL Server, or Oracle).
- Design, develop, and maintain data pipelines to support business and reporting requirements.
- Write, optimize, and maintain complex SQL queries for data extraction, transformation, and analysis.
- Perform data integration and transformation from multiple data sources.
- Ensure data accuracy, consistency, quality, and reliability.
- Monitor and troubleshoot data pipeline and database performance issues.
- Collaborate with business analysts, developers, and other stakeholders to understand data requirements.
- Maintain technical documentation related to data processes and database structures.
- Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related field.
- Minimum 2–3 years of experience as a Data Engineer or in a similar role.
- Strong proficiency in SQL, including complex queries, joins, subqueries, CTEs, and query optimization.
- Good understanding of database concepts, data modeling, and relational databases.
- Experience in developing and maintaining ETL/ELT processes and data pipelines.
- Familiarity with databases such as PostgreSQL, MySQL, SQL Server, or Oracle.
- Strong analytical, problem-solving, and troubleshooting skills.
- Able to work independently and collaboratively within a team.