Quality Assurance Analyst - Contract

About Sound:

Headquartered in Tacoma, WA, Sound Physicians is a physician-founded and led, national, multi-specialty medical group made up of more than 1,000 business colleagues and 4,000 physicians, APPs, CRNAs, and nurses practicing in 400-plus hospitals across 45 states. Founded in 2001, and with specialties in emergency and hospital medicine, critical care, anesthesia, and telemedicine, Sound has a reputation for innovating and leading through an ever-changing healthcare landscape — with patients at the center of the universe. 

About the Role:

We are seeking a highly skilled and experienced Quality Assurance Analyst to join our agile team. The ideal candidate will have a strong background in ETL (Extract, Transform, Load) and data warehousing testing, with a focus on ensuring the accuracy, completeness, and reliability of our healthcare data systems. As part of our team, you will play a critical role in validating data transformations, identifying and reporting defects, and ensuring the overall quality of our data processes.

The Details: This is a contract position with possibility to become permanant.

In this role, you will be responsible for:

• Developing and executing comprehensive test plans and test cases for ETL processes and data flows
• Utilizing SQL queries to validate data transformations and ensure data integrity throughout the ETL pipeline
• Collaborating with ETL developers to communicate defects, missed requirements, and areas for improvement
• Participating in agile ceremonies such as sprint planning, daily stand-ups, and backlog grooming
• Working closely with cross-functional teams to understand business requirements and translate them into test cases
• Performing root cause analysis of defects and provide recommendations for resolution
• Documenting test results, track defects, and ensuring timely resolution of issues
• Continuously improving testing processes and methodologies to enhance efficiency and effectiveness

Values:

• Collaborative: Demonstrates the ability to work well with others to accomplish a goal and get the work done; takes opinions of others into consideration; includes others in the decision-making process
• Intellectually curious:Demonstrates a genuine interest in learning new things and wants to know the reason “why” behind the way things are done
• Committed: Demonstrates a dedication to the job, project, organization, customer/clients and co-workers
• Resourceful: Proactive willingness to utilize available information and tools to figure things out
• Strategic Thinker: Demonstrates the ability to look at the big picture and proactively develop a plan of action
• Team Player: Proactively seek to work with others to accomplish a common goal. Willingness to share challenges and successes with others
• Visionary: Demonstrates the ability to see, articulate and share the future of the organization in ways that engage and motivate those around them with a clear vision and plan for the future
• Work Ethic: Dedication to getting the job done well and on time regardless of circumstances

Knowledge: 

• Bachelor's degree in Computer Science, Information Technology, or related field
• Proficiency in advanced SQL for data validation and manipulation
• Strong understanding of healthcare data and clinical domain knowledge
• Excellent analytical and problem-solving skills
• Strong communication and collaboration skills, with the ability to effectively interact with technical and non-technical stakeholders
• Self-motivated work style with the ability to prioritize and execute tasks independently

• Minimum of 3 years of experience in quality assurance testing, with a focus on ETL and data warehousing
• Knowledge of data warehousing concepts such as star schema architecture, table joins, business keys, temporal tables, and data modeling principles.
• Experience working in an agile environment and familiarity with agile methodologies and tools.

Experience Preferred:

• Certification in Quality Assurance or related field.
• Experience with ETL testing tools such as Informatica, Talend, or SSIS.
• Knowledge of data visualization tools such as Power BI.
• Familiarity with healthcare compliance standards such as HIPAA.
• Experience with automated testing tools and methodologies.
• Knowledge of secure file transfer protocol (SFTP) and ETL code deployment.

Pay Range: This position offers an annual salary range of $95,000-$105,000  Final salary is based on candidate experience, and geographical location.