Business Intelligence & Analytics tester

Location Liverpool or Bracknell

Contract Permanent

Salary £55,000

Ref DH-1494-BIT

Devonshire Hayes are working with a long standing partner, who are on the look out for a BI & Analytics Tester to become a part of their team. This is a Hybrid role.

Purpose of the Role

To support the organisation by thorough testing of business intelligence/DWH and reporting solutions developed by the BI & Analytics team. The BI & Analytics tester will work closely with the developers and business analyst to formalise acceptance criteria, develop appropriate test cases and ultimately approve new developments for release. The BI & Analytics tester will work closely with the team to resolve bugs/issues during development.

The BI & Analytics function will provide a ‘single source of truth’ for data within the organisation and all requests for reports, data extracts and other forms of BI will be channelled through the BI & Analytics team. It will also handle data migration and integration activities.

Reports to – Business Intelligence & Analytics Manager.


  • Define test requirements from accurate analysis of business needs, develop test cases and generate test data according to the scope defined to comply with business requirements.
  • Design and automate (where applicable) tests for effective testing of user stories being developed by the product team.
  • Lead a test-first development method, in which the tests constructed will be used to prove the correctness of data extraction from source systems, transformation and loading for a data warehouse and to validate reports and user interfaces built using various reporting and data visualisation tools.
  • Work with Business Analysts to achieve sign off from a variety of business stakeholders that the solutions have met requirements through comprehensive test results and that the completion of all test activity has been undertaken within scheduled timescales and business expectations.
  • Troubleshoot issues found during testing, working closely with developers and Business Analysts to resolve and fix identified issues, or suggest alternative solutions which still meet business requirements.
  • Responsible for change and release management; raising changes with IT and notifying them when changes are to be closed or of delay/issues. Carrying out code deployments to production and maintaining the test environment.
  • Raise defects where necessary and track to a timely completion, re-testing fixes to ensure reported problems are resolved. Identify and escalate, where appropriate, critical technical issues to the BI & Analytics manager that may impact on the delivery timescales.

Experience and Skills:

  • In depth understanding of data warehousing methodologies and design principles.
  • Experience of ETL technical design, development and support practices.
  • Extensive use of and fully conversant in Transact SQL and working in Microsoft SQL Server, building SQL scripts and using tools like SQL profiler, SQL Server Agent etc.
  • Experience in using SSIS to run, test and deploy packages through environments.
  • Skilled at manipulating data in Excel and working with large data sets.
  • Experience in, and understanding of the project lifecycle using Agile Scrum, and experience of JIRA task management system.
  • To provide technical leadership in areas of expertise.
  • Ability to quickly assimilate and understand business processes and information flow.
  • Familiar with working with software developers to provide support for applications development.

If this is something you may be interested in, please do get in contact with me and we can discuss the role a lot further.

Fill in your details to apply.

    Attach a CV (Accepted file types: pdf, doc, docx, rtf.)