Senior Associate - Data Architect

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:

We are seeking an experienced Senior Data Engineer/Architect to lead the design, implementation, and optimization of our enterprise data warehouse using Snowflake. The Data Architect will be a member of the Analytics Team within Stepstone’s Portfolio Analytics and Reporting (“SPAR”) department. This pivotal role will be responsible for architecting our data infrastructure, developing robust data pipelines, and ensuring the scalability and performance of our data solutions. The ideal candidate will combine strong technical skills with strategic thinking to drive our data initiatives forward.

Essential Job Functions:

• Design and implement the overall data architecture for our Snowflake-based data warehouse, ensuring scalability, performance, and alignment with business objectives.
• Develop and optimize ETL/ELT processes using Snowflake's native capabilities and other data integration tools.
• Create and maintain comprehensive data models, including the design of star schemas, snowflake schemas, or data vault models as appropriate.
• Implement data governance frameworks, including data quality measures, metadata management, and security protocols using Snowflake's role-based access control (RBAC).
• Lead the evaluation and integration of new data sources into the warehouse, considering both technical feasibility and business value.
• Optimize query performance and data storage using Snowflake's features.
• Implement and maintain data security and privacy measures.
• Collaborate with business stakeholders to translate strategic requirements into technical specifications.
• Stay abreast of emerging technologies and industry trends, recommending innovations to enhance our data capabilities.

Education and/or Work Experience Requirements:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field
• 2-4+ years of direct experience with SnowFlake
• Strong proficiency in SQL and Python
• Experience in designing and implementing data warehouses and data lakes, with an understanding of best practices for scalability and performance
• Deep understanding of data modeling techniques, dimensional modeling, master data management principles and data vault methodologies
• Expertise in ETL/ELT processes and tools, including prior experience with dbt
• Strong programming skills in at least one language (e.g., Python, Java) for data manipulation, automation, and pipeline development

Other Knowledge, Skills and Abilities:

• Certifications in Snowflake (e.g., SnowPro Core, Architect) or other relevant data technologies
• Preferred experience with workflow orchestration tools such as Apache Airflow or Airbyte for managing DAGs
• Knowledge of machine learning and AI technologies and their data infrastructure requirements
• Familiarity with DevOps practices and experience setting up CI/CD pipelines for data solutions
• Excellent problem-solving skills with the ability to balance technical constraints with business needs
• Outstanding communication skills, capable of explaining complex technical concepts to non-technical stakeholders

Salary Range - $115,000 - $130,000

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.

About us

Working out of 26 offices in 15 countries, StepStone has a truly global viewpoint. As people are our biggest asset, we offer resources to help our employees reach their full potential. Our principles are based on integrity, transparency, respect and creativity, which together define how we do business.

Join us

When you choose to work at StepStone, you'll find a group of professionals who are passionate about anticipating changes, solving problems and working together to make it all happen. Our integrated global team shares insights into how managers think and operate, as well as how they might perform.

StepStone offers a competitive compensation package including salary and incentive compensation for all full time hires, as well as a comprehensive benefits package.

Benefits

We offer a range of benefits which include comprehensive healthcare, strong retirement plan, a mental health well-being program, paid time off, student loan repayment program for our US office locations, and several wellness initiatives.

Disclaimer / Policy Statements

*At StepStone, diversity, equity and inclusion are an integral part of our culture. We are an Equal Opportunity Employer that strives to create an inclusive environment that empowers our employees and allows them to be heard, regardless of title or tenure. Our organizational community features multiple Employment Resource Groups representing our dedication to Diversity, Equity & Inclusion. *

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

#LI-Hybrid