Master Data Management Analyst - Portfolio Analytics & Reporting

Full Time
La Jolla, San Diego, CA, USA
4 hours ago

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