Job Description

Job Title: Power BI Tester (Power BI, Automation & DAX Validation)


Experience: 10+ Years


Domain Expertise: Property and Casualty Insurance


Professional Summary


Experienced Power BI Tester with over 10 years of expertise in validating business intelligence solutions within the insurance domain. Specializes in automation testing of Power BI dashboards, DAX expressions, and data pipelines deployed on AWS cloud infrastructure. Ensures accuracy, performance, and reliability of reports used for critical decision-making across claims, underwriting, and policy analytics.


Core Competencies


BI Testing & Automation


Develops and executes automated test cases for Power BI dashboards and reports using tools like Selenium, BI Validator, and REST APIs.


Performs regression, performance, and stress testing across AWS-hosted environments (Dev, QA, Pre-Prod, Prod).


Validates report visuals, filters, slicers, bookmarks, and row-level security (RLS).


DAX Query Validation


Writes and validates DAX expressions to ensure accurate aggregations, calculations, and business logic.


Uses tools like DAX Studio and Wiiisdom for automated DAX testing and semantic model validation.


Implements test cases for key insurance metrics (e.g., claims paid, policy lapse rates) using representative filter contexts.


SQL & Data Validation


Performs backend data validation using SQL to ensure consistency between AWS-hosted source systems and Power BI reports.


Validates data transformations, joins, and aggregations across multiple layers including Redshift, RDS, and S3.


AWS Cloud Integration Testing


Tests data flows and integrations across AWS services such as S3, Glue, Redshift, and Lambda.


Validates Power BI connectivity and refresh schedules for cloud-based datasets.


Ensures secure and optimized data pipelines in alignment with AWS best practices.


Agile Delivery & Collaboration


Works in Agile teams, participating in sprint planning, stand-ups, and retrospectives.


Uses JIRA for defect tracking, test case management, and reporting.


Collaborates with BI developers, data engineers, and business analysts to define test strategies and acceptance criteria.


Nice-to-Have Skills


Property and Casualty Insurance domain knowledge


Python scripting for automation and data profiling


Familiarity with Databricks Lakehouse architecture


Experience with Power Query and Power BI Service lifecycle management

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth -- one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.



Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.



Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.