Job Description :
The BI Quality Assurance (QA) Analyst, is responsible for testing and assuring the quality of analytical and reporting solutions to support the operational and strategic imperatives of the organization. As a QA Technical Analyst, this position will be a part of and work closely with Business Intelligence (BI) and Data Warehouse(DWH) technical development team in an Agile development process.
For BI/DWH solutions, this position will be participating in all aspects of project testing, business requirement analysis, data analysis, testing strategy, test case creation, test case execution, defect finding and metrics on testing/defect life cycle. This position will perform the analysis and testing activities, will participate in the regular scrum activities.
Primary Responsibilities
Participate in requirements & use case/user story reviews
Responsible for creating and/or overseeing the creation and approval of test cases
Responsible for generating all QA-related documentation
Ensuring adherence to standardized QA policies, processes and documentation standards
Develop test plans and cases based on various levels of requirements details
Execution of test cases and adherence to test schedule
Organize test scenario review with the team
Responsible for helping other QA members of the BI team
Responsible for (re)testing QA/UAT/Production defect fixes
Responsible for being familiar with source code, version management, and code deployment standards and for utilizing this knowledge to ensure that QA processes and procedures for test environments are followed and that the integrity of the various environments is not compromised.
Attends daily standup meeting and provide testing status
Provides QA status reports
Attends biweekly sprint completion meeting and demo
Efficiently work in an Agile environment – both Sprint and KanBan.
Qualifications
Technical Skills (must have):
6+ years of experience in software quality assurance working on BI/DWH projects.
6+ years of experience testing in one or more of the following environments: BI Testing, RDBMS testing, UI testing for SSRS and/or Tableau, and Functional testing.
4+ years of experience with any major RDBMS, preferably MS SQL Server, and the ability to develop complex SQL queries.
2+ year experience testing BI Reports.
2+ year experience with BI tools – SSRS, Tableau, SSAS, etc.
2+ year experience with Test management tools, like ALM/qTest
Strong knowledge of a typical Agile, SDLC, and SQA methodology
Excellent troubleshooting, analytical, and problem solving skills
Excellent testing resource planning and test scheduling skills
Ability to produce effective software test plans and test cases
Analyze and thoroughly document defects detected during test execution. Work closely with developers and BA to resolve the defects in a timely manner.
Ability to write quality defects and work directly with developers to resolve the defects
Solid understanding of build tools and software configuration management standards
Ability to communicate and work closely with other teams and/or team members.
Additional Skills (good to have):
Understanding of Data Warehouse concepts, star schema models, database design concepts and architecture for data warehouse is a big plus.
2+ SQA experience working within an Agile development framework is preferred.
Soft Skills:
Strong analytical, problem-solving, time management and organizational skills
Able to multi-task and follow through on assignments to completion
Ability to prioritize work with tight schedules and target dates
Proven ability to work effectively in a fast-paced environment as part of a high-performing team