BI Test Lead - Business Intelligence, ETL, Insurance

ARC IT Recruitment Ltd
London (Greater)
13 Nov 2017
16 Nov 2017
Contract Type
Full Time
BI Test Lead - Business Intelligence, ETL, Insurance


BI Test Lead with significant Test Lead experience within Business Intelligence is required by leading Insurance organisation based in the heart of the City. This is a highly rewarding role which will see you providing direction and leadership to the BI Test team and implementing a strategy to improve the role of testing within the team. You will manage end-to-end testing for both data and reports, and work in partnership with an off-shore test team to achieve the desired outcome.

Key Responsibilities:
  • The lead will be responsible for the management of all technical BI testing within the team and be 'hands-on' as required.

  • Perform the required ETL testing, defect analysis, test planning and defect management for DWH and BI applications in Agile environment.

  • Govern and control the BI testing effort and record and publish testing metrics required to manage the testing activities.

  • Be responsible for resource planning and managing the off-shore test team in order to implement effective software delivery.

  • Report into the leadership team to manage the expectations for the testing stages of each agile sprint.

  • Manage all risks associated with BI testing and take preventative action when any risks become unacceptable.

  • Report on the effectiveness of BI testing and identify improvements to the testing process based on knowledge of modern testing techniques and best practice.

  • Create a framework for test automation and lead on the design, build and implementation of an automated test suite.

  • Ability to categorise testing problems into automatable and non-automatable and proactively implement efficient approaches to both.

  • Work closely with Solutions Architect, Business Analysts and SQL/BI developers to understand the technical requirement/design being built per project.

  • Define and create test cases from analysis of both functional and non-functional specifications for SIT, QA, UAT and Regression test phases.

  • Produce test scripts, materials and regression test packs to test new and amended software or services.

  • Perform end-to-end testing on any changes that impact system data (manual and automation) using agreed methods and standards.

  • Work proactively to specify requirements for environment, data, resources and tools in advance.

  • Supervise, mentor and support members of the off-shore testing team to foster positive working relationships.

Key Requirements:
  • Min. 5 years' experience as a Test Lead within a Business Intelligence environment.
  • Microsoft SQL Server Business Intelligence suite (desirable)
  • Expertise writing T-SQL
  • Strong understanding of data warehouse architectures, database models and database reporting tools (using SQL Server)
  • Knowledge of the Insurance Industry (highly desirable)
  • Working knowledge of SSRS, SSIS and SSAS
  • Data warehouses, data cubes and ETL testing
  • Excellent knowledge of MS SQL
  • Agile methodology and testing
  • JIRA
  • Qlikview (highly desirable)
  • Demonstrable expertise working within a data warehousing environment
  • Strong hands-on track record of testing BI Solutions

For a full consultation on this role please email your CV to Rebecca.
This job was originally posted as