Business Intelligence (Junior - Lead Level)

Cermati Fintech Group; Jakarta Pusat; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

Cermati Fintech Group in Jakarta is seeking a data analyst to interpret data, run queries, and build dashboards with Excel, SQL, BigQuery, Python, and R.

You will transform data into actionable insights, develop reports, and support management in decision making; requires bachelor/master in IS/CS/Math/Statistics; experience with Jupyter, BigQuery ML is a plus.

Qualifications

• Bachelor's or Master’s degree in Information Systems, Computer Science, Math, Statistics or related field.
• Expert in SQL with ability to write advanced DB queries (Python/R/Java/JavaScript desirable).
• Ability to quickly disseminate data to find key trends and perform deep dives.
• Experience handling large datasets; create complex visualizations from raw data in live dashboards.
• Excellent written and verbal communication skills.
• Experience with analytical tools (Jupyter, Python, Hive, BigQuery ML) is a plus.
• Ability to work well under pressure.

Responsibilities

• Interpreting data, analyzing results using query and data statistical techniques.
• Create robust, reusable data querying, transformation, and visualization processes using Excel, SQL, BigQuery, Python, R and other big data tools.
• Develop analytical reports and represent large, complex data sets through visual representations.
• Present information to drive fact-based decision making.
• Propose and define new business process improvements based on data to drive business impact.
• Work with management to prioritize business and information needs.

Skills

SQL

Data Visualization

Excel

Python

R

Education

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

Tools

BigQuery

Hive

Jupyter

Tableau

Job description

• 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.

Job Description

• 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.

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