Senior QA Automation Engineer, Data

Posted 7 Days Ago
Be an Early Applicant
San Francisco, CA
170K-225K Annually
5-7 Years Experience
Fintech • Professional Services • Software
Altruist helps people have a better experience with their money by empowering financial advisors to do their best work.
The Role
The Senior QA Automation Engineer will create test scripts and plans, analyze raw data, conduct data testing, validate transformations, and ensure data integrity while collaborating with development teams to improve quality and automate processes.
Summary Generated by Built In

About Altruist

Altruist is the modern custodian built exclusively for independent financial advisors that combines a self-clearing brokerage firm with intuitive software for account opening, trading, reporting, and billing — all in one streamlined solution. Financial advisors across the U.S. have partnered with Altruist to reduce costs, save time, grow their business, and provide better outcomes for their clients. Our mission is to make financial advice better, more affordable, and accessible to everyone — but we can’t do it alone. We’re seeking exceptional talent to join our team. That’s where you come in! 

If you’re passionate about challenging the status quo and making a meaningful impact in the financial advice industry, we’d love to meet you!

But first, our values

Kindness - Kindness doesn’t just equal niceness. We listen to understand. We embrace, and encourage healthy debate and diverse perspectives. We approach conflict openly, honestly, and respectfully.
Brilliance - Humility is the skill we’re most proud of and possessing a growth mindset is always top of mind. We take ownership in everything we touch; regularly using our unique superpowers to reach a common goal as a team. We succeed and fail as one.
Grit - When challenges arise, we stay laser focused on achieving our mission and finding a way forward, even when it’s hard. We are nimble and maintain a sense of urgency, swiftly adapting to change and overcoming obstacles.

The Opportunity:

Altruist is in the midst of an exceptional growth phase and we’re excited to hire a Sr. QA Engineer to join our growing Data team.

Your impact:

  • Create test scripts and test plans to enable streamlined data testing practice
  • Analyze and organize raw data
  • Conducting detailed source-to-destination data testing; identifying issues with data integrity, data accuracy, and transformation logic
  • Validate transformation hierarchy and cleanup rules
  • Test data and solutions against business requirements to assure alignment between businesses needs, the written requirements and the solution delivered.
  • Proactively assess risks and help to find issues as early as possible
  • Create new and maintain existing documentation for testing the team’s solutions
  • Designing, developing, and improving automated code/data testing & reporting systems
  • Proactively suggest, plan, and integrate new tools and methods to improve what can be tested and what automations can be performed
  • Skills in ensuring that data transformations and aggregations maintain consistency across systems and time periods
  • Techniques for testing data completeness, including identifying null or missing values across pipelines
  • Testing upstream and downstream dependencies to ensure that data transformations are correctly propagated across services
  • Validating data lineage to ensure data's journey through the pipeline is traceable and correct
  • Identify and communicate when QA processes are not being adhered to or when insufficient data quality conditions exist in a project or process.
  • Display a ‘test to break’ attitude, and a drive toward 100% data accuracy.
  • Possess a strong desire for quality and attention to detail.
  • Partnering closely with the product owner development teams to understand requirements and appropriate use cases
  • Reporting defects to project teams as they are identified
  • Manage multiple project tasks simultaneously

What you bring

  • 6+ years of industry experience in data engineering and Quality Assurance.
  • Ability to identify/triage/isolate bugs in software systems
  • Hands-on experience working with automation for regression
  • Extensive experience using SQL to perform queries/analysis on database systems 
  • Preferred: Experience designing & implementing automated testing systems
  • Experience working in an Agile project team setting
  • Excellent oral and written communication skills
  • Experience with Snowflake preferred
  • Experience in writing test cases to validate data quality
  • Experience in financial services a plus
  • Preferred: Knowledge in AWS (S3, Airflow), Gitlab
  • Familiarity/Experience in database testing tools like DBT or Great Expectations
  • Ability to perform integration testing of data pipelines and the services that consume them

San Francisco, CA salary range

$170,000$225,000 USD

What we bring

Attracting and retaining top-tier talent is a priority. We are proud of the culture we’ve built and are cognizant of the ever-changing professional landscape. Our dynamic offering of perks and benefits are tailored for you to feel your best while doing your best.

  • A hybrid work schedule to promote strong, in-person collaboration and a healthy work-life-balance.
  • Stunning, amenity-filled office spaces in Culver City, CA and Dallas, TX. Our offices are intentionally designed for comfort, collaboration, and productivity. Employees get to enjoy free parking and EV charging, cold-brew and kombucha on tap, a fully stocked pantry with snacks, etc.
  • Competitive salary and equity packages
  • Premium healthcare, dental, and vision insurance plans
  • 401k savings plan with matching contributions and immediate vesting
  • Flexible PTO so you can satisfy your passions outside of work
  • Generous paid parental leave
  • Professional growth and development opportunities including an employee mobility program and an annual L&D budget allocation for each employee
  • Physical and emotional wellness programs that nurture both your mind and body
  • Company perks program (includes discounts on pet insurance, fitness, cell phone plans, entertainment and travel, etc.)
  • Financial guidance program (includes counseling on navigating debt, tracking personal spend, saving and planning goals, home-purchasing preparedness, etc.)

Total compensation includes a competitive benefits package along with equity in the form of Stock Options (ISOs). A salary offer will be determined by a number of factors including experience, skill level, internal pay equity, geographic location, and other relevant business considerations. We review all employee pay and compensation programs regularly to ensure fair, equitable, and competitive pay. At Altruist, we are committed to providing fair, equitable, and competitive compensation by leveraging market data to inform our pay bands. Base salaries will be reviewed at regular intervals throughout the year, typically in conjunction with performance review cycles. By evaluating compensation on a regular basis, we are able to reward high performance and ensure all employees have opportunities for growth.

Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Altruist we are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role, but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Top Skills

Python
SQL
The Company
HQ: Culver City, CA
250 Employees
Remote Workplace
Year Founded: 2018

What We Do

Altruist is on a mission to make independent financial advice better, more affordable, and accessible. We’ve built an all-in-one platform that reduces barriers for financial advisors to deliver great advice. Our software makes advisors more efficient and gives them the freedom to charge less. This means clients pay less, make more, and gain confidence. We want to help tens of millions of people have an amazing experience with their money by supporting thousands of financial professionals.

Why Work With Us

We're helping more people get access to quality financial advice. This means lower costs, no minimums, and full transparency. Our team is passionate about our mission and we love working together. Altruist provides all the usual perks of a tech startup, just no ego or politics. We believe in hiring brilliant, hard-working, nice people (no jerks).

Gallery

Gallery

Jobs at Similar Companies

bet365 Logo bet365

Junior Sports Analyst

Digital Media • Gaming • Software • eSports • Automation
Denver, CO, USA
6100 Employees
55K-80K Annually

MassMutual India Logo MassMutual India

Associate

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana, IND

Jobba Trade Technologies, Inc. Logo Jobba Trade Technologies, Inc.

Customer Success Specialist

Cloud • Information Technology • Productivity • Professional Services • Software
Hybrid
Chicago, IL, USA
45 Employees

Similar Companies Hiring

MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana
bet365 Thumbnail
Software • Gaming • eSports • Digital Media • Automation
Denver, Colorado
6100 Employees
Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account