Data analyst

PT Fandb Tech Indonesia; Kota Medan ᯔᯩᯑᯉ᯲; On-site; IDR 120,000,000 - 240,000,000; Full time

Job summary

PT Fandb Tech Indonesia is seeking a detail-oriented Data Analyst to transform business data into actionable insights that support strategic decisions. You will collaborate with Finance, Sales, Operations, and Management to build reports, dashboards, and performance analyses.

Responsibilities include data collection, cleaning, and validation from ERP, Excel, databases, and other systems; creating daily to monthly analytics; building Power BI dashboards; and presenting findings with clear

Qualifications

• Bachelor's degree as listed in education.
• 1 year of Data Analyst experience or strong portfolio.
• Advanced Excel skills (Pivot Table, XLOOKUP, INDEX-MATCH, Power Query).
• Proficient in SQL for data extraction and analysis.
• Experience with Power BI or Tableau.
• Strong analytical thinking and presentation abilities.
• Experience with ERP systems (SAP, Oracle, Odoo, Accurate, etc.).
• Understanding of financial statements and KPIs.
• Knowledge of Python (Pandas) is an advantage.

Responsibilities

• Collect, clean, and validate data from ERP, Excel, databases, and other systems.
• Develop daily, weekly, and monthly analytical reports.
• Build interactive dashboards using Power BI.
• Analyze sales, operational, inventory, and financial performance.
• Identify trends, anomalies, and opportunities for improvement.
• Present analytical findings and recommendations to management.

Skills

Analytical mindset

Attention to detail

Communication skills

Team collaboration

Problem solving

Education

Bachelor's degree in Statistics, Mathematics, Information Systems, Accounting, Industrial Engineering, or related field

Tools

Power BI

Tableau

SQL

Excel (Advanced)

ERP systems (SAP/Oracle/Odoo)

Job description

We are looking for a detail-oriented Data Analyst to transform business data into meaningful insights that support strategic decision-making. You will work closely with Finance, Sales, Operations, and Management to develop reports, dashboards, and performance analysis.

Key responsibilities

Collect, clean, and validate data from ERP, Excel, databases, and other business systems.

Develop daily, weekly, and monthly analytical reports.

Build interactive dashboards using Power BI.

Analyze sales, operational, inventory, and financial performance.

Identify trends, anomalies, and business improvement opportunities.

Present analytical findings and recommendations to management.

About you

Bachelor's degree in Statistics, Mathematics, Information Systems, Accounting, Industrial Engineering, or a related field.

Minimum 1 year of experience as a Data Analyst (fresh graduates with a strong portfolio are welcome).

Advanced Microsoft Excel skills (Pivot Table, XLOOKUP, INDEX-MATCH, Power Query).

Proficient in SQL for data extraction and analysis.

Experience with Power BI or Tableau.

Strong analytical thinking, attention to detail, and problem-solving skills.

Good communication and presentation abilities.

Experience with ERP systems (SAP, Oracle, Odoo, Accurate, etc.).

Understanding of financial statements and business KPIs.

Knowledge of Python (Pandas) is an advantage.

Supportive and collaborative work environment