Senior QA Automation Engineer, Data
Company
Altruist
Location
San Francisco, CA
Type
Full Time
Job Description
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.
Date Posted
09/20/2024
Views
2
Similar Jobs
Software Engineer, Data Platform (Lead) - Benchling
Views in the last 30 days - 0
Benchling a leading biotechnology company is seeking a Senior Software Engineer to design and implement scalable multitenant services and APIs The rol...
View DetailsSenior Product Manager, Enterprise - Atlassian
Views in the last 30 days - 0
Loom a video communication platform for asynchronous work is seeking a Senior Product Manager for its Enterprise team The role involves defining strat...
View DetailsSenior Product Manager, Dev Solutions - Atlassian
Views in the last 30 days - 0
Atlassian offers a remote position for a Product Manager in the Dev Solutions team The role involves collaborating with crossfunctional teams to lead ...
View DetailsTreasury Management Officer - Technology and Disruptive Commerce - JPMorganChase
Views in the last 30 days - 0
The job posting is for a Treasury Management Officer in Commercial Banking The role involves generating new treasury management business maintaining c...
View DetailsRelationship Executive, Middle Market Banking - Executive Director - JPMorganChase
Views in the last 30 days - 0
The job description is for a Relationship Executive role in the Middle Market Banking team The role involves building and retaining profitable relatio...
View DetailsSenior Account Sales Representative - Spectrum
Views in the last 30 days - 0
The job involves selling products and services to customers in assigned nonbulk multidwelling units through doortodoor solicitation lobby events and b...
View Details