Job description for Database and BI engineer at Dikshatek Indonesia
Requirements:
- Minimum Bachelor Degree in Data Science / Informatics Engineering / Computer Engineering / IT related.
- Strong SQL skills (complex query, optimization, indexing).
- Experience with relational databases (PostgreSQL, Oracle, SQL Server, MySQL, etc.)
- Strong understanding of ETL and data transformation concepts.
- Knowledge of Data Warehouse concepts and dimensional modeling.
- Familiar with ETL tools (Pentaho, Airflow, etc).
- Familiar with BI tools (PowerBI, Superset, etc).
- Experience with data migration strategies & processes.
- 3++ years experience in related fields.
Responsibilities:
- Design, build, and maintain scalable data pipelines (ETL).
- Integrate data from multiple sources such as databases, APIs, and third-party systems.
- Develop and manage Data Warehouse / Data Lake architecture.
- Ensure data quality, consistency, reliability, and security.
- Collaborate with business stakeholders to translate business requirements into data solutions & visualization.
- Optimize query performance and data transformation processes.
- Create technical documentation for data architecture and data flow.
- Monitor, troubleshoot, and maintain production data pipelines.
- Implement data governance and data engineering best practices.
