Master Data Management Analyst - Portfolio Analytics & Reporting
StepStone Group is a global private markets specialist delivering tailored investment solutions and data-driven insights. The Data Analyst will support Master Data Management initiatives, ensuring data quality and consistency while collaborating with various internal teams.
Responsibilities
- 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
Skills
- 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
- 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
Company Overview
Company H1B Sponsorship