Lead Management Information Analyst: Data Dashboards & Insights

HSBC; Jakarta Pusat; On-site; IDR 180,000,000 - 240,000,000; Full time

Job summary

HSBC is seeking a data analyst in Jakarta to extract, validate, and transform data from multiple sources using SQL and other processing tools. You will prepare daily, weekly, and monthly management reports to support performance and decision-making.

We expect strong SQL, advanced Excel, and data visualization skills (Pivot Tables, Power Pivot, VBA, Python, Altair). Collaboration with cross‑functional teams and clear communication are essential to success.

Qualifications

• Bachelor’s degree or MI experience preferred.
• Strong SQL knowledge for data extraction, editing, and analysis.
• Advanced Excel skills with Pivot Tables, Power Pivot, and VBA/Macro.
• Experience with Python and Altair is a plus.
• Excellent analytical and problem-solving skills.

Responsibilities

• Extract, validate, and transform data from multiple sources using SQL and other data processing tools to ensure data accuracy and consistency.
• Prepare and maintain daily, weekly and monthly management reports to support business and operational performance.
• Develop interactive dashboards and visualizations that provide meaningful business insights for stakeholders.
• Support business decision‑making by providing timely, accurate and actionable management information.
• Collaborate with cross‑functional stakeholders to understand reporting requirements and recommend data‑driven solutions.

Skills

SQL

Advanced Excel

Analytical thinking

Independent work

Communication

Python

Altair

Education

Bachelor’s degree

Tools

Pivot Tables

Power Pivot

VBA/Macro

Python

Altair

Job description

HSBC is seeking a data analyst in Jakarta to extract, validate, and transform data from multiple sources using SQL and other processing tools. You will prepare daily, weekly, and monthly management reports to support performance and decision-making.

We expect strong SQL, advanced Excel, and data visualization skills (Pivot Tables, Power Pivot, VBA, Python, Altair). Collaboration with cross‑functional teams and clear communication are essential to success.