Senior QA Engineer, Data

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
• Conduct 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
• Design, develop, and improve 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
• Ensure data transformations and aggregations maintain consistency across systems and time periods
• Test upstream and downstream dependencies to ensure that data transformations are correctly propagated across services
• Validate 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.
• Partner closely with the product owner development teams to understand requirements and appropriate use cases

What you bring

• Experience - 6+ years of industry experience in data engineering and Quality Assurance at a B2B financial services, fintech or SaaS organization
  • Experience designing and implementing automated testing systems
  • Have a "test to break" approach and a drive toward 100% data accuracy
  • Well-versed in writing test cases to validate data quality
  • Ability to identify/triage/isolate bugs in software systems
  • Hands-on experience working with automation for regression
  • Ability to perform integration testing of data pipelines and the services that consume them
  • Experience working in an Agile project team setting
• Technical Aptitude - You're technologically savvy and can easily get up to speed on modern tech stacks
  • Extensive experience using SQL to perform queries/analysis on database systems
  • Familiarity/Experience in database testing tools like DBT or Great Expectations
  • Knowledge in AWS (S3, Airflow), Gitlab
• Ownership -  The pride you put into every aspect of your work is unparalleled and undeniable
• Superb communication - Intentional dialogue is a superpower. You listen as well as you share your perspective with others.
• Resilience - We’re inspired by your unwavering determination to achieve success, no matter the adversity you face along the way.
• Assurance - Y