Analyst - High Value Data Team

StepStone GroupLa Jolla, CA
11d$77,000 - $81,000Hybrid

About The Position

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 High Value Data Team (“HVD”) team within SPAR Data Management 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 with a focus on private market investments. This person will implement data quality checks and support creating unified “golden records” from disparate internal and external data sources and compare in system data to original General Partner provided reporting. The role sits at the intersection of data engineering, data modeling, and private investment domain knowledge, providing exposure to both technical and business processes and operational processing. Opportunity to work with and contribute to the Global Data and Risk Operations (“DARO”) operations team including the US, European and Asia offices supporting our 24-hour global operations model.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Economics, Finance, or related quantitative or qualitative field.
  • Hands on experience with public or private markets data systems / data sets.
  • Awareness of private markets and experience working within private markets industry.
  • Ability to work in teams including excellent communication skills, time management, and ability to work with internal clients to develop process for constant improvement.
  • 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 potentially 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.

Nice To Haves

  • Prior experience in MDM, data governance, or data stewardship is a plus
  • Significant experience with Microsoft Excel including experience designing matching/merging logic, fuzzy joins, or reconciliation workflows.
  • Experience with python and programming a bonus
  • 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.

Responsibilities

  • Support MDM initiatives in defining, modelling, and maintaining master data entities.
  • Contributes to the overall success of SPAR private markets data universe for Asset Level / Portfolio Companies
  • Gather, reconcile, clean, standardize, deduplicate, and merge asset 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.
  • Work with operational leadership to develop and improve a system of controls and periodic updates to ensure proprietary data systems remain current and accurate.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service