StepStone Group Inc.-posted about 1 month ago
Full-time • Entry Level
Hybrid • La Jolla, CA
1,001-5,000 employees
Securities, Commodity Contracts, and Other Financial Investments and Related Activities

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.

  • 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.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service