Power BI Quality Analyst

Job Summary The Power BI Quality Analyst is responsible for validating the accuracy, quality, performance, and functionality of Power BI reports, dashboards, and datasets before deployment to production. This role works closely with Business Analysts, Developers, Client Services, and business stakeholders to ensure reporting solutions meet business requirements, data quality standards, and governance controls.

Key Responsibilities Quality Assurance & Testing

• Review business and functional requirements for Power BI reports and dashboards.
• Develop and execute test plans, test cases, and test scripts.
• Validate report functionality, calculations, filters, drill-through actions, and user interactions.
• Perform regression, integration, and User Acceptance Testing (UAT) support.
• Verify report compliance with business requirements and acceptance criteria.

Data Validation

• Reconcile report data against source systems, databases, and business rules.
• Validate DAX calculations, measures, KPIs, and aggregations.
• Ensure data accuracy, completeness, and consistency across reports.
• Perform source-to-target data validation.

Performance Testing

• Test report load times and dashboard performance.
• Identify and document performance bottlenecks.
• Validate dataset refresh schedules and refresh success.
• Verify optimized report functionality across different user groups.

Defect Management

• Log, track, and retest defects using Jira, Azure DevOps, or other testing tools.
• Work with developers to resolve reporting defects.
• Verify defect fixes and complete regression testing.

Documentation & Compliance

• Create and maintain test plans, test cases, and test evidence.
• Document testing results and sign-off recommendations.
• Support reporting governance, audit, and compliance requirements.

Required Qualifications Education

• Bachelor's degree in Information Technology, Computer Science, Business Analytics, or related field preferred.

Experience

• 4-6 years of QA testing experience with BI, reporting, or analytics solutions.
• Experience testing Power BI reports and dashboards.
• Experience with data validation and SQL queries.
• Familiarity with Agile/Scrum delivery methodologies.

Technical Skills

• Microsoft Power BI
• SQL and database querying
• Data validation techniques
• Jira or Azure DevOps
• Microsoft Excel
• Test case creation and execution
• Defect management processes

Key Competencies

• Strong analytical and problem-solving skills.
• Exceptional attention to detail.
• Ability to identify data discrepancies and reporting issues.
• Strong written and verbal communication skills.
• Ability to manage multiple testing priorities.
• Collaborative team player.