Data Automation Specialist

**Data Automation Specialist**

**What can you expect?**

What we offer is a chance to join a company that is not only winning, but transforming in the most exciting way possible. Our CEO, David Bryant, is dedicated to Mercer Australia being a "people first" culture. We pride ourselves on providing outstanding career development, learning opportunities, rewards and benefits, and we are committed to making your journey with us FUN.
- _ Voted #1 HR Consulting Company Globally_
- _ Prestigious Melbourne CBD (Docklands) office _
- _Great Package _
- _Great time to join this global organisation in Growth Phase _

**What is in it for you?**

At Mercer, we recognise that our most important asset is our people. We offer benefits and programs that support career development such as professional development support, exam and study assistance and global rotation opportunities which will support and nurture you with every opportunity to reach your full potential. We also recognise the value of healthy, happy colleagues and promote a culture of care and wellbeing, offering benefits such as flexible working and much more
- Flexible work arrangements
- Discounted insurances
- Incentive Compensation Plan
- Leading training and development program
- Professional environment where your career path really matters and is supported in our global organisation
- Great team environment with energetic and supportive colleagues

**We will count on you to**:
The Data Automation Specialist is part of the reporting team that sit within the broader Global Investment Implementation Services (GIIS) team that supports the Pacific Investment Solutions (IS) business.

The Data Automation Specialist is a key figure in assembling and delivering complex data sets to various stakeholders but primarily supporting the Mercer Super Trust in meeting its regulatory reporting obligations.

This newly created role requires a business SME who will manage the existing data reporting tools but also contribute to the process of transitioning into new systems, as we continually move towards better, more robust solutions. The role will lead to a deep understanding of investment structure, regulatory requirements, and have close working relationships with the Investment Management and Product teams.

Key Responsibilities include:

- Liaise with the Data Solutions Project team on the deployment of new data solutions and their integration into regulatory return data sets
- Work with Business Analysts on scoping, discovery, compilation and review of business requirements
- Work with testers on compiling test plans, assisting with queries and reviewing results
- Liaise with Project Managers in relation to updates, issues and risks
- Document training and procedures relating to existing, new, or changed functionality
- Assist with the provision of training and information sessions related to new or changed functionality
- Be an SME for future data returns/accreditations leveraging existing data capabilities
- Track regulatory deliverable dates and organize workflow accordingly
- Manage and produce reportable datasets from established systems
- Liaise with stakeholders should data require supplemental information or granular categorisation
- Line 1 contact for any audit or data related queries stemming from data sets produced.
- Investigate data anomalies, troubleshoot process errors
- Design and implement data integrity checks to reduce manual risks

**What you need to have**:

- Degree in Finance or a related field
- 2+ years in data related fields and preferably financial services
- A general understanding of financial markets and investment management processes
- Tertiary qualification and/or industry specific qualification
- Good organisational, comprehension and communication skills
- Numerate, diligent & persistent. Expert level of skills in Excel & VBA.
- An ability to manipulate large set of data extractions, into structured meaningful subsets which meet regulatory requirements.

**About us**:
Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people regardless of their sex/gender, marital or parental status, ethnic origin, nationality, age, background, disability, sexual orientation, and gender identity.