BI & Analytics Tester - SQL / ETL
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 lifecycle 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.