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

    Add to favorites
    Remove from favorites
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form