Skip to content


Bracknell, Berkshire - £50k - £55k per annum Permanent Posted: Wednesday, 14 August 2019

BI & Analytics Tester - SQL/ETL
£50,000 - £55,000

The Client:
My client are a financial planning and investment firm who are looking for an experienced BI & Analytics Tester with extensive SQL & ETL testing experience.

Job Purpose:
To support the organisation by thorough testing of business intelligence/DWH and reporting solutions developed by the BI & Analytics team.

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 channeled through the BI & Analytics team. It will also handle data migration and integration activities. This will allow Tilney to provide consistent and reconcilable data and this Business Intelligence specialist role is key to delivering this capability through thorough testing of in-house developed solutions.

Key Responsibilities:
- 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.
- 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.

Skills and Qualifications:
- 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.
- Skilled at manipulating data in Excel and working with large data sets
- Enthusiastic and motivated personality, working as 'Team Player' in the BI & Analytics team, with can do attitude
- Strong ability to extract information by questioning, active listening and interviewing
- Ability to quickly assimilate and understand business processes and information flow
- Experience in, and understanding of the project life cycle using Agile Scrum, and experience of JIRA task management system.
- To provide technical leadership in areas of expertise
- Highly numerate with strong analytical and problem solving skills
- Ability to work on own initiative within agreed boundaries
- Ability to work under pressure and manage conflicting priorities
- Be flexible and adaptable to meet business deliverables
- Willingness to travel to different office locations as required by the role
- An understanding of basic database principles and terminology
- Understanding of the principles of IT security and data protection

If you are interested in this opportunity, please apply now with your updated CV in word/PDF format.

Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.

Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally: Please see our website for our full diversity statement.

Bracknell, Berkshire, UK
£50k - £55k per annum
Square One Resources
David Lines 
14/08/2019 22:07:19

About Square One Resources

Established in 1995, Square One places IT and ERP specialists on an international scale with a belief in building long-term relationships with both candidates and clients. Based in London and Warsaw, and with over 120 employees, everything we do is determined by our desire to be independent, and we believe it's our culture that makes us successful in what we do.

Our core values (Accountable, Ambitious, Committed and Relentless) work to help us fulfil our mission statement, and make sure we do not compromise on quality along the way. We aim to create a high-performance culture, to promote an unrivalled recruitment service that ensures we establish and maintain long-term relationships in an ever-evolving, technology-driven world. This is the cornerstone of our business.

We are Square One.

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

See more