QA Engineer

Stand8 provides end to end IT solutions to enterprise partners across the United States and with offices in Los Angeles, New York, New Jersey, Atlanta, and more including internationally in Mexico and India.The QA Engineer will support cloud-native applications and data environments using Power BI, Snowflake, and dbt. This role will develop and validate data models, automate testing, support CI/CD workflows, and ensure data quality across production systems. The ideal candidate will have strong SQL, analytics, automation testing, and Azure DevOps experience. This is a fully onsite position in Los Angeles, California.Location & Work TypeLocation: Los Angeles, CA Work Type: OnsiteKey Responsibilities

• Develop SQL using DBT within a Snowflake environment.
• Code locally within a docker container using Visual Studio Code,and deploy updates via GIT/Azure DevOps.
• Integrate with CI/CD pipelines and author comprehensive descriptions for all pull requests.
• Define and map dbt sources, implementing source freshness rules.
• Leverage dbt macros effectively to modularize and reuse complex logic across models.
• Design fact and dimension tables using a star schema optimized for Power BI.
• Implement standard and custom dbt tests, including macros, to ensure data resiliency and catch anomalies.
• Schedule tasks and validate incremental materialization logic to optimize compute costs.
• Generate and maintain comprehensive documentation, ensuring column level descriptions exist for all production models.
• Optimize and performance-tune models by leveraging Snowflake clustering and dbt pre/post-hooks.

QualificationsRequired:

• 3 years of experience as a QA
• 3 years of experience with testing automation using Selenium
• Resource must work onsite at the central office
• Experience with school district-level data
• Good understanding of SQL
• Experience in cloud-native application QA such as Power BI, Snowflake, and DBT
• Strong analytics skills with the ability to analyze complex data and identify trends and patterns.
• Experience with Azure DevOps
• Expert knowledge on automation testing tools such as Selenium to automate testing on various aspects of an application.

Preferred (Optional):None specified.Benefits

• Medical coverage and Health Savings Account (HSA) through Anthem
• Dental/Vision/Various Ancillary coverages through Unum
• 401(k) retirement savings plan
• Paid-time-off options
• Company-paid Employee Assistance Program (EAP)
• Discount programs through ADP WorkforceNow

Additional DetailsThe base range for this contract position is $50 - $60 / per hour, depending on experience. Our pay ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Qualified applicants with arrest or conviction records will be considered.About UsStand8 provides end-to-end IT solutions to enterprise partners across the United States and globally with offices in Los Angeles, Atlanta, New York, Mexico, Japan, India, and more. Stand8 focuses on the "bleeding edge" of technology and leverages automation, process, marketing, and over fifteen years of success and growth to provide a world-class experience for our customers, partners, and employees.Our mission is to impact the world positively by creating success through PEOPLE, PROCESS, and TECHNOLOGY.Check out more at www.stand8.io; and reach out today to explore opportunities to grow together!By applying to this position, your data will be processed in accordance with the Stand8 Privacy Policy.