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 take primary ownership of a flagship client-facing pipeline that delivers daily data files: monitoring automated processes, validating outputs, troubleshooting issues, and implementing ongoing improvements. In addition, this person will build and maintain reliable, scalable data pipelines using Snowflake, dbt, Airflow, and Airbyte, helping to advance and optimize our modern data platform that supports downstream analytics and client reporting. This role is ideal for someone who enjoys combining analytical thinking with hands-on data engineering, learning from senior engineers and architects while owning critical operational responsibilities that directly impact our clients and business teams.
Essential Job Functions:
- Own daily client-facing pipeline operations: Monitor, validate, and ensure timely and accurate file deliveries to clients via automated Airflow jobs.
- Troubleshoot and resolve data or delivery issues, coordinating with internal and client stakeholders as needed.
- Build and maintain monitoring, alerting, and validation checks to meet SLAs, data quality standards and enhance pipeline reliability.
- Support development and maintenance of end-to-end ELT processes using Airbyte, dbt, Airflow, and Snowflake, with final data output following star-schemas and snowflake-schemas.
- Implement data validation and reconciliation logic to ensure completeness and integrity across systems.
- Contribute to automation and DevOps practices (CI/CD, code reviews, documentation, and runbooks).
- Support other data initiatives such as master data management, data modeling, and ad-hoc analysis.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or a related quantitative field.
- 1-3 years of experience in data analysis or a junior data engineering role.
- Strong SQL skills; Experience working with Snowflake is preferred.
- Scripting ability (Python or similar) for automation and troubleshooting.
- Familiarity with modern data tools (Snowflake, dbt, Airflow, Airbyte) or a strong willingness to learn.
- Ownership mindset, strong sense of responsibility, and attention to detail.
- Solid communication skills; comfortable liaising with technical and non-technical stakeholders.
- Ability to triage and solve problems under pressure.
Other Knowledge, Skills and Abilities:
- Experience operating production pipelines (monitoring, SLAs, incident management).
- Knowledge of version control (Git), CI/CD, or infrastructure as code.
- Exposure to cloud platforms (AWS, GCP, Azure).
- Experience with data testing frameworks (e.g. dbt tests, validation frameworks)
- Familiarity with finance, private markets, or investment data domains.
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.
Candidates must be at least 18 years old to apply.
Developing People at StepStone
Top Skills
What We Do
StepStone Group (Nasdaq: STEP) is a global private markets investment firm focused on providing customized investment solutions and advisory and data services to our clients. StepStone’s clients include some of the world’s largest public and private defined benefit and defined contribution pension funds, sovereign wealth funds and insurance companies, as well as prominent endowments, foundations, family offices and private wealth clients, which include high-net-worth and mass affluent individuals.StepStone partners with its clients to develop and build private markets portfolios designed to meet their specific objectives across the private equity, infrastructure, private debt and real estate asset classes.
