Associate, Snowflake Data Engineer - BTO

About this role

Associate Snowflake Data Engineer BlackRock Transformation Office

About BlackRock Transformation Office (BTO)

BlackRock Transformation Office (BTO) is a global group of change professionals that deliver strategic transformation to help make BlackRock greater than the sum of its parts. We drive 1BLK outcomes by continuously connecting and being students of the firms people processes and technology.

We are a versatile team made up of individuals with varied experiences and backgrounds motivated by the challenge of finding solutions which benefit BlackRock and our clients.

In BTO we pride ourselves on developing our people improving leadership and delivery skills and broadening firm and industry knowledge. Projects and roles are assigned not just based on successful delivery but also on individual development objectives and career aspirations.

Job Description

The Snowflake Developer will be responsible for designing developing and maintaining Snowflake environments that support data storage processing and analytics for BlackRocks corporate technology data platforms. This role plays a critical part in building and managing scalable data architectures robust data models and automated data pipelines that enable efficient and reliable integration transformation and delivery of data. The developer will work closely with cross-functional teams to translate business initiatives into technical solutions ensuring data quality integrity and performance across BlackRock systems.

Key Responsibilities

Snowflake Administration & Maintenance

• Manage and maintain Snowflake databases including performance monitoring cost optimization troubleshooting and backups

• Partner with BlackRocks Snowflake infrastructure team to implement best practices coordinate upgrades and integrate enterprise-wide features

• Ensure compliance with data governance security and audit requirements

Data Engineering & Pipelines

• Design and develop automated data pipelines using Fivetran and other ETL tools integrating data from various business systems BlackRock warehouses APIs and external sources

• Implement robust data validation cleaning and transformation processes to ensure data quality accuracy and reliability

• Monitor and tune data pipelines for performance scalability and cost efficiency

Data Modelling & Architecture

• Design and implement logical and physical data models to support BlackRock stakeholders analytical and reporting needs

• Create ER diagrams data flow diagrams and other visualizations to represent data models and workflows

• Develop and enforce data modeling best practices and standards

• Optimize data models for query performance ensuring efficient data retrieval across large datasets

Collaboration & Support

• Partner with BlackRock business and corporate technology teams to translate business requirements into technical solutions

• Train and support end users on Snowflake capabilities data access and reporting tools

• Collaborate with vendors and cross-functional teams to troubleshoot issues deliver enhancements and implement new features

Job Requirements

Education

• Bachelors degree in computer science data science software engineering information systems or related quantitative field (masters degree preferred)

Experience

• Minimum of 3-5 years experience in data engineering including data integration modeling optimization and data quality

• Proven experience designing developing and maintaining data warehouses using Snowflake in a production environment

• Experience working in financial services or private markets (preferred)

Skills

• Strong SQL skills for querying data manipulation and performance optimization

• Proficiency with modern ETL/ELT tools ( e.g. Fivetran dbt ADF)

• Expertise in data modeling concepts (relational dimensional and star schema)

• Proficiency in Python Java or Scala for data engineering tasks

• Knowledge of cloud services (AWS Azure GCP) and data integration within cloud ecosystems

• Strong problem-solving and debugging skills; ability to identify and resolve performance bottlenecks

• Excellent communication skills including the ability to collaborate effectively across technical and business teams

• Familiarity with data governance security and compliance standards

For New York NY Only the salary range for this position is USD$132500.00 - USD$162000.00 . Additionally employees are eligible for an annual discretionary bonus and benefits including healthcare leave benefits and retirement benefits. BlackRock operates a pay-for-performance compensation philosophy and your total compensation may vary based on role location and firm department and individual performance. For PR2-Princeton - 1 University Square Drive Only the salary range for this position is USD$120000.00 - USD$148000.00 . Additionally employees are eligible for an annual discretionary bonus and benefits including healthcare leave benefits and retirement benefits. BlackRock operates a pay-for-performance compensation philosophy and your total compensation may vary based on role location and firm department and individual performance.

Our benefits

To help you stay energized engaged and inspired we offer a wide range of benefits including a strong retirement plan tuition reimbursement comprehensive healthcare support for working parents and Flexible Time Off (FTO) so you can relax recharge and be there for the people you care about.

Our hybrid work model

BlackRocks hybrid work model is designed to enable a culture of collaboration and apprenticeship that enriches the experience of our employees while supporting flexibility for all. Employees are currently required to work at least 4 days in the office per week with the flexibility to work from home 1 day a week. Some business groups may require more time in the office due to their roles and responsibilities. We remain focused on increasing the impactful moments that arise when we work together in person aligned with our commitment to performance and innovation. As a new joiner you can count on this hybrid model to accelerate your learning and onboarding experience here at BlackRock.

About BlackRock

At BlackRock we are all connected by one mission: to help more and more people experience financial well-being. Our clients and the people they serve are saving for retirement paying for their childrens educations buying homes and starting businesses. Their investments also help to strengthen the global economy: support businesses small and large; finance infrastructure projects that connect and power cities; and facilitate innovations that drive progress.

This mission would not be possible without our smartest investment the one we make in our employees. Its why were dedicated to creating an environment where our colleagues feel welcomed valued and supported with networks benefits and development opportunities to help them thrive.

For additional information on BlackRock please visit @blackrock Twitter: @blackrock LinkedIn: is proud to be an equal opportunity workplace. We are committed to equal employment opportunity to all applicants and existing employees and we evaluate qualified applicants without regard to race creed color national origin sex (including pregnancy and gender identity/expression) sexual orientation age ancestry physical or mental disability marital status political affiliation religion citizenship status genetic information veteran status or any other basis protected under applicable federal state or local law. View the and the

BlackRock is committed to full inclusion of all qualified individuals and to providing reasonable accommodations or job modifications for individuals with disabilities. If reasonable accommodation/adjustments are needed throughout the employment process please email . All requests are treated in line with our .

BlackRock will consider for employment qualified applicants with arrest or conviction records in a manner consistent with the requirements of the law including any applicable fair chance law.

Required Experience:

IC