Wealth Data Modeler: Analytics & Insights

Sun Life Financial; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Sun Life Financial in Singapore seeks a Data Modeler for Private Wealth Data & Analytics to design, maintain and govern data models and mappings supporting reporting, analytics and AI initiatives.

You will collaborate with Analysts and Tech teams to onboard data sources, develop source-to-target mappings and ensure scalable, trusted data assets for enterprise decision-making.

5+ years of experience and strong SQL, Python, and visualization skills are required.

Qualifications

• 5+ years of experience in data modeling, data management, data integration or related disciplines.
• Experience designing, building and maintaining conceptual, logical, and physical data models.
• Strong understanding of relational and dimensional data modeling techniques.
• Advanced SQL skills with the ability to profile, analyze, validate and transform complex data sets.
• Experience with Python, data modeling tools, and visualization tools such as Tableau or Power BI is considered an asset.
• Experience working with enterprise data platforms, data warehouses, and large-scale datasets.
• Experience with cloud-based data platforms (e.g. AWS) and modern data architectures.
• Ability to translate business and analytical requirements into scalable and reusable data structures.
• Strong analytical, problem-solving, and documentation skills with attention to data quality and accuracy.
• Strong verbal and written communication skills.

Responsibilities

• Partner with Data Analysts to understand business requirements, reporting needs, data definitions, and analytical use cases.
• Design and maintain analytical data models that support reporting, analytics, and business decision-making.
• Develop and maintain source-to-target mappings, transformation logic, business rules, and data dictionaries.
• Analyze and profile new and existing data sources to understand data structures, relationships, quality and integration requirement.
• Translate analytical and reporting requirements into scalable and reusable data assets.
• Collaborate with Data Platform and Technology teams to implement new data sources, analytical data models and integrated data solutions.
• Create tables for analytics and reporting purposes.
• Contribute to the design of data ingestion, transformation and data delivery processes across multiple data sources.
• Support data quality, metadata, lineage and governance activities.
• Identify opportunities to improve data structures, simplify integrations and enhance the usability of enterprise data assets.
• Develop expertise in key data domains, source systems and enterprise data repositories.

Skills

Data modeling

Data management

Data integration

Relational data modeling

Dimensional data modeling

SQL

Python

Tableau

Power BI

Data warehousing

AWS

Cloud platforms

Analytical thinking

Documentation

Communication

Job description

Sun Life Financial in Singapore seeks a Data Modeler for Private Wealth Data & Analytics to design, maintain and govern data models and mappings supporting reporting, analytics and AI initiatives.

You will collaborate with Analysts and Tech teams to onboard data sources, develop source-to-target mappings and ensure scalable, trusted data assets for enterprise decision-making.

5+ years of experience and strong SQL, Python, and visualization skills are required.