Senior BI Developer

Senior BI Developer

Edinburgh

Permanent Contract

 At Royal London we want to attract the best talent to help us achieve our vision of becoming the most trusted and recommended financial company in the UK.

We are the largest mutual life, pensions and Investment Company in the UK, with Group funds under management of £118.9 billion and latest Profit Share pay out to members of £142 million.  Group businesses provide around 9.0 million policies and employ 3,976 people (figures as of 05 Feb 2019). 

We have an exciting permanent role for a talented Senior Software Developer to join the specialist Business Intelligence team in Edinburgh. The role represents an opportunity to join a Business Intelligence function that is continually evolving and developing a larger role in supporting Royal London’s mission to achieve their vision.

The purpose of this role is to design, develop, test and implement efficient BI solutions that meet business and customer requirements.  The team delivers BI and BI solutions to a number of different business areas within Royal London, via a prioritised backlog, working closely with the business and testers.   

 What you will be doing

• Developing complex solutions using Microsoft’s BI toolset.
• Carrying out impact assessments of complex changes to existing applications.
• Documenting and agreeing design in advance and to agreed standards.
• Ensuring all code meets Group standards, guidelines and quality gates for given technology.
• Ensuring all code is thoroughly tested to ensure any issues are identified as early as possible, working closely with the test team.
• Safely implementing solutions to production environments.
• Providing support for BI software items running on the production environment (not overnight).
• Collaborating closely with other members of the team.
• Contributing to software development practice by sharing ideas and experience.
• Reviewing the work of colleagues with best practice in mind.

 What we’re looking for

• Proficient in technical skills including SQL Server, SQL Server Integration Service, SQL Server Reporting Service.
• Extensive experience in developing SSIS package and maintaining Stored Procedure and SSRS Reports.
• Delivering solutions to business users using below processes & methodologies:
  • ETL and Data Integrating
  • Master Data Management
  • Data Warehousing
  • Business Intelligence

 Skills that may help you in the role

• Visual Studio, Team Foundation Server, Agile, Tableau
• Have experience in building Cubes from an existing Data Source using SQL Server Analysis Service
• Ability to communicate clearly, manage expectations and work effectively with a variety of stakeholders.

What we offer

• We've always been proud to reward employees by offering a number of benefits such as Pensions and Protection, Performance and role-related benefits, Lifestyle and Wellbeing 
• Our culture comes from within, or to put it another way, it comes from our people. It’s what makes Royal London a great place to work.
• Our People Promise is something we live up to every day. We know we can rely on you, and you can expect plenty from us in return.
• Glassdoor have ranked as among the best places to work and this year we entered the top 10 

We are 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.