Job Details

ID #15607444
State California
City Sausalito
Job type Permanent
Salary USD TBD TBD
Source BlackRock
Showed 2021-06-19
Date 2021-06-18
Deadline 2021-08-17
Category Software/QA/DBA/etc
Create resume

Associate, Aperio Database QA Engineer

California, Sausalito, 94965 Sausalito USA

Vacancy expired!

Description

About this role

About Aperio

At Aperio (part of BlackRock), our strategies are designed to put our clients' and their clients' interests at the center of our investment advice; to minimize costs and taxes; and to incorporate each client's unique environmental, social, and governance (ESG) preferences. We are a purposefully growing quantitative/index-tracking investment management business specializing in managing customized equity portfolios tax efficiently.

At Aperio, we work hard and move quickly as a well-coordinated, collaborative team whose exceptional people are focused on providing extraordinary client service. If you are looking for an opportunity to grow and contribute in a fun, industry-disruptive, fast-paced environment, Aperio is the place for you.

About this Role

Aperio's unique approach to portfolio management requires development of custom software to ensure efficient and accurate execution of our daily tasks. Therefore, security, accuracy, and reliability are paramount, considering the volume of business that Aperio handles daily. As a Database QA Engineer focusing on data test automation, you will be a part of our highly collaborative systems development team. You will play a key role in ensuring that every release of our software performs as specified by the business owners and fulfils Aperio's high standards in security, accuracy, and reliability.

Key Responsibilities:
  • Participate, alongside the development team, in gathering requirements and processes to be implemented into Aperio's custom software ecosystem
  • Learn from our Data Architect and database development teams about the technical details and technologies used in implementing said requirements and processes
  • Proactively explore for weak and failure points in requirements, user stories, and test cases; imagine ways our data integrity may be compromised
  • Design, automate, and execute test strategies on the data back-end processes, from ingestion to consumption
  • Collaborate with other QA engineers to design, automate, and execute end-to-end tests
  • Maintain existing test infrastructure; overhaul and redesign when required by new features/technologies
  • Groom existing test cases for selection into smoke/regression suites
  • Report, document, and communicate failures discovered through testing with the affected teams
  • Retest and document follow-through with failure resolution
  • Research new technologies to improve our efficiency and to keep up with current software development best practices
  • Drive overall quality process by encouraging discipline in versioning, documentation, and deployment processes
  • Perform other duties as assigned

Qualifications:
  • Five-plus years of software or test software development experience
  • BS in Computer Science, Data Science, Math, or related fields; or equivalent industry experience
  • Strong foundation in RDBMS and SQL
  • Experience with object-oriented programming languages (Python highly desirable)
  • Familiarity with test concepts: white-/black-/grey-box testing, acceptance/regression test, system integration test
  • Experience with good programming or scripting practices and tools: code review, distributed repositories (Mercurial, Git), CI techniques and tools
  • Experience with creating/maintaining test automation infrastructure and framework
  • Excellent interpersonal skills for soliciting relevant information for a project from different teams
  • Endless curiosity and ability to spot failure points
  • Experience with data flow tools and processes: data ingestion, ETL processes and tools (e.g., CloverDX, Microsoft SSIS, etc.)
  • Familiarity with Agile software development process desirable
  • Experience in database security testing desirable
  • Related experience in the financial or investment sector is a big 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.

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 careers.blackrock.com | www.blackrock.com/corporate | Instagram: @blackrock | Twitter: @blackrock | LinkedIn: www.linkedin.com/company/blackrock

BlackRock is proud to be an Equal Opportunity and Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, national origin, religion, sex, sexual orientation, gender identity, disability, protected veteran status, and other statuses protected by law.

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

Vacancy expired!

Subscribe Report job