Master Data Management Analyst - Portfolio Analytics & Reporting
La Jolla, CA
Full-time
Hybrid
$72K/yr - $76K/yr
Entry Level
StepStone Group is a global private markets specialist delivering tailored investment solutions and data-driven insights. The Data Analyst will support Master Data Management processes and collaborate with internal teams to ensure data quality and governance within a cloud data warehouse environment.
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.
Qualification
Required
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.
Preferred
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.
Benefits
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.
StepStone Group provides investors with customized portfolios that integrate primaries, secondaries, and co-investments.
