Company:
Mercer
Description:
The Mercer Global Investments Business is embarking on an exciting 3+ year strategic initiative to move our investment’s business to a Global Target Operating Model (TOM) and implement a set of vended and internally built solutions to enable our business to grow rapidly. The initiative touches on client, portfolio management, operations, compliance, and data solutions and has a global focus.
Mercer Global Investments Technology is seeking a highly skilled and experienced Investments Data Analyst to join our Global Investments Technology team at Mercer in the Boston office.
Investments Technology Data Analyst
What can you expect?
- The ideal candidate will have a strong background in investment management, technology, data, and data management, and with supporting large technology implementation projects.
- This role will primarily focus on analysis of data and data related requirements in support of the implementation of our large technology programs.
What is in it for you?
- Work with a seasoned, collaborative and team focused group of highly skilled individuals.
- Work in an inclusive, collaborative, and innovative culture that embraces diversity
- Exposure to key stakeholders and senior leadership and the opportunity to make strong business connections
- A flexible, hybrid work schedule, including remote working opportunities, with competitive compensation including bonus eligibility and vacation days commensurate with experience level
- We are excited to offer the following benefits to all our colleagues: Health and welfare benefits - Tuition assistance - 401K and other retirement savings programs - Employee assistance programs – physical, mental and financial
We will count on you to::
- Perform data analysis related activities in support of our transformation initiatives and technology programs.
- Work closely in region with business stakeholders and the data management team 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 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 and technology stakeholders to understand data requirements and develop data solutions that meet business needs.
- Assist in the design of data models and structures to support investment data analysis and reporting.
- Develop and maintain SQL queries and scripts to extract, transform, and load data from various sources into the data warehouse/lake platforms.
- Utilize cloud-based data technologies, such as AWS data technologies (e.g. Athena), Databricks, and Snowflake, to optimize data storage, processing, and analysis.
- Ensure data quality and integrity by assisting in the implementation of data validation and cleansing processes.
- Collaborate with data governance teams to establish and enforce data management policies and standards.
- Assist in the development and implementation of metadata management strategies and tools. (e.g. Informatica Axon/EDC)
- Support the development of our testing strategy around data and its execution.
- Stay up-to-date with industry trends and advancements in investment technology, data management, data governance, and the use of data in AI.
What you need to have:
- Bachelor's degree in a relevant field, such as Computer Science, Finance, or Data Analytics.
- Strong knowledge and experience in investment management domain, including investment products, asset classes, and investment strategies. Knowledge of the OCIO business is a strong plus.
- 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 analyze complex data sets and derive meaningful insights.
- Excellent communication and collaboration skills, with the ability to effectively communicate technical concepts to non-technical stakeholders.
- Experience working in global projects that span across regions.
- Strong attention to detail and ability to work in a fast-paced, deadline-driven environment.
- Professional certifications in relevant areas (e.g., CFA) are a plus.
- 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 a strong plus.
- Knowledge of BI tools (e.g. Qlik) a strong plus and designing data solutions for ease of use by BI platforms to enable data self service is a strong plus.
- Experience in projects that involved the use AI is plus.
- Ability to adapt to changing priorities and handle multiple tasks simultaneously.
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.
