Altruist
Senior QA Engineer, Data
Altruist, San Francisco, California, United States, 94199
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 - butwe 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 impactCreate test scripts and test plans to enable streamlined data testing practiceAnalyze and organize raw dataConduct detailed source-to-destination data testing; identifying issues with data integrity, data accuracy, and transformation logicValidate transformation hierarchy and cleanup rulesTest 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 possibleCreate new and maintain existing documentation for testing the team's solutionsDesign, develop, and improve automated code/data testing & reporting systemsProactively suggest, plan, and integrate new tools and methods to improve what can be tested and what automations can be performedEnsure data transformations and aggregations maintain consistency across systems and time periodsTest upstream and downstream dependencies to ensure that data transformations are correctly propagated across servicesValidate data lineage to ensure data's journey through the pipeline is traceable and correctIdentify 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 casesWhat 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 systemsHave a "test to break" approach and a drive toward 100% data accuracyWell-versed in writing test cases to validate data qualityAbility to identify/triage/isolate bugs in software systemsHands-on experience working with automation for regressionAbility to perform integration testing of data pipelines and the services that consume themExperience 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 systemsFamiliarity/Experience in database testing tools like DBT or Great ExpectationsKnowledge in AWS (S3, Airflow), Gitlab
Ownership -
The pride you put into every aspect of your work is unparalleled and undeniableSuperb 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
- Your confidence is brilliant, yet ego-less. You possess a strong knowledge base, the ability to discover the unknown, and are open to differing perspectives.Creative problem solving
- Identifying the problem is simply not enough. You're instinctually creative with your approach in finding solutions to roadblocks.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 packagesPremium healthcare, dental, and vision insurance plans401k savings plan with matching contributions and immediate vestingFlexible PTO so you can satisfy your passions outside of workGenerous paid parental leaveProfessional growth and development opportunities including an employee mobility program and an annual L&D budget allocation for each employeePhysical and emotional wellness programs that nurture both your mind and bodyCompany 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.
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 - butwe 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 impactCreate test scripts and test plans to enable streamlined data testing practiceAnalyze and organize raw dataConduct detailed source-to-destination data testing; identifying issues with data integrity, data accuracy, and transformation logicValidate transformation hierarchy and cleanup rulesTest 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 possibleCreate new and maintain existing documentation for testing the team's solutionsDesign, develop, and improve automated code/data testing & reporting systemsProactively suggest, plan, and integrate new tools and methods to improve what can be tested and what automations can be performedEnsure data transformations and aggregations maintain consistency across systems and time periodsTest upstream and downstream dependencies to ensure that data transformations are correctly propagated across servicesValidate data lineage to ensure data's journey through the pipeline is traceable and correctIdentify 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 casesWhat 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 systemsHave a "test to break" approach and a drive toward 100% data accuracyWell-versed in writing test cases to validate data qualityAbility to identify/triage/isolate bugs in software systemsHands-on experience working with automation for regressionAbility to perform integration testing of data pipelines and the services that consume themExperience 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 systemsFamiliarity/Experience in database testing tools like DBT or Great ExpectationsKnowledge in AWS (S3, Airflow), Gitlab
Ownership -
The pride you put into every aspect of your work is unparalleled and undeniableSuperb 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
- Your confidence is brilliant, yet ego-less. You possess a strong knowledge base, the ability to discover the unknown, and are open to differing perspectives.Creative problem solving
- Identifying the problem is simply not enough. You're instinctually creative with your approach in finding solutions to roadblocks.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 packagesPremium healthcare, dental, and vision insurance plans401k savings plan with matching contributions and immediate vestingFlexible PTO so you can satisfy your passions outside of workGenerous paid parental leaveProfessional growth and development opportunities including an employee mobility program and an annual L&D budget allocation for each employeePhysical and emotional wellness programs that nurture both your mind and bodyCompany 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.