Data Analyst (Power BI & Dashboard Design)

SG Support; Kampung Malaysia Tambahan; On-site; MYR 60,000 - 120,000; Full time

Job summary

SG Support is seeking a Data Analyst (Power BI & Dashboard Design) to design and build dashboards for internal teams and NGO clients. You will turn data from Azure Synapse and INSIGHT's databases into clear Power BI reports and web-portal visuals, guiding the full dashboard lifecycle from question to release.

The role requires hands-on Power BI development, strong data modelling, and the ability to work with stakeholders across the organization.

Qualifications

• Degree in Computer Science, Information Systems, Data Analytics, or a related field.
• At least 2 years of hands-on Power BI development in a business setting.
• Portfolio of dashboards showing design quality is required with the application.
• Strong Power BI Desktop and Service skills: data modelling, Power Query, publishing and refresh.
• Experience delivering dashboards to external clients.
• Exposure to Azure data services (Azure Synapse, Azure SQL, Data Factory or Fabric).

Responsibilities

• Design and build Power BI dashboards and reports with excellent UI/UX: clear layout, intuitive navigation, and the right chart for each question.
• Build client-facing dashboards for NGO and charity clients with external-product polish and clarity.
• Support data visualisation on web portals and embedded Power BI reports.
• Sketch wireframes or prototypes and gain stakeholder agreement before building.
• Develop efficient data models and DAX measures for accurate, fast reports.
• Maintain and improve report themes, templates, and design standards.
• Work with internal teams and clients to translate needs into dashboard requirements.
• Propose solutions, demo finished reports, and gather feedback for adoption.
• Validate dashboard figures against Azure Synapse and Azure SQL before release.
• Investigate and report data discrepancies with the back-end team.

Skills

Power BI

DAX

SQL

RLS security

UI/UX design

Data modeling

Azure Synapse

Power BI Service

Stakeholder comms

Documentation

Education

Degree in CS/Analytics

Tools

Power BI Desktop

Power BI Service

Azure SQL

Azure Synapse

Tabular Editor

DAX Studio

ALM Toolkit

Job description

The Data Analyst (Power BI & Dashboard Design) designs and builds dashboards that people actually want to use, for internal business teams and for our NGO and charity clients. The role turns data from our Azure Synapse data warehouse and INSIGHT's proprietary Azure SQL databases into clear, well-designed Power BI reports and web-portal visualisations, working directly with stakeholders from first conversation to final release.

The role owns the full dashboard lifecycle: understanding the business question, shaping the data model, designing the layout and user journey, validating the numbers, securing access with row-level security, documenting the work, and supporting users after launch.

Key Responsibilities

The Data Analyst will be responsible to:

• Design and build Power BI dashboards and reports with excellent UI and UX: clear layout, consistent visual style, intuitive navigation, and the right chart for each question.
• Build client-facing dashboards for NGO and charity clients, with the polish and clarity expected of an external product.
• Support data visualisation on web portals, such as embedded Power BI reports or charts delivered with the web team.
• Sketch wireframes or mock-ups (e.g. in PowerPoint or as a Power BI prototype) and agree them with stakeholders before building.
• Develop efficient data models (star schema, relationships) and DAX measures that keep reports accurate and fast.
• Build interactive features such as drill-through, bookmarks, tooltips and field parameters.
• Maintain and improve the INSIGHT report theme, templates and design standards so all dashboards look and feel consistent.
• Work directly with internal business teams and external clients to understand their needs and translate them into dashboard requirements.
• Independently propose and present solutions, and demo finished reports to users and clients.
• Gather feedback after release and iterate to improve adoption.
• Validate dashboard figures against Azure Synapse and INSIGHT's Azure SQL databases before release.
• Investigate and report data discrepancies, working with the back-end team to resolve them.

Security & access

• Design and implement row-level security (static and dynamic RLS) so each internal team and each client sees only their own data.
• Test RLS roles before every release and manage access in line with the INSIGHT dashboard access process.

Documentation, operations & support

• Document every report as part of delivery, not after: business purpose, data sources, data model, key DAX measures, RLS roles, refresh schedule and owner.
• Keep documentation current whenever a report changes, so any team member can support it or take it over.
• Publish and manage reports in Power BI Service: workspaces, apps, scheduled refreshes and permissions.
• Keep up to date with new Power BI features and data visualisation best practice, and share them with the team.

Key Requirements

• Degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or a related field.
• Microsoft PL-300 (Power BI Data Analyst) certification is an advantage.
• At least 2 years of hands-on Power BI development in a business setting.
• A portfolio of dashboards (screenshots or sample .pbix with dummy or anonymised data) that shows design quality is required with the application.
• Strong Power BI Desktop and Power BI Service skills: data modelling, Power Query, publishing and refresh.
• Solid knowledge of row-level security, including dynamic RLS for multi-team and multi-client reports (key requirement).
• A clear eye for UI/UX: layout, colour, typography, visual hierarchy and accessibility.
• Sound understanding of data visualisation principles: choosing the right chart and avoiding clutter.
• Working SQL skills to query and check data in a data warehouse (Azure Synapse, Azure SQL).
• Discipline in documentation: writes clear, up-to-date notes on reports, measures, data sources and security roles.
• Strong attention to detail when validating numbers.
• Good written and spoken English; confident speaking with business users and external clients.
• Experience with Azure data services: Azure Synapse Analytics, Azure SQL, Data Factory or Microsoft Fabric.
• Experience delivering dashboards to external clients.
• Exposure to AI features in BI tools (Claude Code, Copilot in Power BI, Q&A, smart narratives).
• Tabular Editor, DAX Studio or ALM Toolkit for model performance tuning.
• A self-starter who takes ownership of a dashboard from start to finish.
• Curious and keen to learn new tools and trends.
• Able to work independently and as part of a small team.