Business Intelligence Engineer

Mganik Group; Jakarta Pusat; On-site; IDR 200,000,000 - 320,000,000; Full time

Job summary

MGMI is seeking a BI Engineer to own end-to-end technical and data execution for Compass, the central dashboard in the Northstar app used by MGMI's management and top leaders. You will manage data sources, process metrics, build dashboards, and develop supporting applications and system maintenance.

Responsibilities include data integration, data modeling, metric implementation, dashboard visualization, frontend/backend/API development, security, testing, and user support to help leadership read

Qualifications

• Proficient in SQL queries, data joins, and performance optimization.
• Experience extracting data from APIs, databases, or spreadsheets.
• Skilled in data modeling, metric implementation, and defining business calculations.
• Ability to design dashboards and visualizations for leadership.
• Experience building frontends, backends, and APIs.
• Capable of AI-assisted development with clear instructions to AI and code review.
• Knowledge of authentication, secrets management, deployments, and incident recovery.
• Strong business acumen to translate metrics for Finance, Sales, Marketing, and Supply Chain.

Responsibilities

• Translate management needs into data designs, dashboards, and effort estimates.
• Develop data source integrations and manage automatic updates.
• Process, clean, and model data to ensure traceable calculations.
• Define and document metric definitions with business owners.
• Maintain data accuracy with automated checks and reconciliation.
• Build the Compass dashboard with visuals, filters, and update statuses.
• Develop frontend, backend, and authentication integrations; review AI-assisted code.
• Enforce security standards, access controls, and risk remediation.
• Release, deploy, monitor, and document applications.
• Support users by explaining metrics and assisting with data tracking.

Skills

SQL & Database

Data Integration & Transformation

Data Modeling & Metric Implementation

Dashboard & Visualization

Application Development

AI-assisted Development

Security & Testing

Business Understanding

Job description

About the Role

This position is responsible end-to-end for the technical and data execution to build and maintain Compass, a business intelligence product within the Northstar app that serves as the central dashboard for MGMI's management and top leaders. The main responsibilities cover the entire data processing lifecycle, from managing data sources, processing metrics, and creating dashboards, to developing supporting applications and system maintenance.

Key Responsibilities

• Translate information requirements by clarifying management needs, as well as preparing data designs, dashboards, and effort estimations.
• Develop data source integrations into approved applications and databases, including handling authentication and scheduling automatic updates.
• Process, clean, and model data to ensure consistent and traceable calculations.
• Implement metric definitions and formulas confirmed by business owners and document them.
• Maintain data accuracy by building automated checks, reconciling data sources, and investigating data discrepancies.
• Build and develop the Compass dashboard, including chart visualizations, filters, drill-down details, and data update time statuses.
• Develop supporting applications, including building the frontend, backend, and authentication integrations, as well as reviewing and testing AI-assisted code.
• Implement engineering and security standards (such as authorization and data access restrictions) and follow up on risk findings.
• Release and maintain applications by executing testing, deployments, monitoring, bug fixing, and operational documentation.
• Support users by explaining how to read metrics, assisting with data tracking, and communicating issues to management.

Requirements

• SQL & Database: Highly proficient in writing queries, joining data sources, and optimizing data retrieval.
• Data Integration & Transformation: Capable of extracting data from APIs, databases, or spreadsheets, as well as cleaning data and managing automatic updates.
• Data Modeling & Metric Implementation: Expert in determining data granularity, table relationships, and consistently applying business calculation definitions.
• Dashboard & Visualization: Able to design charts and data visualizations that help leaders understand information easily.
• Application Development: Capable of building frontends, backends, and APIs.
• AI-assisted Development: Able to provide clear instructions to AI, review the resulting code, and verify application behavior hands-on.
• Security & Testing: Able to implement authentication, manage secrets, test data, execute deployments, and handle incident recovery.
• Business Understanding: Understand the context of business metrics (such as Finance, Sales, Marketing, Supply Chain) and able to communicate data limitations to management.