US Wealth Advisory- ETL Developer Client Data Integration-Associate ID-5715

January 3, 2025

About this role

BlackRock Company Description: BlackRock helps investors build better financial futures. As a fiduciary to our clients, we provide the investment and technology solutions they need when planning for their most important goals. As of December 2023, we have been entrusted to manage $10 trillion across equity, fixed income, alternatives, multi-asset, and cash management strategies for our institutional and retail clients. For additional information on BlackRock, please visit www.blackrock.com | Twitter: @blackrock | Blog: www.blackrockblog.com | LinkedIn: www.linkedin.com/company/blackrock.

Other Jobs You May Be Interested In

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.
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.
Troubleshoot 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)
Participate in code reviews and adhere to development best practices.
Stay updated with emerging ETL technologies and methodologies.

Qualifications:

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

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.

US Wealth Advisory- ETL Developer Client Data Integration-Associate ID-5715

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

DISCLAIMER

Other Jobs You May Be Interested In

US Wealth Advisory- ETL Developer Client Data Integration-Associate ID-5715

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

5. HOW DO YOU PROCESS INFORMATION?

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

8. HOW TO PRIORITIZE WORK?

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

Related Posts

Part Time Psychiatric Nurse Practitioner ID-7811

NURSE RN for MEDICAL REVIEWER POSITION ID-7807

RN Call Center Overnight Remote - Compact Nursing States ID-7803

REGISTERED NURSE I ID-7797

Nurse Practitioner (NP) - Vascular Surgery - Full Time - Full Time - 12hr Days ID-7792

Psychiatric Mental Health Nurse Practitioner (PMHNP) Adolescent ID-7788

Contractor – Psychiatric-Mental Health Nurse Practitioner Writer/Reviewer ID-7766

Psychiatric Nurse Practitioner_Contract California 100% REMOTE ID-7765