Senior Business Analyst (Advanced SQL Expert)

Helius Technologies Pte Ltd; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Helius Technologies Pte Ltd in Singapore is seeking a Senior Business Analyst (Advanced SQL Expert) to lead complex data analysis and optimize core business processes using production-grade SQL and large-scale databases.

The role emphasizes translating business problems into functional specs, driving agile practice with Jira, and delivering actionable BI dashboards in Power BI and Tableau to senior leadership.

Qualifications

• Proven track record writing production-grade SQL with heavy optimization, CTEs, complex window functions, dynamic SQL, subqueries, and stored procedures.

Responsibilities

• Write, optimize, and maintain complex SQL scripts to extract data, audit pipeline accuracy, and solve non-trivial business problems.
• Partner with engineering teams to design scalable data models and validate complex database migrations.
• Run UAT, set up data-validation test suites, and ensure strict compliance with Singapore’s PDPA guidelines.

Skills

Expert SQL

Agile & Jira

Data visualization

Tools

PostgreSQL

Snowflake

BigQuery

MySQL

Power BI

Tableau

Job description

About the role

Senior Business Analyst (Advanced SQL Expert)

Location: Singapore

Role Overview

Lead complex data analysis and system operations by leveraging expert-level SQL capability to query multi-terabyte databases, drive business strategy, and optimize core business processes.

Top 3 Core Skills Required

1. Expert SQL & Complex Querying (Primary Focus):

   • Proven track record writing production-grade SQL (heavy optimization, CTEs, complex window functions, dynamic SQL, subqueries, and stored procedures).

   • Expertise in querying large-scale relational databases (PostgreSQL, Snowflake, BigQuery, MySQL) and performance-tuning slow queries.

2. Requirements Engineering & Agile Alignment:

   • Translating complex business problems into clear functional specs, user stories, and process flowcharts using Agile/Jira.

3. Data Visualization & Stakeholder Communication:

   • Translating raw SQL output into actionable BI dashboards (Power BI, Tableau) and presenting key findings to senior leadership.

Key Responsibilities

• Write, optimize, and maintain complex SQL scripts to extract data, audit pipeline accuracy, and solve non-trivial business problems.

• Partner with engineering teams to design scalable data models and validate complex database migrations.

• Run User Acceptance Testing (UAT), set up data-validation test suites, and ensure strict compliance with Singapore’s PDPA guidelines.

Helius Technologies Pte Ltd

36 Robinson Road, #13-05, City House, Singapore 068877