- Analytics Engineer (SQL Datamart Developer)
Objective: Build and optimize SQL-based datamarts to support business intelligence and reporting needs.
Responsibilities:
- Design and implement scalable SQL datamarts from raw data sources.
- Optimize SQL queries for performance and maintainability.
- Collaborate with data analysts and business stakeholders to understand data requirements.
- Ensure data quality, consistency, and documentation.
- Create optimized fact tables which will be used in the data platform and modelling .
- Work with cloud data platforms (e.g., Snowflake)
Requirements:
- Strong SQL expertise (window functions, CTEs, indexing, etc.).
- Experience with dimensional data modeling (star/snowflake schema).
- Familiarity with ETL/ELT tools (e.g. Airflow).
- Experience with version control (Git) and CI/CD for data pipelines.
- Poin plus: Experience with cloud data warehouses and BI tools.
Hybrid SCBD (Jakarta Selatan)
Data Visualization & Strategic Dashboard Developer
Objective: Create interactive, insightful dashboards to support executive decision-making.
Responsibilities:
- Design and develop dashboards using tools like Power BI.
- Translate business KPIs into visual storytelling.
- Optimize dashboard performance and usability.
- Collaborate with stakeholders to iterate on dashboard features.
- Ensure data accuracy and consistency across visualizations.
Requirements:
- Proficiency in PowerBI.
- Strong understanding of data visualization best practices.
- Ability to work with SQL and connect to various data sources.
- Experience in UX/UI for dashboards.
- Hybrid SCBD (Jakarta Selatan)