Performance Improvement Finance (Data Modeler) Manager (Financial Services), Advisory, Singapore

We are the only professional services organization who has a separate business dedicated exclusively to the financial services marketplace. Join Financial Services (FSO) and you will work with multi-disciplinary teams from around the world to deliver a global perspective. Aligned to key industry groups including asset management, banking and capital markets, insurance and private equity, we provide integrated advisory, assurance, tax, and transaction services.

The opportunity

EY’s Performance Improvement Advisory professionals bring a wealth of experience in working with major financial institutions to align their operating model and infrastructure to their business’ strategic objectives. We assemble the right multi-disciplinary teams, use consistent and proven global methodologies and tools, and draw on the full breadth of EY’s global network, to deliver value and trusted advice to the clients. The key service offerings cover finance function transformation, customer and distribution effectiveness, operations, shared services / outsourcing support, performance management, program advisory, enterprise intelligence, risk management and regulatory change.

With the recent introduction of the IFRS 17 accounting standards, EY is looking for individuals who are able to perform as a business analyst to prepare/ review of user requirements, review functional designs to support IFRS 17 project deliverables.

Your key responsibilities

As markets rapidly change and develop, finance functions must demonstrate real added value to their business. As a finance advisor, you’ll use your experience and knowledge to help deliver greater insight – delivering functional efficiencies as well as transforming the role of finance in our clients’ businesses. You’ll be developing innovative, sustainable ways to improve the management of people, processes and systems, working alongside other finance professionals in high-performing teams.

You will be required to perform the following:

• Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
• Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modelling solutions.
• Perform source data analysis, data discovery and data profiling.
• Provide data structures optimized for information entry and retrieval.
• Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures.
• Support development team during design process design and during performance tuning.
• Participate in business & IT planning and in the development & management of project plans.
• Lead design of Logical and Physical Models
• Support ongoing data modelling efforts for Development and Production environments
• Contribute to development of processes and guidelines for Data Modelling

For the IFRS 17 component, you will be required to perform the following:

• Support the definition and consolidation of business requirements for the IFRS 17 implementation and formulate the functional design for solutioning. This will require coordination with IT, actuarial and finance teams.
• Understand the existing insurance data and meta data model and architecture
• Understand the difference between existing and IFRS 17 definitions and mandatory reporting metrics
• Support the assessment of major risks and issues that may potentially occur during the IFRS 17 implementation.
• Support end-to-end system and User Acceptance Testing.
• Provide participation and feedback on the procedures and processes for financial planning and reporting that is required for IFRS17.

Skills and attributes for success

• An understanding of the Financial Services (Banking and Insurance) industry
• An understanding of the Insurance and Reinsurance industry
• Appreciation of the IFRS 17 requirements, economic or market issues and the ability to interpret their impact on clients.
• Strong communications skills and evident working with people and teams from different ethnic backgrounds.
• Leverage technology to continually learn, improve service delivery and maintain our leading edge best practices
• Strong presentation skills and proficiency in the use of PowerPoint, Word and Excel

To qualify for the role you must have

• Minimum 5 years of experience in design and deployment of logical and physical structures preferably Insurance or Banking Risk Area
• Minimum 5 years of Experience with Erwin data modelling tools
• Minimum 5 years of Experience with development and deployments SQL platform
• Experience with large, high volume databases is preferred.
• Experience performing data profiling
• Experience in Data Mart, Dimensional Modelling, Data Warehouse modelling
• Experience in working with SAS tools and packages/products for the IFRS 17 solutions
• Experience and understanding of Insurance based data models (General Ledger, Policy Admin system, etc.) a key plus
• Ability to work well with technical and non-technical groups, and manage multiple tasks at a time
• Strong analytical, problem-solving and communication skills
• In-depth understanding of both Relational and Domain Modelling techniques

Ideally, you’ll also have

• Experience of working within ASEAN
• Strong stakeholder management skills in understanding strategic direction and being able to convert into cohesive change management strategy and plans
• Ability to develop client opportunities and identify market growth opportunities
• Ability to support the business development cycle

What we look for

Highly motivated individuals with excellent problem-solving skills and the ability to prioritize shifting workloads in a rapidly changing industry. An effective communicator, you’ll be a confident team player that collaborates with people from various teams while looking to develop your career in a dynamic organization

What working at EY Offers?

We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. We also offer you:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

About EY

As a global leader in assurance, tax, transaction and advisory services, we’re using the finance products, expertise and systems we’ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people, we’ll make our ambition to be the best employer by 2020 a reality.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Join us in building a better working world.

For further information, and to apply, please visit our website via the “Apply” button below.