Lead Quality Assurance Engineer

Western Alliance Bancorporation; Town of Texas, Dallas (WI, TX); Hybrid; USD 80,000 - 120,000; Full time

Job summary

An innovative financial institution is seeking a Lead Quality Assurance Engineer to enhance data quality and reliability. In this pivotal role, you will lead a team of QA professionals, ensuring that data remains accurate for critical decision-making. Your expertise in ETL quality assurance and automated testing will be essential as you develop and implement robust QA processes. This position offers a blend of onsite and remote work, providing a collaborative environment where your contributions will significantly impact the organization. If you are passionate about quality and eager to drive improvements, this opportunity is perfect for you.

Benefits

Competitive Salaries

Medical and Dental Insurance

401k Matching Program

Tuition Assistance Program

Employee Volunteer Program

Wellness Program

Qualifications

• 7+ years of experience in ETL quality assurance and automated testing.
• Hands-on experience with Azure Data Factory and SQL scripting.
• Ability to lead QA teams and ensure quality throughout the development lifecycle.

Responsibilities

• Lead a team of QA engineers in testing activities and developing QA processes.
• Conduct reviews of business requirements to extract test requirements.
• Engage with data teams to devise comprehensive test plans and execute tests.

Skills

ETL Quality Assurance

Automated Testing

SQL Scripting

Data Warehouse Solutions

Integration Testing

Communication Skills

Agile Processes

Troubleshooting ETL Jobs

Collaboration

Critical Thinking

Tools

Azure Data Factory

Azure Synapse

SQL Server

Oracle

Control-M

Power BI

Tableau

Job description

Job Title:

Lead Quality Assurance Engineer

Location:

TX - Dallas/Irving

What you'll do:

As the Lead Quality Assurance (QA) Engineer, you are responsible to lead a team of QA engineers who perform Quality Assurance testing for the Enterprise Data & Analytics team. You will play key role in advancing our data maturity across the enterprise. You will leverage your expertise to identify and address systematic errors, working closely with both business and IT teams to ensure our data remains accurate and reliable for critical decision making. This role requires someone who can take the lead in ensuring the quality and reliability of products and continuously seek ways to improve processes.

This position is ONSITE ONLY (4 days onsite with 1 remote day) and you must currently live in or within a commutable distance from Dallas/Irving, TX, Phoenix, AZ, or Columbus, OH.

• Lead, coordinate, manage and mentor a team of QA professionals in testing activities.
• Develop and implement QA processes, standards, and methodologies.
• Conduct a thorough review of business requirements and functional specifications to extract test requirements and craft detailed Test cases/Scripts.
• Develop, document, and sustain repository of test cases and supplementary test artifacts including test data, data validation procedures etc.
• Engage in collaborative efforts with data analysts, data stewards, and data engineers to devise comprehensive test plans.
• Prepare and execute manual and automation test cases with accuracy, and systematically report the outcomes.
• Identify, document, and communicate the bugs and errors to the development teams in a timely manner.
• Maintain logs of various testing phases which includes functional, integration, end to end and regression, sanity, smoke testing, and track defects.
• Partner with cross functional teams to promote and uphold quality throughout the software development lifecycle.
• Publish information and verbalize clear communication to the leadership team about QA processes, obstacles, and key milestones for the quarterly commitments.
• Plan to test on scope changes, estimate, prioritize, and trade-offs with Business and Technical Stakeholders.
• Attend sprints, ceremonies (daily stand-ups, sprint planning, backlog grooming, sprint reviews & retrospectives), evaluate and plan sprint execution velocity and lead/coordinate corresponding activities.
• Actively plan, participate, and contribute to Program Increment (PI) Planning sessions from QA standpoint.
• Ensure adherence to standard (Agile) processes, use of tools, established project delivery standards.
• Ensure Test Plan, Test cases, SQL scripts, and Test results reviews are done, and Approvals are provided.

What you'll need:

• 7+ years of experience in ETL quality assurance.
• 7+ years of experience in automated testing of ETL/Database/Data Warehouse solutions.
• 7+ years of experience in SQL scripting and relational databases.
• Hands on experience in the following tools Azure Data Factory, Azure Synapse, SQL server, Oracle, Azure Storage Account, Data bricks, Unity catalog repository etc.
• Experience as QA lead on medium to large sized projects.
• Experience in designing and implementing data warehouse and automated testing solutions.
• Ability to perform integration testing of data pipelines and the services that consumes them.
• Experience in triggering, debugging, and troubleshooting ETL jobs/processes.
• Guide offshore resources on project deliverables and review their work.
• Experience in workload automation solutions such as Control-M.
• Familiarity with high-level programming languages, preferably Python.
• Good understanding of the Software Development Lifecyle (SDLC) and the Software Testing Lifecycle (STLC) and agile processes.
• Excellent communication skills and ability to work in a collaborative environment.
• Experience in reporting tools alike Power BI/Tableau.
• Experience working in an onshore-offshore model.
• Strong negotiation, influencing, critical thinking, coaching and facilitation skills.
• Excellent verbal and written communication skills and exhibit strong presence.

Benefits you'll love:
We offer all the important things you'd want - like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!

About the company:

Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company.

Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email [e-mail] or call 602-386-2488. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.

Western Alliance Bancorporation