Manager - Implementation Services - Data Lead - ETL

Company:Mercer

Description:

We are seeking a talented individual to join our Wealth Operations team at Mercer.

This role will be based in GGN. This is a hybrid role that has a requirement of working at least three days a week in the office.

Senior Manager – Implementation Services (Grade E)

What can you expect?

The role of the Data Analyst Team Lead is to deliver any data related activities necessary for the delivery of a project initiative. Common tasks include (but are not limited to):

• responding to data / information requests,
• data analysis on complex superannuation data sets,
• mapping (source to target) external data sets to Mercer’s ecosystem,
• designing and developing scripts (ETL) to migrate data into Mercer’s core systems,
• testing data for data quality and data integrity
• Importing data to / exporting data from production systems,
• Reconciliation & System Integration testing (SIT) of data.
• Leveraging AI tools for enhanced data processing and intelligent automation.

In addition to hands-on participation in delivery activities, the data team take a leadership role within the team. The team lead takes responsibility for a team of data analysts, actively participates in estimation of work, and plays a driving role in defining data governance best practices.

The data team consists of both onshore and offshore specialists. Projects will almost always be delivered by a combination of both. As part of the role, the data analyst contributes to project objectives and takes ownership of data related tasks. The data practice within Program Delivery is responsible for delivering a high and consistent level of quality of data to our stakeholders.

We will count on you to

•            Interact directly with key stakeholders to understand their needs;

•            Take complex business requirements and apply them to complex data landscapes;

•            Work successfully both independently and as a team leader;

•            Develop estimates and manage scope and outcomes against a pre-agreed plan;

•            Practice self-leadership and promote learning in others through mentoring and coaching;

•            Take the initiative when others wait for input; 

•            Be innovative in your thinking and actively participate in developing new best practices;

•            Understand that there is more to client success than a technical solution;

•            Focus on solving business issues, bring value, and drive efficiency in the organization, leveraging AI and automation technologies.

•            Champion AI adoption and automation opportunities across the Wealth Implementations Team.

What you need to have:    

Expectation of at least 5-7 years of experience in data roles

Advanced in the following technique / knowledge areas:

• Data Analysis
  • Plan / design data related tasks
  • Conducting Analysis
  • Meaningfully report findings to (non-technical) stakeholders
• Data Load
  • Data Mapping (Source to Target)
  • Code development of load jobs
  • Load execution
• ETL development best practices,
• Software Development Lifecycle
• Project Management Methodologies
• Identify and escalate risks and issues
• Data Reconciliation & Audit Activities
• Peer review / sign off sessions for data artefacts
• Project Methodologies
  • Waterfall
  • V-Model
  • Agile
• Data management technical skills
  • SQL querying (T-SQL), particularly demonstrated knowledge of:
    • Complex SELECT and JOIN usage;
    • Expressions and Control of Flow techniques;
    • Creation and manipulation of Temporary Tables/CTEs.
  • MS SQL Server DB management, specifically understanding of
    • ODBC connectivity,
    • table indexation,
    • query optimization,
    • etc.
  • Preferably some experience with Data Visualization / BI
  • Advanced MS Excel level usage
  • Basic coding experience (focus on Python, Powershell, Visual Basic and other scripting languages.)

Proficient in the following test technique / knowledge areas:

• Data Migration Strategy
• Data Management on large projects (5+ reports)
• Mentoring other team members in data practices
• Contributing to data practice continuous improvement
• Risk and issue management
• Stakeholder management

Understanding of responsible AI principles and data privacy compliance.

What makes you stand out?

• Adaptable communicator, facilitator, influencer and problem solver
• Good relationship skills, Proven ability to work on own initiative as well as in a team
• Ability to multi-task and prioritize time effectively
• Be highly analytical
• Able to work to tight deadlines and extended hours based on client requirement
• Have a successful track record interacting with business leaders
• Financial services industry experience preferred
• Provides and oversees financial information for the regional functions including firm wide initiatives
• Ability to lead and drive change within a transforming and matrixed organization
• Streamlines and standardizes financial activities and procedures to improve efficiency

Why join our team?

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being. 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 organization
• Great team environment with energetic and supportive colleagues

Mercer is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Mercer, visit mercer.com, or follow us on LinkedIn and X.

Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.