Analytics Specialist, Distribution

prudential; Singapore; On-site; SGD 120,000 - 160,000; Full time

Job summary

Prudential is seeking a Senior Analyst / Analytics Specialist for Distribution to build and maintain dashboards, develop semantic models in Power BI, and extract/validate data from the DataHub using SQL. You’ll enable data-driven decision-making, uplift analytics capability, and reduce manual reporting for the Distribution team.

This hands-on role requires solving business problems with data and visualization, and involves partnering with Distribution leaders to translate requirements into

Qualifications

• Bachelor's degree in a quantitative field such as Statistics, CS, or Business Analytics.
• 5+ years of hands-on experience building dashboards and semantic models in Power BI.
• Advanced SQL skills with experience querying large datasets (Databricks or similar).
• Strong data validation and reconciliation capabilities.
• Experience collaborating with business stakeholders to translate requirements into analytics solutions.
• Excellent problem-solving, communication, and stakeholder management skills.
• Experience in insurance, financial services, or distribution analytics is a plus.

Responsibilities

• Design, build, and maintain Power BI dashboards for distribution performance and incentives.
• Develop semantic models to ensure data consistency and usability.
• Write and optimize SQL queries to extract data from the DataHub.
• Perform UAT and data validation across sources.
• Provide ad-hoc analyses and actionable insights for commercial planning.
• Share best practices and train team on Power BI and data access.

Skills

Power BI

SQL

Stakeholder management

Data analysis

Problem solving

Education

Bachelor's degree in Statistics/CS/BA/Engineering

Tools

Databricks

Job description

Prudential's purpose is to be partners for every life and protectors for every future. Our purpose encourages everything we do by creating a culture in which diversity is celebrated and inclusion assured, for our people, customers, and partners. We provide a platform for our people to do their best work and make an impact to the business, and we support our people's career ambitions. We pledge to make Prudential a place where you can Connect, Grow, and Succeed.

Role Overview

As the Senior Analyst / Analytics Specialist for Distribution, you will be responsible for building and maintaining business-critical dashboards, developing semantic models in Power BI, and independently extracting and validating data from the DataHub using SQL. You will play a key role in enabling data-driven decision-making within the Distribution team, uplifting analytics capability, and reducing reliance on manual reporting. This is a hands-on role for someone who enjoys solving business problems with data and visualization.

Key Responsibilities

Dashboard Development

Design, build, and maintain interactive dashboards in Power BI to support Distribution performance management, sales tracking, incentives, and compensation analysis.

Develop the underlying semantic models in Power BI to ensure data consistency, accuracy, and ease of use for business users.

Continuously improve dashboard usability and adoption across the Distribution team.

Data Extraction & Management

Write and optimize SQL queries to extract data directly from the DataHub and other relevant sources.

Validate and reconcile data from multiple sources to ensure accuracy and reliability.

Perform UAT on dashboards designed by the central analytics team.

Identify opportunities to automate data extraction and validation processes.

Business Analytics & Insights

Partner with Distribution leaders to understand business needs and translate them into analytics solutions.

Provide ad-hoc analysis and actionable insights to support commercial planning, channel performance, and business improvement initiatives.

Proactively identify data, reporting, or process issues and independently develop solutions to address them.

Capability Building

Share best practices and provide training to uplift Power BI and data extraction skills within the Distribution team.

Act as a subject matter expert for dashboarding and data access.

Qualifications & Experience

Bachelor's degree in a quantitative field (e.g., Statistics, Computer Science, Business Analytics, Engineering, or related).

5+ years of hands-on experience building dashboards and semantic models in Power BI.

Advanced SQL skills with proven experience extracting and manipulating data from large databases (Databricks or similar).

Strong data validation, reconciliation, and documentation skills.

Experience working with business stakeholders to translate requirements into analytics solutions.

Excellent problem-solving, communication, and stakeholder management skills.

Experience in insurance, financial services, or distribution analytics is a plus.

Prudential is an equal opportunity employer. We provide equality of opportunity of benefits for all who apply and who perform work for our organisation irrespective of sex, race, age, ethnic origin, educational, social and cultural background, marital status, pregnancy and maternity, religion or belief, disability or part-time / fixed-term work, or any other status protected by applicable law. We encourage the same standards from our recruitment and third‑party suppliers taking into account the context of grade, job and location. We also allow for reasonable adjustments to support people with individual physical or mental health requirements.