Lead Data Engineer (ETL Architecture) , US Wealth Advisory, Vice President

About this role

Business Unit Overview:

BlackRock's US Wealth Advisory business manages relationships with US retail financial services firms and their advisors, who serve end investors. USWA offers a range of strategies including iShares ETFs, mutual funds, SMAs, model portfolios, alternatives, portfolio solutions, and sub-advisory programs. The goal of USWA is to provide a unified experience to our clients.

The USWA COO Team leads central initiatives and plans for BlackRock's US retail business. We coordinate functional areas and interactions with the broader BlackRock organization.

Job Purpose/Background:

Looking for a proactive individual to lead the team of ETL developers and data quality analysts. They should have practical expertise in designing and implementing flawless ETL processes in the Production Environment.

Crafting, coordinating, and leading all aspects of the entire ETL process, ensuring data is extracted from various sources, transformed into a usable format, and loaded into a data warehouse. The ideal candidate will have an interest in team collaboration and open communication, as well as strong problem-solving skills and independent self-direction. Critical skills include attention to detail and creativity in problem-solving.

Key Responsibilities:

• Lead a data delivery team, showcasing outstanding leadership and team management skills (both People + Technical).

• Design ETL architecture and data flow to build a comprehensive blueprint for the ETL process.

• Optimize ETL processes for performance and scalability.

• Collaborate with business stakeholders to understand data requirements, improve data quality, and reduce time to market when new data feeds are received.

• Partner with the central Aladdin engineering team on platform-level engagements (e.g., Global Client Business Client Data Platform).

• Ensure the seamless flow of data between internal and external systems.

• Troubleshoot and resolve ETL job failures and data discrepancies.

• Coordinate and collaborate with engineers outside the team.

• Document ETL processes and maintain technical specifications.

• Participate in code reviews and strictly adhere to standard methodologies for development.

• Stay updated with emerging ETL technologies and methodologies.

Qualifications:

• Bachelor’s or master’s degree in computer science, engineering, or a related field.

Eligibility Criteria:

• 9+ years of experience in the design and development of ETL processes.

• 4+ years of experience leading a team of ETL developers and managing production data warehouses.

• Proficiency in ETL tools such as Informatica, Talend, or DBT.

• Proficiency in Python / PySpark programming and knowledge of data modeling and data architecture principles.

• Experience with building ETL processes for cloud-based data warehousing solutions (e.g., Snowflake).

• Extensive knowledge of Python programming language, including libraries for data structures, reporting templates, etc.

• Experience in SQL, PL/SQL programming, Stored procedures, UDFs.

• Excellent problem-solving and analytical skills.

• Ability to work in a fast-paced and dynamic environment.

• Strong communication skills and ability to work as part of a team.

• Experience in the asset management or financial services sector is a plus.

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

BlackRock’s 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 children’s 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. It’s why we’re 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: www.linkedin.com/company/blackrock

BlackRock is proud to be an Equal Opportunity Employer.  We evaluate qualified applicants without regard to age, disability, family status, gender identity, race, religion, sex, sexual orientation and other protected attributes at law.