Data Modeler

PwC South East Asia Consulting; Philippines; On-site; PHP 650,000 - 1,200,000; Full time

Job summary

PwC South East Asia Consulting seeks a Data Modeller with asset management expertise to design finance data models and supporting data marts. You will map source systems to target data stores and collaborate with finance SMEs and developers to implement robust data structures for FUM reporting and Revenue Allocation.

The role emphasizes documentation, validation, and continuous improvement within an agile data product delivery team.

Qualifications

• Proven experience as a Data Modeller within the Asset Management industry.
• Strong understanding of finance processes and Funds under Management reporting.
• Expertise in data modelling tools and techniques.
• Experience with source-to-target mapping and data transformation logic.
• Strong analytical and problem-solving skills; detail-oriented.
• Excellent communication and stakeholder management in technical translation.

Responsibilities

• Data Modelling: Design robust data models for finance reporting, focusing on FUM and Revenue Allocation.
• Source-to-Target Mapping: Analyze source systems and define mappings to the data mart.
• Collaboration: Work with finance SMEs and development team to translate requirements into data structures.
• Documentation: Prepare documentation for data models, mappings, and data flows.
• Quality Assurance: Support data validation and reconciliation for accurate reporting.
• Continuous Improvement: Identify opportunities to optimize data models and processes.

Skills

Data Modelling

Finance processes

Asset Management

Stakeholder communication

Analytics

Data warehousing

Agile delivery

Cross-functional collaboration

Education

Bachelor's degree or higher in Finance/CS/IS

Professional certifications in Data Modelling / Asset Management / Finance

Tools

Azure Databricks

Microsoft Azure

Data profiling

ETL/ELT

Job description

Job Description

Line of Service: Advisory

Industry/Sector: Not Applicable

Specialism: Platform Engineering & Architecture

Management Level: Manager

You will be part of a forward-thinking data product delivery team, focused on enabling high-quality finance insights for strategic decision-making. The team works in close partnership with finance and technology stakeholders to deliver scalable and sustainable data solutions for the asset management business.

We are seeking a skilled Data Modeller with a strong background in Asset Management to join our dynamic data product delivery team. The successful candidate will play a pivotal role in the development and implementation of a finance data mart, supporting critical reporting and analytics for Funds under Management (FUM) and Revenue Allocation processes. This is an excellent opportunity for a detail-oriented professional with deep understanding of finance operations, particularly within the asset management sector.

Key Responsibilities

• Data Modelling: Design and develop robust data models to support finance reporting requirements, with a particular focus on Funds under Management and Revenue Allocation use cases.
• Source-to-Target Mapping: Analyse source systems and define clear mappings to the target data mart, ensuring data integrity and consistency across the finance domain.
• Collaboration: Work closely with business stakeholders, finance subject matter experts, and the development team to translate business requirements into effective data structures.
• Documentation: Prepare comprehensive documentation for data models, mapping specifications, and data flows to support development, testing, and ongoing maintenance.
• Quality Assurance: Support data validation and reconciliation activities to ensure accurate reporting and analytics within the finance data mart.
• Continuous Improvement: Identify opportunities for optimisation and enhancement of data models and data processes in alignment with evolving business needs.

Required Skills & Experience

• Proven experience as a Data Modeller within the Asset Management industry, with a strong understanding of finance processes.
• In-depth knowledge of Funds under Management reporting and Revenue Allocation methodologies.
• Demonstrated expertise in data modelling tools and techniques.
• Experience with source-to-target mapping, including data profiling and transformation logic.
• Strong analytical and problem-solving skills, with attention to detail.
• Excellent communication and stakeholder management abilities, particularly in translating business requirements into technical solutions.
• Familiarity with data warehousing concepts and finance data marts.
• Ability to work collaboratively in a cross-functional, agile delivery team.

Desirable Qualifications

• Bachelor’s degree or higher in Finance, Computer Science, Information Systems, or a related field.
• Professional certifications in Data Modelling, Asset Management, or Finance.
• Experience working with cloud-based data platforms and modern data architecture (MS Azure and Databricks).

Education

Degrees/Field of Study required:

Degrees/Field of Study preferred: Bachelor Degree

Certifications

Required Skills

Data Driven Modeling, Data Modeling Techniques, Data Modeling Tools, Microsoft Azure Databricks

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Agile Scalability, Amazon Web Services (AWS), Analytical Thinking, Apache Hadoop, Azure Data Factory, Coaching and Feedback, Communication, Creativity, Data Anonymization, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling, Data Pipeline, Data Quality, Data Transformation {+ 23 more}

Desired Languages

Travel Requirements

Not Specified

Availability for Work Visa Sponsorship

No

Government Clearance Required

Yes

#PwCSEACPH