Data Modeler

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

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful. When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

Job Title: Data Modeler, Private Wealth Data & Analytics

Location: Singapore

At Sun Life, we cultivate a High-Performance, Caring Culture that empowers our people to achieve outstanding results, embrace continuous growth, and create meaningful impact. We succeed together by fostering an inclusive environment where wellbeing, collaboration, and accountability are equally valued. When you join Sun Life Private Wealth Reporting to the Head of Analytics and Business Enablement, Private Wealth, the Data Modeler, Private Wealth Data & Analytics will be responsible for designing, developing, and maintaining the data models, mappings, and integrated data assets that support the Sun Life Private Wealth data strategy and future growth. As a member of the Data & Analytics team, the Data Modeler plays a key role in establishing trusted, scalable, and reusable data foundations that enable reporting, analytics, AI and business decision-making. The Data Modeler partners closely with Data Analysts, and Technology teams to understand data requirements, define data structures, document business rules, and design scalable data solutions. The role is responsible for maintaining and enhancing analytical data models, onboarding new data sources, developing source-to-target mappings, supporting data integration initiatives, and ensuring data assets are structured, governed, and readily available for analytical consumption.

What you will be doing

• 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

Who you will be working with

This role is highly collaborative and requires close partnership with members of the Data & Analytics, Private Wealth function and regional teams. The successful candidate will work closely with Data Analysts to understand reporting and analytical requirements, as well as Technology and Data Platform teams responsible for implementing and supporting enterprise data solutions. The Data Modeler will collaborate with the data platform team in Asia to ensure data assets are designed, structured, and managed in a consistent and scalable manner.

What we are looking for

• 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

Job Category: Advanced Analytics Posting End Date: 29/09/2026

Shine together At Sun Life, you can be your most brilliant self. Our supportive, flexible, and inclusive work environment is one where you – and your career – can thrive. Whatever your aspirations, collaborative leaders and colleagues are ready to help you learn, grow, and succeed. Make life brighter We’re a global company with a passion for people. Our purpose is to help Clients achieve lifetime financial security and live healthier lives. As a team of 30,000 across 26 countries, our impact is far-reaching, and locally relevant There’s power in numbers. As part of Sun Life’s growing team, you have an impact on people in your community and around the world. Shape the future With an optimistic eye on a brighter future, we drive to innovate. Be part of leading change, push boundaries and try new ways of working. Use data to drive bold actions. Be agile and pivot as we test and learn. At Sun Life, we’re driving transformation, sustainability and innovation for our Clients, employees, partners, and communities. Join us. Together, we can make the future brighter.