Analytics Specialist, Distribution

Prudential Assurance Company Singapore; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Prudential Assurance Company Singapore 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 will enable data-driven decision-making within the Distribution team, uplift analytics capabilities, and reduce manual reporting.

This hands-on role requires partnering with Distribution leaders, delivering ad-hoc analyses, and training the team on BI best

Qualifications

• Bachelor’s degree in a quantitative field (Statistics, CS, Analytics, Engineering)
• 5+ years of hands-on experience building dashboards and semantic models in Power BI
• Advanced SQL skills with data extraction from large databases (Databricks or similar)
• Strong data validation, reconciliation, and documentation skills
• Experience translating requirements into analytics solutions with business stakeholders
• Insurance/financial services analytics experience is a plus

Responsibilities

• Design, build, and maintain Power BI dashboards for Distribution performance and incentives
• Develop semantic models in Power BI to ensure data consistency and usability
• Write and optimize SQL queries to extract data from the DataHub and other sources
• Validate and reconcile data from multiple sources and perform UAT on dashboards
• Collaborate with Distribution leaders to translate business needs into analytics solutions
• Share best practices and train the team on BI and data access

Skills

Power BI

SQL

Data modelling

Education

Bachelor's degree in a quantitative field

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.