- Support the Data Analytics 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.
- Create 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 and 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:
- 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 work independently and as part of a team.
- Ability to analyze and interpret requirements, file layouts and test cases.
- 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.
Language skills (must have):
English Native or bilingual proficiency
Experience required:
- **Required Skills:** - Experience working with Azure SQL Database 12. - 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.