The Data Quality Assurance Analyst candidate will work closely with product owners, developers and project managers to define and prioritize testing data requirements. The candidate will add value to the team by validating the data quality, data accuracy, and data integrity by testing various reports and the data sets requested by business users.
Responsibilities
Work closely with the Business Analyst in gathering requirements to understand and identify business needs and the objectives related to the required data elements.
Perform analysis on the data requirements and clarify any questions with business stakeholders to clarify the data requirements.
Develop and execute comprehensive test plans and test cases for both manual and automated testing.
Validate reports to ensure data quality, data accuracy, and data consistency objectives are met.
Create SQL scripts to build data sets based on the requirements to validate data against developed reports checking for discrepancies, data inconsistencies and counts.
Identify and communicate any data related issues using established agency processes.
Support business users during User Acceptance Testing; ability to answer or investigate any questions or issues raised.
Design and maintain automated test scripts using Microsoft technologies.
Skills Required:
Ability to effectively collaborate with developers and business experts.
Ability to work as part of a self-directed team, in which tasks are determined daily in coordination with co-workers, rather than being assigned.
Ability to excel in a collaborative and distributed team environment.
Ability to work with a minimal amount of direction while being pro-active in keeping their management informed of project related issues.
Ability to work under pressure.
Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs.
Ability to effectively communicate with various levels of employees ranging from entry level to senior leadership.
Ability to manage multiple projects at the same time and shift priorities quickly.
Proven strong problem-solving skills, troubleshooting and root cause analysis.
Excellent written and verbal communication skills.
Strong aspiration to learn new technologies.
Experience Required:
5+ years of relevant QA Data Analyst/ETL testing/Data quality testing.
Advanced level of SQL Server database query language (TSQL).
Experience in context-based, exploratory, or scenario testing.
Basic understanding of programming.
Ability to focus on deadlines and deliverables.
Ability to maintain confidentiality.
Experience Preferred:
Experience in the education industry is preferred.
Experience working on an Agile/Scrum team preferred.
Experience with TFS, MTM and MS Test is preferred.