Senior Test Analyst (Business Intelligence)

Royal London Group

Edinburgh, GB

39d ago

Royal London is the largest mutual life, pensions and investment company in the UK, with Group funds under management of £114 billion and latest ProfitShare pay out to members of £142 million.

Group businesses provide around 9.0 million policies and employ 3,669 people. (Figures quoted are as at 10 May 2018).

Founded as a Friendly Society in a London coffee shop in 1861, Royal London started out with the aim to help people avoid the stigma of a pauper’s grave.

Since then we have been helping people help themselves and are committed to delivering the best value for customers and putting members first.

We have an exciting Permanent opportunity for a Business Intelligence Test Analyst to join the Group Technology Change Team in Edinburgh.

The successful candidate will be responsible for testing of new or changing functionality for a variety of BI systems. You will take ownership of the negotiation of test coverage for BI with the business and project manager, being accountable for the execution of tests within agreed timescales.

Working within a test team pool you will be an integrated member of a designated project team. This could be aligned to : Mandatory, Regulatory, Service Support or Strategic Project related work.

Technical skills :

TSQL (Microsoft SQL Server) query writing knowledge (Simple and complex queries), Understanding SQL and TSQL stored procedure and execute them Mandatory

SQL Server Management Studio 2012 (Currently we are using this version) Mandatory

SSIS (SQL Server Integration Services) Highly desirable

SSRS (SQL Server Reporting Services) Highly desirable

Visual Studio 2015 (Currently we are using this version) Good to have this knowledge as this is required to check the ETL package control flow and debug as required.

Also there are possibilities where each component of SSIS Packages are required to test.

Microsoft Test Manager 2015 (Currently we are using this version) This is the tools we are using for test management (Test plan, test execution, bug management etc.

Having exposure on any other tools would be enough as MTM is not that difficult to learn.

TFS knowledge

Experience & Skills Required :

ETL / Business Intelligence / Enterprise Data Warehouse Testing experience

Writing test plan, test cases and execute them

Writing TSQL queries, understanding stored procedures and execute them

Create test completion report and have working knowledge on bug closure process

Understanding Requirement Specification, technical specification, mapping document and write test cases accordingly

Testing experience on ETL transformations, CDC (Incremental Load)

System testing, regression testing experience

Experience in Agile methodology

Testing experience in SSIS packages

Testing experience in SSRS reports

Experience in managing a team and mentor / guide new resources

Royal London is an equal opportunities employer. We work hard to attract the best talent for our award-winning team. We believe that embracing difference makes us stronger.

Our diverse people bring us different skills whatever their educational background, disability, gender, age, sexual orientation, race, religion or belief.

We will consider flexible working arrangements for all our roles. We also welcome applications from individuals who have taken an extended career break.

To apply, please use the Apply Online’ link below

Apply

Add to favorites

Remove from favorites