BI QA Analyst Job Listing at TCC in Fishers, IN (Job ID 8543)

Description

POSITION PURPOSE

The Cellular Connection (TCC) is looking for a fulltime resource who has solid experience in Quality Assurance testing in the area of Business Intelligence and Power BI. The successful candidate will be responsible for designing, implementing, and maintaining testing processes for ETL workflows and Cube metrics, ensuring the accuracy and integrity of data transformations, and validating Power BI reports and visualizations.   This role involves collaborating with cross-functional team s to drive testing best practices, enhance overall testing efficiency, and ensure the high-quality delivery of data driven insights.

ESSENTIAL DUTIES

 To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions

• Establish QA processes, test cases, and documentation
• Collaborate with business analysts to understand requirements, ensuring requirements include data quality components
• Ensure that business requirements are mapped to test cases
• Define and implement an overall automation strategy for testing ETL, Cube, and Power BI Reporting
• Develop and execute automated test scripts to validate accuracy, completeness, and performance
• Identify and determine data for testing
• Create comprehensive reusable, maintainable test plans, test cases, and test scripts for ETL process, Cube model, and Power BI report
• Create and maintain a reusable test script library
• Execute test scripts, analyze results, and collaborate with BI team to address any identified issues
• Ensure that software meets both functional and non-functional requirements and fulfills the acceptance criteria
• Perform functional, smoke, UI, regression, and system integration testing
• Participate actively in Agile / scrum ceremonies, providing insights into testing efforts and coordinating with the development team
• Generate and maintain documentation on ETL, Cube, and Power BI test results, test coverage, and automation progress
• Conduct Data profiling to ensure validity of test cases
• Participate in UAT and Production support
• Routinely analyze data across data lineage, from source to stage to target to reports
• Provide estimation of BI testing deliverables to management, highlighting risks and ensuring software is delivered as per Project plan
• Lead efforts in performing POC/research for new tools, making recommendations for automation testing of ETL and Power BI
• Identify and implement continual improvement initiatives to help improve overall quality
• Maintain Data Dictionary

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES

The requirements listed below are representative of the knowledge, skill, and/or ability necessary to perform this job.

Skills and Competencies.  

• Strong working knowledge of quality assurance methodologies
• Ability to analyze testing requirements and design test cases for integrations, functional performance, regression, and user acceptance
• Ability to clearly present and communicate test plans and results
• Familiar with data warehousing concepts
• Expertise in SQL – Queries
• Proven ability to communicate well verbally and in writing, with all areas at TCC.

       Excellent communication skills are important – both written and spoken.   

• Ability to work on a team as well as independently, multi-task, and manage time and priorities to meet deadlines.
• Understanding of Agile/Scrum methodology and working experience in an Agile environment  

• Innovative mindset: ability to think both creatively and critically 
• Able to evaluate priorities and manage work to critical project timelines in fast-paced environment. 

• Ability to prioritize and handle multiple tasks in high-pressure environment 

• Research and troubleshoot issues and questions related to deployed solutions 
• Maintain knowledge on the latest testing technology and best practices 
• Good attention to detail

EDUCATION

Bachelor's degree (B.A. / B.S.), preferably technical degree, or related field or 5 years of the equivalent combination of education and experience.

EXPERIENCE

• 3 years QA Testing in Business Intelligence, preferably working with Microsoft technologies
• 3 years of experience writing system test cases/scripts, executing test scripts
• Working experience with Agile methodology
• Experience with Data Warehousing concepts
• Experience with Retail data preferred

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Typically works in a general office environment.

TRAVEL REQUIREMENTS

None.

JOB DETAILS:

• Selected candidates MUST clear background check.
• Level: Non-manager
• Location: On-site Fishers, Indiana

KPI'S: 

• UAT issues error rate (due to code development issue(s)) <5%
• Resolve Enterprise Reporting service tickets within 5 days >90%
• BI System uptime 99%

Equal Employment Opportunity We're proud to be an equal opportunity employer and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status.

#IT #BI #Analyst #Newjob