Data-Driven BI Analyst: SQL, Dashboards & Insights

Cermati.com; Jakarta Pusat; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

Cermati.com is seeking a data analyst in Jakarta to interpret data, analyze results, and build robust querying, transformation, and visualization workflows using Excel, SQL, BigQuery, Python, and R. You will develop analytical reports that translate large data sets into clear visuals and support data-driven decisions.

Collaboration with management to prioritize information needs and drive business impact is essential in this role.

Qualifications

• Having bachelor degree or master degree in Information System, Computer Science, Math, Statistics or related field.
• Expert in SQL, have the ability to write advanced DB queries (able to use Python/R/Java/Javascript is desirable).
• Ability to quickly disseminate data to find key trends, as well as the ability to dive deep and mine the data behind these.
• Comfortable working with datasets containing millions of rows and creating complex visualizations from raw data in a live dashboard environment.
• Excellent written and verbal communication skills.
• Experience working with analytical tools (Jupyter, Python, Hive, BigQuery ML) is a plus
• Ability to work well and deliver under pressure

Responsibilities

• Interpreting data, analyzing results using query, data statistical techniques.
• Create robust, reusable data querying, transformation, and visualization processes using tools such as Excel, SQL, Big Query, Python, R and other big data tools.
• Develop analytical reports and represent large, complex sets of data through visual representation.
• Present information in a way that drives fact based decision making.
• Propose and define new business process improvement opportunities based on the data to drive business impact.
• Work with management to prioritize business and information needs.

Skills

Data analysis

SQL

Excel

BigQuery

Python

R

Data visualization

Communication

Statistical methods

Education

Bachelor's or Master in Information Systems / Computer Science / Math / Statistics

Tools

SQL

Excel

BigQuery

Python

R

Java

JavaScript

Hive

BigQuery ML

Job description

Cermati.com is seeking a data analyst in Jakarta to interpret data, analyze results, and build robust querying, transformation, and visualization workflows using Excel, SQL, BigQuery, Python, and R. You will develop analytical reports that translate large data sets into clear visuals and support data-driven decisions.

Collaboration with management to prioritize information needs and drive business impact is essential in this role.