Master Data Management Analyst - Portfolio Analytics & Reporting at StepStone Group

San Diego, California, United States -

Full Time

Start Date

Immediate

Expiry Date

14 Feb, 26

Salary

76500.0

Posted On

16 Nov, 25

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Analysis, Data Engineering, Master Data Management, SQL, Data Quality, Data Modeling, ETL, Data Integration, Analytical Mindset, Communication Skills, Data Governance, Fuzzy Matching, Python, Financial Data, Automation, Metadata Management

Industry

Financial Services

Description

We are global private markets specialists delivering tailored investment solutions, advisory services, and impactful, data driven insights to the world’s investors. Leveraging the power of our platform and our peerless intelligence across sectors, strategies, and geographies, we help identify the advantages and the answers our clients need to succeed. Position Overview: The Data Analyst will be a member of the Data Engineering team within StepStone’s Portfolio Analytics and Reporting (“SPAR”) department. This person will partner with various internal teams and support efforts to define, enforce, and maintain a unified Master Data Management (MDM) process and strategy within a cloud data warehouse environment. This person will implement data quality checks and support creating unified “golden records” from disparate internal and external data sources. The role sits at the intersection of data engineering, data modeling, and private investment domain knowledge, providing exposure to both technical and business processes. Essential Job Functions: Support MDM initiatives in defining, modelling, and maintaining master data entities. Gather, reconcile, clean, standardize, deduplicate, and merge data from internal systems and external databases to create trusted “golden records.” Build records matching/merging logic and rules for mastering data (deterministic, fuzzy matching, conflict resolution). Collaborate with stakeholders to understand domain definitions, business rules, data lineage, and exceptions. Implement data quality checks, validations, and anomaly detection to ensure accuracy and consistency of master data. Create and maintain documentation, definitions, governance rules, and metadata for master data assets. Assist in establishing governance, stewardship, and versioning processes. Integrate master data processes with broader extract, load and transform (ELT) workflows and Snowflake data models. Contribute to automation of mastering data processes. Support other data initiatives such as data engineering, data modeling, and ad-hoc analysis. Qualifications: Bachelor’s degree in Computer Science, Information Systems, Economics, Finance, or related quantitative or qualitative field. 1–3 years of experience or relevant coursework in data analysis, data engineering, or MDM-related roles. Strong SQL skills for data profiling, transformation, and reconciliation in Snowflake. Understanding of data mastering, data modeling, ETL/ELT processes, and data integration concepts. Interest in private markets or financial data. Analytical mindset with attention to detail and the ability to manage complex, evolving data. Strong communication skills to collaborate with technical teams and business stakeholders. Other Knowledge, Skills and Abilities: Prior experience in MDM, data governance, or data stewardship is a plus. Experience designing matching/merging logic, fuzzy joins, or reconciliation workflows. Knowledge of Snowflake data governance features (Data Quality Monitoring, Data Security, Data Classification). Experience with commercial MDM platforms or governance tools. Familiarity with metadata management, version control, and data catalog tools. Exposure to financial or investment data domains. Familiarity with Python or similar scripting for automation is a plus. Salary Range: $72,000 - $76,500 The salary range is an estimate of pay for this position. Actual pay may vary depending on job-related factors that can include location, education, skill, and experience. The salary range does not include any benefits or other forms of possible compensation that may be available to employees. #LI-Hybrid At StepStone, we believe that our people are our most important asset and crucial to our success. We are an Equal Opportunity Employer that strives to create an environment that empowers our employees and allows them to be heard, regardless of title or tenure. Our organizational community features multiple Employment Resource Groups as well as mentorship programs to enhance the employee experience for all. As an Equal Opportunity Employer, StepStone does not discriminate on the basis of race, creed, color, religion, sex, national origin, citizenship status, age, disability, marital status, sexual orientation, gender identity, gender expression, genetic information or any other characteristic protected by law. Developing People at StepStone

Responsibilities

The Data Analyst will support MDM initiatives by defining, modeling, and maintaining master data entities while collaborating with stakeholders to understand business rules and data lineage. They will implement data quality checks and create unified 'golden records' from various data sources.