Database QA Engineer

Process Engineering · Sausalito, California
Department Process Engineering
Employment Type Full Time
Minimum Experience Experienced

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

Thank You

Your application was submitted successfully.

  • Location
    Sausalito, California
  • Department
    Process Engineering
  • Employment Type
    Full Time
  • Minimum Experience
    Experienced