Data Analyst (Hive, Python)- Contract

QUESS SELECTION & SERVICES PTE. LTD.; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

QUESS SELECTION & SERVICES PTE. LTD.

in Singapore is seeking a Data Analyst with strong financial and operational analytics experience to build and maintain data index systems, perform cost/ROI analysis, and provide data-driven insights that support business planning and performance improvement. The role involves extracting data with SQL across Hive, Presto, and MySQL; applying SPSS methods; developing dashboards in Excel and Tableau; and collaborating with finance, operations, and business

Qualifications

• Bachelor's degree in Information Technology or related field.
• At least 7 years in data analytics, BI, or financial/operational analytics.
• Proven experience building or maintaining index/monitoring systems.

Responsibilities

• Build and maintain financial operation index systems and monitor key indicators daily.
• Support automated account-checking and financial control systems to reduce risk.
• Perform cost analysis and ROI breakdowns to support improvements.
• Extract, consolidate, and analyse data from multiple sources using SQL across Hive, Presto, MySQL.
• Apply SPSS methods for diagnostics and insights.
• Develop dashboards and KPIs in Excel and Tableau for decision-making.
• Collaborate with business, finance, and ops to translate requirements into actions.
• Assist in automating reporting and data analysis to improve accuracy and efficiency.

Skills

SQL

Hive

Presto

MySQL

SPSS

Excel

Tableau

Python

ROI analysis

Dashboarding

Education

Bachelor's degree in Information Technology or related field

Tools

NumPy

Pandas

Job description

Job Summary

We are looking for a Data Analyst with strong financial and operational analytics experience to build and maintain data index systems, perform cost/ROI analysis, and provide data-driven insights that support business planning and performance improvement.

Key Responsibilities

• Build and maintain financial operation index systems, monitoring key indicators daily to identify issues and drive optimization.
• Support the design and upkeep of automated account-checking and financial control systems to reduce risk and capital losses.
• Perform cost analysis and revenue/cost breakdowns to support ROI improvement initiatives.
• Extract, consolidate, and analyse data from multiple sources using SQL across Hive, Presto, and MySQL environments, ensuring data accuracy and consistency.
• Apply statistical analysis techniques (e.g. principal component/factor analysis, cluster analysis, variance analysis, chi-square tests) using SPSS to support business diagnostics.
• Develop and maintain management reports, dashboards, and KPIs using Excel and Tableau to support business monitoring and decision-making.
• Partner with business, finance, and operational stakeholders to translate reporting requirements into actionable, data-driven recommendations.
• Support the improvement and automation of reporting and data analysis processes to reduce manual work and improve efficiency and accuracy.

Candidate Requirements

• Bachelor's degree Information Technology n.e.c. or a related field.
• At least 7 years of experience in a data analyst, business analyst, or financial/operational analytics role.
• Proven experience building or maintaining a financial operation index or performance-monitoring system.
• Proficient in SQL, with hands-on experience across Hive, Presto, and MySQL for data extraction and processing.
• Working knowledge of SPSS for statistical analysis (e.g. factor analysis, cluster analysis, variance analysis).
• Strong skills in Excel and Tableau for data visualisation and dashboard development. Experience in cost analysis, ROI analysis, or financial control/account-checking systems is required.
• Proficient knowledge of Python (NumPy, Pandas) for data processing is an advantage.
• Strong communication skills, with the ability to work cross-functionally with business, finance, and operations teams.