IT Internet and Technology
RecruitGibraltar are currently helping our client who is a long established and reputable gaming company who offer long term career growth, excellent salary, relocation assistance, and a rewarding working environment where you can make a real impact. They are searching for a BI Tester to be responsible for the Testing, accuracy and quality assurance of technical solutions to support reporting, data mining and analytics.
What is the plan for the BI Tester role?
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 brands 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 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.
What will you do as a BI Tester?
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. 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 be 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
What do you know that makes you a great BI Tester?
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 modelling
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
Manage your own time effectively, plan ahead and adopt a methodical approach to your work
Salary £35k - £40k based on experience with bonus, an excellent relocation package and private healthcare.