Integration and Data Quality Assurance Engineer, Associate

About this role

Team Overview

BlackRock SMA Solutions helps clients customize portfolios for unique tax, values-alignment, or investment exposures across direct indexing, fixed income, active equity, and multi-asset. We deliver world-class service to all of our clients, from wealth advisors to family offices to endowments and foundations.

About this Role
This position plays an important role in developing and maintaining our investment technology base and delivering new platform functionalities. You'll be responsible for developing, maintaining, and executing tests for the various back-end and database systems for which SMA Solutions are responsible. You will also be expected to monitor/support our existing automated processes along with the rest of the Data Team.

Key Responsibilities

Work with Product/process engineers to create and maintain high performance, highly available, highly scalable database - this includes but is not limited to:

• Develop, maintain, and execute test cases against changes, or new features, affecting our back-end (integration, database, ETL) systems.
• Collect, document, and report test results to greater team as part of the release approval process.
• Review proposed changes from developers and provide feedback on test plans, dependencies, and release methodology.
• Collaborate with QA SDET (Software Development in Test) engineers to develop and expand our test automation framework to cover back-end testing.

Qualifications

• 3+ years of database development experience supporting application development teams/projects
• Strong SQL and database skills
• Practical experience writing scripts in Python (or other object-oriented programming languages)
• Strong written and verbal communication skills
• Excellent problem solving skills and attention to detail.
• Self-motivated, self-pacing, proactive attitude essential to prevent foreseeable issues/problems

Highly Desirable Skills/Experience

• Related experience in the financial or investment sector is a big plus
• Familiarity with ETL processes/tools, such as Informatica, Clover

For San Francisco, CA and Sausalito, CA Only the salary range for this position is USD$125,000.00 - USD$155,000.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

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,