BI QA Data Analyst

The Chef´s Company - Fishers, IN

Full-time - Entry Level

Fishers, IN

Furniture, Home Furnishings, Electronics, and Appliance Retailers

About the position

The Cellular Connection (TCC) is seeking a full-time Quality Assurance Tester with expertise in Business Intelligence and Power BI. This role focuses on designing, implementing, and maintaining testing processes for ETL workflows and Cube metrics, ensuring data accuracy and integrity, and validating Power BI reports. The successful candidate will collaborate with cross-functional teams to enhance testing efficiency and deliver high-quality data-driven insights, while embodying TCC's mission to positively impact communities.

Responsibilities

• Establish QA processes, test cases, and documentation.
• Collaborate with business analysts to understand requirements, ensuring data quality components are included.
• Map business requirements 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 the BI team to address identified issues.
• Ensure software meets both functional and non-functional requirements and fulfills 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.
• Conduct data profiling to ensure validity of test cases.
• Participate in UAT and Production support.
• Support production loads as part of a weekend rotation schedule.
• 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 improve overall quality.
• Maintain Business Glossary and Data Dictionary, including classification levels for Data Sensitivity and Data Quality for each metric.

Requirements

• 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.
• Familiarity with data warehousing concepts and BI solutions.
• Proficiency in SQL for querying databases and validating data.
• Familiarity with BI Tools - Power BI, ADF, SSAS, etc.
• Experience with Python, R for data manipulation.
• Proven ability to communicate well verbally and in writing with all areas at TCC.
• Excellent communication skills, 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.
• Strong analytical skills to interpret complex datasets and identify discrepancies.
• Ability to prioritize and handle multiple tasks in a high-pressure environment.
• Research and troubleshoot issues related to deployed solutions.
• Maintain knowledge of the latest testing technology and best practices.
• Good attention to detail.

Nice-to-haves

• Experience with Retail data preferred.