Analytics Specialist, Distribution

Prudential Hong Kong Limited; Singapore; On-site; SGD 70,000 - 90,000; Full time

Job summary

A leading insurance company in Singapore is seeking a Senior Analyst / Analytics Specialist to build and maintain critical dashboards in Power BI. The role requires advanced SQL skills to extract and manage data, drive analytics solutions, and provide actionable insights for decision-making. The ideal candidate will have over 5 years of experience in analytics and dashboard development. The position promotes a culture of diversity and inclusion and offers opportunities for career growth within the organization.

Qualifications

• 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.
• Experience in insurance, financial services, or distribution analytics is a plus.

Responsibilities

• Design, build, and maintain interactive dashboards in Power BI.
• Write and optimize SQL queries to extract data from the DataHub.
• Provide ad-hoc analysis and actionable insights to support business improvement initiatives.

Skills

Dashboard Development

SQL

Data Validation

Communication

Stakeholder Management

Education

Bachelor’s degree in a quantitative field

Tools

Power BI

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.Prudential plc provides life and health insurance and asset management to 18 million customers across 24 markets in Asia and Africa.We are headquartered in London and Hong Kong and are focused on four strategic regions: Greater China, ASEAN, India and Africa. We are served by around 68,000 average monthly active agents and more than 200 bank partners.Prudential plc is not affiliated in any manner with Prudential Financial, Inc., a company whose principal place of business is in the United States of America or with the Prudential Assurance Company, a subsidiary of M&G plc, a company incorporated in the United Kingdom.Find out more atFollow us on LinkedIn