Business Intelligence Engineer

MGMI - mGanik Grup Mitra Indonesia; Jakarta Barat; On-site; IDR 223,200,000 - 424,080,000; Full time

Job summary

MGMI - mGanik Grup Mitra Indonesia seeks a data and technical lead to build and maintain Compass, a central BI dashboard for management. You will manage data sources, processing, dashboards, and support applications with secure, scalable solutions.

You will implement metric definitions, ensure data quality, and provide guidance on reading metrics to leaders. Collaboration across Finance, Sales, Marketing, and Operations is essential.

Qualifications

• Highly proficient in writing SQL queries and joining data sources.

Responsibilities

• Translate information requirements by clarifying management needs and preparing data designs, dashboards, and effort estimations.
• Develop data source integrations into approved applications and databases, including 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 with charts, filters, drill-downs, and update time statuses.
• Develop supporting applications including frontend, backend, and API development; review AI-assisted code.
• Implement security and testing standards (authorization, data access restrictions) and address risk findings.
• Release and maintain applications via testing, deployments, monitoring, bug fixes, and documentation.
• Support users by explaining metric readings, aiding data tracking, and communicating issues to management.

Skills

SQL

Data integration

Data modeling

Dashboard viz

App development

AI-assisted dev

Security & testing

Business understanding

Job description

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.