About this role

Team Overview

Black Rock 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. Black Rock 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

Black Rock’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 Black Rock.

About Black Rock

At Black Rock, 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 Black Rock, please visit @blackrock | Twitter: @blackrock | LinkedIn: www.linkedin.com/company/blackrock

Black Rock is proud to be an equal opportunity workplace. We are committed to equal employment opportunity to all applicants and existing employees, and we evaluate qualified applicants without regard to race, creed, color, national origin, sex (including pregnancy and gender identity/expression), sexual orientation, age, ancestry, physical or mental disability, marital status, political affiliation, religion, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. View the EEOC’s Know Your Rights poster and its supplement and the pay transparency statement.

Black Rock is committed to full inclusion of all qualified individuals and to providing reasonable accommodations or job modifications for individuals with disabilities. If reasonable accommodation/adjustments are needed throughout the employment process, please email Disability.

Assistance@blackrock.com. All requests are treated in line with our privacy policy.

We recruit, hire, train, promote, pay, and administer all personnel actions without regard to race, color, religion, sex (including pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), sex stereotyping (including assumptions about a person’s appearance or behavior, gender roles, gender expression, or gender identity), gender, gender identity, gender expression, national origin, age, mental or physical disability, ancestry, medical condition, marital status, military or veteran status, citizenship status, sexual orientation, genetic information, or any other status protected by applicable law. We interpret these protected statuses broadly to include both the actual status and also any perceptions and assumptions made regarding these statuses.

Black Rock will consider for employment qualified applicants with arrest or conviction records in a manner consistent with the requirements of the law, including any applicable fair chance law.