ETL Developer

About this role

Business Unit Overview:

BlackRock’s US Wealth Advisory business (“USWA”) manages the firm’s relationships with US retail financial services firms and their advisors, who ultimately serve end investors. Representing a full suite of strategies – from iShares ETFs and mutual funds to SMAs, model portfolios, alternatives, portfolio solutions, and sub-advisory programs – USWA’s mandate is to deliver “One BlackRock” to our clients.

USWA COO Team is responsible for leading a range of strategic initiatives and for managing the internal planning for BlackRock’s US retail business. Our group, reporting to the Head of US Retail, forms the “connective tissue” of BlackRock’s US retail business, coordinating functional areas within the business and interactions with the broader BlackRock organization, including business analytics and product.

Job Purpose/Background:

The USWA Client Data Center of Excellence (COE) is responsible for maintaining and enhancing our robust data ecosystem, proactively and reactively addressing data process and quality issues, and serve as a key connection point between USWA and the Client Platform / Global Client Business (GCB) for everything related to client data, data quality, and ETL processes.

Key Responsibilities:

• Design, develop, and maintain ETL processes and workflows across 3rd-party data feeds, CRM data exhaust, and industry data / insights.

• Optimize ETL processes for performance and scalability.

• Maintain and update client data repositories to ensure accuracy and completeness, focusing on timely onboarding, QA, and automation of priority 3rd-party data feeds

• Collaborate with USWA Client Data Management, data scientists, and 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.

• Fix and resolve ETL job failures and data discrepancies.

• Document ETL processes and maintain technical specifications.

• Work with data architects to model data and ingest into data warehouses (e.g., Client Data Platform)

• Engage in code reviews and follow development standard methodologies.

• Stay updated with emerging ETL technologies and methodologies.

Qualifications:

• Bachelors or Master’s Degree in Computer Science, Engineering or a related field.

Eligibility Criteria:

• 4+ years of experience in ETL development and data warehousing.

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

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

• In-depth working knowledge of Python programming language including libraries for data structures, reporting templates etc. Extensive knowledge of writing Python data processing scripts and executing multiple scripts via batch processing.

• Proficiency in programming languages like Python, Java, or Scala.

• Experience with database management systems like SQL Server, Oracle, or MySQL.

• Knowledge of data modeling and data architecture principles.

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