ETL Developer - USWA Client Data Quality Engineer, Associate

Job Description

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 (eg, 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 (eg, Client Data Platform) Engage in code reviews and follow development standard methodologies. Stay updated with emerging ETL technologies and methodologies. Qualifications: Bachelors or masters 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 (eg, 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.