BI Tester

  • Location: Gibraltar
  • Salary: £35,000 - £40,000 pa
  • Type: Permanent
  • Job reference: 20831

Role Purpose

The role of BI Tester is responsible for the Testing, accuracy and quality assurance of technical solutions to support reporting, data mining and analytics. Your deliverables will instill confidence in the accuracy of BI and help the business team leaders shape the strategic direction of the business.

Reporting to the BI Test Manager you will work proactively with the rest of the BI team and additional teams such as CRM, Product and Brand Marketing to support the implementation of new initiatives. This support should be provided in such a way their brand's performance can be measured and reporting can be delivered effectively with insight provided.

  • You will be expected to contribute to all aspects of technical testing and QA.
  • Your technical knowledge and exposure will be sufficient to understand the principles of BI design and development and you will be proficient enough in SQL to interrogate databases on SQL Server, Oracle and Informix technologies.
  • You will work closely with in-house and third party development teams to identify and resolve defects in an accurate and timely manner and the ability to understand the relative priority and the impact of defects in business terms.
  • You will be responsible for the planning and logging of test scenarios, the automation of testing where possible and the raising of defects with in the Jira tracking system.
  • You will be required to work within an Agile development framework.
  • You may need to travel to offshore/third party sites in India and the UK as and when the role
    requires.

Key Responsibilities

  • Understand how data within the core business systems relates to business activity and constant improvement of business performance
  • Fully understanding the data within the core business systems such as IMS and Openbet. This will include ensuring all data is mapped correctly for KPI and analytic reporting purposes and that this it in line with the business operational approach
  • Working with key stakeholders to understand business requirements from a data collation point of view, including all technical requirements to be input into the systems
  • Understand the mappings of source systems to dimensional data models in the target
    data warehouse schema and analytical cubes
  • Test Extract Transformation and Load (ETL) processes developed using Oracle ODI, SSIS
    TSQL and .NET in order to ensure the accuracy of data mapping and applied business
    rules.
  • Test the accuracy of key reporting KPIs within MS SSIS analysis cubes and SSRS reports
  • Regression testing of software prior to code releases
  • Liaise with the development teams during system testing phases of the project to identify
    and work to resolve defects
  • Liaise with business analysts and key stake holders during user acceptance testing phases
    of a project to ensure that deliverables are meeting set business requirements and
    working to achieve this if not contribute to the definition and implement testing practices for the BI
  • Make defect prioritisation decisions based upon considering both technical merit and
    business value
  • Ensure that standardised testing processes are in place and followed
  • Analytics mind-set skills with the ability to turn a business question/problem into a delivery plan
  • Demonstrate an understanding of key business processes and needs and ensure solutions
    are developed to support these requirements

Qualifications and Educational Requirements
Degree in a computer science or related discipline

  • Specialist Skills and Experience Required
  • Previous experience of testing large scale BI solutions integrating with 20+ source and
  • target systems
  • Experience of testing complex data warehouse ETL processes
  • Experience with automated testing tools
  • Understanding of Dimensional data modeling
  • SQL competency across multiple database technologies (SQL Server, Oracle Informix)
  • Experience of collaborating with third-party development
  • A good understanding of the BI development lifecycle
  • An understanding of the industry standard best practice testing principles
  • Experience of working within an Agile framework
  • Excellent problem-solving skills
  • Strong communication skills

Back to vacancies Apply for this job