Senior QA Automation Engineer, Altruist

Data

$170-225k

+ Equity

SQL
AWS
Airflow
Snowflake
dbt
Senior and Expert level
San Francisco Bay Area
Altruist

All-in-one platform for financial advisors and their clients

Posted today

Altruist

All-in-one platform for financial advisors and their clients

501-1000 employees

FintechB2BInvestingFinancial ServicesSaaS

Posted today

$170-225k

+ Equity

SQL
AWS
Airflow
Snowflake
dbt
Senior and Expert level
San Francisco Bay Area

501-1000 employees

FintechB2BInvestingFinancial ServicesSaaS

Company mission

To make financial advice better, more affordable, and more accessible.

Role

Who you are

  • 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

What the job involves

  • 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

Our take

Altruist has created a cloud-based digital investing platform for independent financial advisors (IFAs). In the past, it’s been common for financial advisors selling products on a commission basis to have access to advanced digital systems, but not those working entirely independently.

Altruist brings an all-in-one platform to all IFAs, removing the need to use multiple programs to manage client accounts whilst bringing high quality assets to all investors, regardless of portfolio size.

Advisors can save time, compress costs and ultimately do more for their clients. Altruist operates a pricing model that scales up with the number of required accounts, unlike some competitor products such as Adviser and Intelliflo which charge a flat monthly subscription fee. Off the back of impressive funding, the company is set to expand its service offerings and support a wider range of RIAs as it becomes a truly comprehensive advising solution.

Freddie headshot

Freddie

Company Specialist

Insights

Top investors

Few candidates hear
back within 2 weeks

67% employee growth in 12 months

Company

Funding (last 2 of 5 rounds)

May 2024

$169m

SERIES E

Apr 2023

$112m

SERIES D

Total funding: $449.5m

Company benefits

  • Be rewarded for doing great work: competitive compensation and equity for all team members
  • Health, dental, and vision coverage, available on your first day
  • Set future you up for success with 4% 401(k) matching
  • Flexible time off and work hours to meet your needs
  • Modern parental paid leave from day one, including 16-week adoptive, birth or foster paid leave, and 4-week child loss or miscarriage paid leave

Company values

  • First and foremost we believe in treating everyone with kindness, respect, and equality
  • Brilliance at Altruist means constantly striving to better your craft with a growth mindset, always learning
  • Lastly, we have grit—a bias toward action and an insatiable appetite for getting things done to bring us closer to delivering on our mission

Company HQ

McManus, Culver City, CA

Leadership

Started their career as a Morgan Stanley System Analyst before co-founding Retirement Wealth as CEO in 2005. They also founded FormulaFolios in September 2011, before combining this financial and entrepreneurial experience to found Altruist in September 2018.

Salary benchmarks

We don't have enough data yet to provide salary benchmarks for this role.

Submit your salary to help other candidates with crowdsourced salary estimates.

Share this job

View 23 more jobs at Altruist