QA Analyst w/Azure SQL
Remote for now but onsite at Middle River, MD when open for onsite
12 months plus
QA Analyst Responsibilities and Skill Set:
Support the Data Warehouse Team in testing data extracts, reports, and dashboards to ensure data quality before release. Create, execute, and monitor test plans including tracking and documenting findings. Creating test scripts using SQL programming to validate data points against transactional systems and the data warehouse. Help to implement a formal QA process including creating templates and documenting standards/processes. Collaborating with business owners and subject matter experts to clarify requirements and to complete user acceptance testing. Creating documentation needed to support repeatability of testing metrics.
The ideal candidate will have the following skill set as described in the contract:
2+ years of testing experience
5+ years of SQL programming experience
Experience using Excel including VLOOKUP, pivot tables, and basic formulas.
Strong analytical, organizational, and team skills
A bachelor’s degree in Computer Science, IT, MIS, Business Management, Engineering, Project Management, or related field.
This may be substituted with relevant experience of 5+ years.
Ability to work on multiple priorities and meet project delivery dates.
Knowledge of Software Development Lifecycle (SDLC) K-12 education experience preferred but not required.
Ability to effectively communicate with all levels of users and teammates both written and verbally.
Ability to analyze and interpret requirements and file layouts into test cases.
Ability to work independently and as part of a team.
Ability to perform unit, system, and performance testing.
Ability to produce status reports and communicate status of projects on a regular basis.
Responsibilities:
· Develop and formulate business and testing requirements.
· Assure high quality deliverables.
· Follows all required software development standards, change control procedures, and security requirements.
· Ability to build relationships with project sponsors, stakeholders, other technical staff, vendors, and end users.
· Coordinates and performs required unit, system, and performance testing. Works with other team members on User Acceptance testing and issue resolution.
· Participates in continuous improvement activities by identifying and analyzing the effectiveness and efficiency of existing processes and develops strategies for improvements.
· Produces status reports and communications on a regular basis.
Required Skills:
Experience working with Azure SQL Database.
· Skill in the operation of computers and peripheral equipment.
· Skill in creative and analytic problem solving.
· Understanding of Data Warehousing principals, concepts, and architecture.
· Ability to manage multiple priorities and meet project delivery dates.
· Ability to effectively analyze and manage requirements.
· Ability to visualize complex issues.
· Knowledge of personal computers, Microsoft Office suite of tools including Word, Excel, and PowerPoint.
· Ability to coordinate the work of a team with the work of other units within the Department of Research, Assessment, and Accountability and other BCPS offices and departments.
· Effective verbal and written communication skills
· Ability to effectively communicate with all levels of users and team members.