This is a hands-on position with a primary focus on leading and executing testing in conjunction with the project team and project business owner. This position will be responsible for performing all facets of data testing: quality standards, controls, and procedures. The Quality Assurance Senior Specialist will have the technical knowledge to support quality assurance aspects of all ETL (extract, transform, load) platforms and coding in registry data projects. The position selectee must function as a team member, and work to maintain a positive work environment.

Major Duties and Responsibilities:

• Create and execute test plans and scripts that will validate the projects data quality and data integrity as the data is transitioned through the ETL data warehouse process.
• Analyze documentation and technical specifications to ensure that quality assurance activities allow the ETL process to meet business requirements and systems goals, fulfill end-user requirements, and identify existing or potential issues
• Test the compliance of information flows and data stores against data quality standards.
• Provide risk assessment during project planning and development
• Create and maintain test documentation and test plans, plus work with the project team to create a suite of test data to exercise data validation and ETL functionality
• Create and execute SQL queries as needed to validate that test results match expected results
• Identify and log defects and when necessary, use SQL to narrow down the root cause of the defect issue
• Work closely with the scrum team to analyze, debug and resolve any issues
• Effectively communicate test progress, test results, and other relevant information to project stakeholders and management
• Enforce and monitor adherence to quality standards
• Create and execute regression test scenarios
• Other duties as assigned

Desired Qualifications:

• Bachelor’s Degree in information technology, computer science, statistics or similar technical degree

• Five years of testing/development experience using SQL Server with the following highly desired
  • Data warehousing and data modeling
  • Strong knowledge of aspects of Data validation testing
  • Strong experience testing data exchanges with XML
  • Strong knowledge of aspects of ETL program testing
  • Experience writing and executing complex SQL queries using views/tables
• Detail-oriented, with excellent organizational skills and able to manage multiple issues simultaneously
• Excellent diagnostic, problem-solving and debugging skills.
• Knowledge of applicable data privacy practices and laws a plus.

• Experience with the Altova Suite of products
• SSIS (SQL Server Integration Services) development and testing experience
• Exposure to and experience using automated data test tools such as Selenium and Eclipse
• Strong written and oral communication skills; strong interpersonal skills.
• Self-directed and proactive; thinks beyond the immediate problem.
• Flexibility, ability to change priorities quickly, and capacity to handle multiple tasks.
• Experience working both independently and in a team-oriented, collaborative environment.
• Experience in Healthcare IT or Support environment a plus

About Us:

At the American College of Cardiology, we bring our hearts to work.

We are a 500-person organization dedicated and committed to our mission to transform cardiovascular care and improve heart health for the past 70 years. When you join our team, you become part of a passionate culture that envisions a world where innovation and knowledge optimize cardiovascular care and outcomes.

Every day, we are committed to supporting our more than 54,000 members and their patients around the globe and in doing so, ensure our staff have a positive environment of teamwork, collaboration, professionalism and excellence. To learn more about why ACC has been recognized as one of Modern Healthcare's Best Places to Work in Healthcare please visit our site at: www.acc.org/jobs.

COVID Considerations:

As an employer in the public health space, and an organization that serves members who are essential medical personnel, ACC requires all staff, temporary employees, and contractors to be fully vaccinated against COVID-19 before working onsite at ACC or attending ACC events. Proof of vaccination will be required. Individuals can request an exemption from this requirement due to a medical condition or sincerely held religious belief, and those requests for reasonable accommodations will be evaluated individually.

ACC is proud to be an equal opportunity and affirmative action employer. We celebrate diversity and are committed to creating an inclusive environment for all candidates and employees. All employment is decided on the basis of qualifications, merit and business need. Equal Opportunity Employer, including individuals with disabilities and veterans.

ACC is committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact Crystal Nott, Sr. Director, People Resources & Engagement at cnott@acc.org or (202)375-6423.