Junior Analyst - Client Services

StepStone Group; San Diego (CA); Hybrid; USD 75,768,000 - 82,656,000; Full time

Job summary

StepStone Group is seeking a Junior Analyst to join the Portfolio Analytics and Reporting (SPAR) team, supporting Real Estate operations from Cleveland, OH and La Jolla, CA. This full‑time, 16‑week position offers hands‑on experience with Python, Power BI, and data‑driven reporting while collaborating with General Partners and internal teams.

You will help build scalable data processes, automate workflows, and develop dashboards that translate complex financial data into clear insights for

Qualifications

• Ability to communicate effectively with technical teams and external stakeholders.
• Strong analytical and problem-solving skills.
• Strong proficiency in Python for data analysis, transformation, and automation.
• Advanced experience with Power BI (data modeling, DAX, dashboard development).
• Working knowledge of SQL and Excel.
• Experience working with large, complex, or multi-source datasets.

Responsibilities

• Data Collection, Validation & External Coordination: Collect, process, and validate investment data from General Partners.
• Communicate directly with external stakeholders to resolve discrepancies and ensure data accuracy.
• Develop repeatable workflows for data ingestion, validation, and quality control using Python.
• Analytics & Dashboard Development: Design and maintain interactive dashboards in Power BI for internal and client reporting.
• Translate complex financial data into clear, actionable visualizations.
• Optimize data models and reporting performance using Power BI and DAX.
• Data Processing & Automation: Use Python (pandas, NumPy, etc.) to clean, transform, and analyze large datasets.
• Automate data processing and reporting workflows to improve efficiency and scalability.
• Work with SQL and Excel to manage and manipulate structured datasets.
• Collaboration & Reporting: Partner with internal teams to deliver high-quality, data-driven insights.
• Support the development of standardized reporting frameworks and templates.
• Contribute to improving internal data infrastructure and reporting processes.
• Secondary Responsibilities: Analyze fund and portfolio performance trends across sectors and geographies.
• Support ad hoc data analysis and reporting requests.
• Assist in enhancing internal analytics tools and capabilities.

Skills

Python for data analysis

Power BI

SQL

Excel

Data analysis

Communication

Teamwork

Analytical skills

Problem-solving

Job description

We are global private markets specialistsdelivering tailored investment solutions,advisory services, and impactful, data driveninsights to the world’s investors.Leveraging the power of our platform andour peerless intelligence across sectors,strategies, and geographies, we helpidentify the advantages and the answersour clients need to succeed.

Position Overview

• For college graduates looking to gain exposure to the private markets industry while developing strong technical skills in data analytics and business intelligence, this role offers hands‑on experience working with Python, Power BI, and data‑driven reporting tools.
• Junior Analysts will build expertise in data collection, validation, and analytics, working closely with internal teams and external stakeholders (including General Partners) to support investment monitoring and reporting efforts. The role emphasizes scalable data processes, automation, and dashboard‑driven insights.
• Opportunity to work with and contribute to StepStone’s Portfolio Analytics and Reporting (“SPAR”) team supporting Real Estate operations, with teams located in Cleveland, Ohio and La Jolla, CA.
• This is a full‑time (40 hours per week) opportunity for a 16‑week period, with the possibility to extend or transition into a permanent role.

Primary Responsibilities

Data Collection, Validation & External Coordination

• Collect, process, and validate investment data from General Partners (GPs)
• Communicate directly with external stakeholders to resolve discrepancies and ensure data accuracy and completeness
• Develop repeatable workflows for data ingestion, validation, and quality control using Python

Analytics& DashboardDevelopment

• Design and maintain interactive dashboards in Power BI for internal and client reporting
• Translate complex financial data into clear, actionable visualizations
• Optimize data models and reporting performance using Power BI and DAX

Data Processing & Automation

• Use Python (pandas, NumPy, etc.) to clean, transform, and analyze large datasets
• Automate data processing and reporting workflows to improve efficiency and scalability
• Work with SQL and Excel to manage and manipulate structured datasets

Collaboration & Reporting

• Partner with internal teams to deliver high-quality, data-driven insights
• Support the development of standardized reporting frameworks and templates
• Contribute to improving internal data infrastructure and reporting processes

Secondary Responsibilities

• Analyze fund and portfolio performance trends across sectors and geographies
• Support ad hoc data analysis and reporting requests
• Assist in enhancing internal analytics tools and capabilities

Required Skills & Qualifications

• Ability to communicate effectively with both technical teams and external stakeholders
• Strong analytical and problem‑solving skills
• Strong proficiency in Python for data analysis, transformation, and automation
• Advanced experience with Power BI (data modeling, DAX, dashboard development)
• Working knowledge of SQL and Excel
• Experience working with large, complex, or multi-source datasets
• Strong written and verbal communication skills in English (all interviews will be conducted in English)
• Team‑oriented mindset with a proactive, self‑starter approach and the ability to work independently in a fast‑paced environment

Preferred Qualifications

• Exposure to financial data, private markets, or investment reporting
• Experience building automated reporting workflows or end‑to‑end data pipelines
• Familiarity with data validation, reconciliation, or audit processes

Salary: $27.50 / hour

#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.

Candidates must be at least 18 years old to apply.

Developing People at StepStone