Technical Business Analyst - Advance SQL

Helius Technologies Pte Ltd; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

Helius Technologies Pte Ltd is seeking a Technical Business Analyst in Singapore to bridge business stakeholders and engineering teams. You will analyze workflows, translate requirements into technical specs, and write complex SQL queries to extract insights and validate data.

You will collaborate with data and engineering teams on data models, APIs, and dashboards (Tableau/Power BI), and perform UAT to ensure deliverables meet business needs.

Qualifications

• Write and optimize complex SQL queries across enterprise databases.
• Gather functional requirements from stakeholders and translate into technical specs, user stories, and workflows.
• Design data models, APIs, and business rules with engineering teams.

Responsibilities

• Bridge business stakeholders and engineering teams to ensure alignment.
• Build BI dashboards and perform UAT to verify deliverables.
• Collaborate on data models, APIs, and data flows.

Skills

Complex SQL

Business analysis

API/Data mapping

Data modeling

Education

Bachelor's degree in CS/IT/quantitative field

Tools

Tableau

Power BI

Jira

Confluence

Visio

Lucidchart

PostgreSQL

MySQL

Snowflake

MS SQL Server

Job description

Role Overview

We are looking for a Technical Business Analyst to bridge the gap between business stakeholders and engineering teams. In this role, you will analyze business workflows, translate requirements into technical specifications, and write complex SQL queries to extract insights, validate data, and support technical solutioning.

Core Responsibilities

• Write and optimize complex SQL queries (multi-table JOINs, CTEs, Window Functions, Subqueries) to query large enterprise databases and validate system data flows.
• Gather functional requirements from business stakeholders and translate them into detailed technical specifications, user stories, and system workflows.
• Partner with engineering and database teams to design data models, APIs, and business rules.
• Build BI dashboards (Tableau/Power BI) and perform UAT to ensure technical deliverables match business needs.

Key Requirements

• Technical Skills: Strong proficiency in writing complex SQL independently across relational databases (PostgreSQL, MySQL, Snowflake, or MS SQL Server).
• Tech BA Expertise: Proven experience in technical requirement gathering, API/Data mapping, ER diagrams, and system architecture awareness.
• Process & Tools: Hands-on experience with Agile/Scrum, Jira/Confluence, and process flowcharting tools (Visio/Lucidchart).
• Education: Bachelor's degree in Computer Science, Information Technology, or a quantitative field.