Senior Business Intelligence Analyst (SQL / Power BI)

Job Description

Position: Senior Business Intelligence Analyst (SQL / Power BI)

Location: Bangkok Phra Khanong Hybrid (2 days in the office)

About Avalon Analytics:

Avalon Analytics is a leading SaaS provider in the hospitality industry, offering a cutting edge business intelligence platform specialized in Revenue Management. With a growing presence in the South East Asian market and headquarters in Bangkok, we help hotels unlock their full commercial potential through data-driven insights and real-time analytics.

Role Summary:

We are looking for a Senior Business Intelligence Analyst (SQL / Power BI) to take ownership of complex data investigations, ensure the accuracy and reliability of our analytics platform, and act as a senior escalation point for high-impact business intelligence issues.

This is a hands-on, hybrid role combining advanced SQL analysis, data quality investigation, dashboard validation, and client-facing problem solving. You will work closely with Data Operations, Integrations, and Engineering teams to resolve data discrepancies, improve data workflows, and maintain trust in our analytics outputs.

You will also play a mentoring role within the team, supporting junior analysts and contributing to the continuous improvement of internal processes, monitoring, and documentation.

Key Responsibilities:

- Act as the senior escalation owner for complex business intelligence and data-related issues.

- Investigate data discrepancies, missing records, mapping issues, and platform inconsistencies.

- Analyse and debug SQL logic, data flows, and reporting behaviour.

- Provide clear, structured explanations and solutions to clients and internal stakeholders.

- Work with Microsoft Fabric, SQL Server, and Power BI dashboards to maintain platform reliability.

- Support monitoring, alerting, and issue detection.

- Collaborate with Data Integrations and Engineering to report bugs, share findings, and assist in testing improvements.

- Communicate effectively with hotel clients, Revenue teams, and senior stakeholders.

- Mentor junior Support Analysts and assist with technical guidance.

- Help maintain documentation, SOPs, troubleshooting playbooks, and internal standards.

- Take part in the weekend support rotation (23 days/month, with compensatory days off).

Requirements:

- 3+ years in technical support, data operations, or analytics roles.

- Strong SQL skills (joins, filtering, debugging, reading logic).

- Experience working with dashboards and analytical tools such as Power BI.

- Good understanding of data flows and cloud environments (Azure, Fabric, or similar).

- Comfortable analysing messy data and identifying root causes.

- Excellent communication in English, both written and spoken.

- Strong ownership, structured thinking, and problem-solving.

Preferred Qualifications:

- Experience working in a SaaS or analytics platform environment.

- Familiarity with ticketing or case management systems such as Zendesk.

- Exposure to hospitality systems (PMS, POS data) is a plus.

- Knowledge of Microsoft Fabric, SSMS, or basic scripting (e.g., Python).

Why Join Us

- Be a key senior member in a fast-growing analytics company.

- Hands-on exposure to real-world business intelligence challenges across multiple hotel systems

- Hybrid work environment with flexibility.

- Collaborative, young, international team based in central Bangkok.