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 recommend 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 join the team that deliver BI to various lines of Royal London business.

The purpose of this role is to design, develop, test and implement efficient BI solutions that meet business and customer requirements.  The team is a specialist team with accountabilities to deliver to a number of lines of business via a prioritised backlog, working closely with the business and testers.   

What will you be doing

• Developing complex solutions within own area of technical expertise.
• 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.
• 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.
• Ability to communicate clearly, manage expectations and work effectively with a variety of stakeholders.
• Delivering solutions to business users using below processes & methodologies:
  • ETL and Data Integratin
  • Master Data Management
  • Data Warehusing
  • Business Intelligence

Skills that will 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

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.