Investment Data Product Consultant

MassMutual•Springfield, NY

About The Position

We are seeking a highly motivated and experienced Investment Data Product Consultant who will be responsible for setting the strategy for end-to-end business lineage of our critical data (sub-domain and elements) and will be responsible for business data modelling of one or more data domains while empowering data stewards to drive catalog completeness and review. The senior investment data consultant will report to the Head of Investment Data. The senior investment data consultant will also be responsible for tracking and reporting key metrics for data governance to data consumers and senior management. The ideal candidate will have a good understanding of investment data requirements and understand the language of investment data. The candidate is an expert in working with data tools such as Excel, SQL, and Python and be able to understand logic embedded in ETL tools such as Informatica and stored procedures.   Experience working in businesses with a varied mix of investment types (public, private, and structured) is . The Team You will be a key member of the Investment Data Strategy and Governance team within Investment Management. We ensure that our strategy for sourcing, aggregating, distributing, and governing Investment data adequately meets the broad requirements of the business community and we are accountable for defining, communicating, and driving forward the data strategy for the investment ecosystem. We are currently in the midst of setting up a comprehensive data governance framework for Investment Management identifying data owners and stewards from across Risk Analytics, Investment Operations and Investment Accounting. We are also partnering with Enterprise Technology to design and deliver a new strategic data platform for the IM business with industry standard concepts such as Bronze/ Silver and Gold Zone data layers, Data Mesh setup, and Virtualization layers. We partner with teams across Investment Management, Enterprise Risk Management, Corporate Finance, Enterprise Technology, Corporate PMO, MassMutual affiliates and external third parties. The Impact The Investment Data Product Consultant will have an impact in the following areas: Data Governance Ensure that we have complete end to end lineage for critical data elements and sub domains. You will set the strategy for creation and maintenance of end-to-end data lineage across Investment Operations and Investment Accounting process and own the lineage of several sub data domains Empower data owners and stewards (people identified throughout our portfolio management teams, investment operations and accounting teams) with tools to ensure that our list of critical data meets the needs of the business and lineage is created and validated for newly defined critical data elements. You will identify the need for additional tools or gaps in existing tools and collaborate with partners in ETX (Corporate Technology) to fulfill these needs. Track and drive the quality of our data catalog with complete data descriptions, usage rules and accuracy rules reporting metrics of completeness and accuracy to the data stewards and ensuring that these gaps are filled. Data governance is a key function in a business that evolves constantly and holds information on complex investments. Data Strategy Own the business data model for one or more investment domains and sub domains based on the requirements of the businesses that we support. You will work with business stakeholders from Investment Operations and Accounting to build out the logical business model. Partner with ETX to translate the business logical model into a technical logical and physical model You will contribute to the business data requirements and principles, and partner with Corporate Technology to deliver a next generation data platform for the business. You will apply data management concepts such as raw data zones and data mastering layers for these requirements. You will liaise with Data Owners identified within the business to stay up to date with their requirements and ensure that these are reflected in the business data model. You will play a key role in the future and evolving data needs of a dynamic business bringing best practice experience and knowledge to bear. Communication Manage interactions between operational and technology teams, communicating business needs into technical requirements, and negotiating priorities with tech/data based on business needs. Metrics Establish KPIs and track data governance adoption using tools and reports. Track issues raised and their time to resolution.

Requirements

Bachelor's degree in finance , Economics, Data Science or related degree
8+ years of experience as an Investment Data Product Consultant or similar role
5+ years of proficiency in SQL and data manipulation tools (e.g., Python, R).
5+ years of experience in working with Investment Data and understanding needs across a wide variety of instruments including public and private assets, bank loans etc.
5+ years of experience in financial services, insurance, or related industry.

Nice To Haves

Experience with data governance tools such as Collibra, Alation or Data360
Data Modelling, Data Governance or Data Science training and certification
Experience with Eagle STAR, Eagle Pace and Eagle DataMart will be a plus.
Experience working with IBOR systems such as Aladdin and Simcorp will be a plus
Excellent communication and interpersonal skills, highly collaborative
Ability to manage multiple projects and prioritize tasks effectively.
Experience in project planning
Strong analytical and problem-solving skills
Strong understanding of financial instruments, investment management workflows, and data governance principles.
Experience with data quality tools, data lineage tracking, and metadata management.

Responsibilities

Ensure that we have complete end to end lineage for critical data elements and sub domains.
Set the strategy for creation and maintenance of end-to-end data lineage across Investment Operations and Investment Accounting process and own the lineage of several sub data domains
Empower data owners and stewards (people identified throughout our portfolio management teams, investment operations and accounting teams) with tools to ensure that our list of critical data meets the needs of the business and lineage is created and validated for newly defined critical data elements.
Identify the need for additional tools or gaps in existing tools and collaborate with partners in ETX (Corporate Technology) to fulfill these needs.
Track and drive the quality of our data catalog with complete data descriptions, usage rules and accuracy rules reporting metrics of completeness and accuracy to the data stewards and ensuring that these gaps are filled.
Own the business data model for one or more investment domains and sub domains based on the requirements of the businesses that we support.
Work with business stakeholders from Investment Operations and Accounting to build out the logical business model.
Partner with ETX to translate the business logical model into a technical logical and physical model
Contribute to the business data requirements and principles, and partner with Corporate Technology to deliver a next generation data platform for the business.
Apply data management concepts such as raw data zones and data mastering layers for these requirements.
Liaise with Data Owners identified within the business to stay up to date with their requirements and ensure that these are reflected in the business data model.
Manage interactions between operational and technology teams, communicating business needs into technical requirements, and negotiating priorities with tech/data based on business needs.
Establish KPIs and track data governance adoption using tools and reports.
Track issues raised and their time to resolution.