Investments Technology Data Analyst

This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community.

Mercer Global Investments Technology seek a highly skilled Investments Technology Data Analyst to join our team in our Dublin office.

As an Investments Technology Data Analyst, you will work on a high-profile project, extracting data from various systems to analyse that data across various regional existing Mercer systems.

We will look for your technical skills, ideally in writing/programming SQL queries against various database platform such as Snowflake/Databricks and other relational databases.

We particularly welcome applications from those from a software development background who may have moved their career to be more business facing and focused on analysis.

You may have also worked with data team on requirements and translating these requirements, with more technical detail to the teams building a data lake.

What Can You Expect

• To join us at the start of an exciting 3+ year strategic initiative, focused on a Global solution to see how we can centralise data that is consistent across the globe.
• To work on a very high-profile initiative, with visibility of key stakeholders and senior leadership.
• The opportunity to work with a collaborative, focused team of highly skilled individuals.
  
  

What You Need To Have

• Experience in the data domains common in investment management firms (e.g. funds, portfolios, holdings, trades, securities/investments, investment book of records (IBOR), accounting book of records (ABOR), performance, etc.
• Proficiency in SQL and experience with relational databases.
• Experience with cloud-based Data Warehouse/lake platforms, such as AWS data technologies, Databricks, and Snowflake.
• Familiarity with metadata management and data governance tools such as Informatica Axon/EDC.
• Strong analytical and problem-solving skills, with the ability to analyse complex data sets and derive meaningful insights.
  
  

What Makes You Stand Out

• Knowledge of the OCIO business.
• The ability to effectively communicate technical concepts to non-technical stakeholders.
• Broad experience with portfolio and order management systems (e.g. Factset, CRD/State Street Alpha), Investment Data Warehouse solutions (e.g. Eagle), modern cloud-based Data Warehouses/lakes technology, BI tools, investor client reporting systems and client facing systems.
• Knowledge of BI tools (e.g. Qlik) and designing data solutions for ease of use by BI platforms to enable data self-service.
• Experience in projects that involved the use AI.
• Ability to adapt to changing priorities and handle multiple tasks simultaneously.
  
  

We Will Rely On You To

• Lead analysis related to investment technology solutions and software development initiatives within the investment management domain.
• Write the business specifications detailing operations of an application or specific function.
• Consult with development team to ensure requirements are clear and to resolve outstanding questions or issues.
• Lead user group meetings and work with stakeholders to assist in prioritizing the backlog.
• Assist in the development of product roadmaps.
• Work closely in region with business stakeholders to understand how local requirements can map into our broader global solution.
• Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
• Work with peers globally in the transformation program to align on designing global solutions and minimize regional differences to only the case where they are truly required.
• Collaborate with investment teams, vendors, and technology stakeholders to understand end user and integration requirements and develop solutions that meet business needs in an optimal way.
• Prepare training materials and answers user’s questions.
• Design solutions that bring together the solutions our vendor partners provide and what our business requires that may require internal development.
• Ensure compliance with relevant policies, procedures, and regulatory requirements.
• Support implementation and testing teams as required to ensure execution success.
• Assist support teams as required.
• Evaluate vendor platforms to see if solutions exist that can be purchased vs. built and make recommendations.
• Assist in the estimation of features, products, projects and in resource budgeting.
  
  

What You Will Be Rewarded With

Our employees enjoy excellent benefits such as:

• Up to 12% pension contribution
• A hybrid working model that nurtures a collaborative working environment in the office 3 days per week allowing 2 days per week to be spent working on a remote basis.
• 35-hour working week
• Paid annual leave and ability to purchase additional leave days.
• Healthcare cover
• Study Support
• Sports & Social clubs/Wellness Programme.
• Travel ticket/bike to work/dental are optional.
• Subsidised canteen
  
  

#MMCIC

Mercer believes in building brighter futures by redefining the world of work, reshaping retirement and investment outcomes, and unlocking real health and well-being. Mercer’s more than 20,000 employees are based in 43 countries and the firm operates in over 130 countries. Mercer is a business of Marsh McLennan (NYSE: MMC), the world’s leading professional services firm in the areas of risk, strategy and people, with more than 85,000 colleagues and annual revenue of over $23 billion. Through its market-leading businesses including Marsh, Guy Carpenter and Oliver Wyman, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment. For more information, visit mercer.com. Follow Mercer on LinkedIn and X.

Marsh McLennan 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, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting TANA@mmc.com

Marsh McLennan 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 McLennan 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.