Jump to main content
Back to results

BI/ETL Developer

Direct Line House, LS1 8HZ
Full time

About us

Direct Line Group is an ambitious company employing thousands of people throughout the UK. We’re proud to be one of Britain's leading general insurers, offering millions of customers decades of experience and knowledge. In the history of modern insurance, there has never been a bigger time for change than now and we work hard to make sure our well known brands –Direct Line, Churchill, Privilege, NIG and Green Flag are making insurance easier and better value for our customers. We know we can’t do this without our brilliant people who we reward for ideas and thinking as well as results because that’s how we can achieve amazing things – for our customers and for each other.

What we are looking for

We are looking for someone with significant technical expertise to support modifications for several large projects such as GDPR compliance or SAS 9.2 to SAS 9.4 GRID migration. You will be responsible for analysing, developing and testing SAS Data Integration Studio ETL in a large and complex SAS 9.2 Estate with a wide-ranging set of purposes from data feeds, core warehouse builds and MI reporting.

Who you’ll be working with

The role sits within our central Data Team and the team integrates the business and information technology resources to strengthen DLG's response to rapidly developing reporting requirements, it provides the structure to improve the service delivery to the Business Intelligence user community. You'll also be collaborating with Data Team teams to resolve queries and provide help to other team members to deal with complex queries from customers where appropriate.

What you’ll be doing

  • Adopt efficient ETL design and development principles to "Extract, Transform and Load" data in-line with best practice and DLG framework standards.
  • You'll Analyse existing jobs, code and associated mechanism to establish a suitable migration approach
  • Create necessary code and data integration jobs to process large volumes of complex data
  • Perform unit testing, system testing and UAT
  • Design MI layout in conjunction with business analysts and business partners
  • Drive the continuous improvement of the standard design framework and data architecture principles
  • Support the “support services” team to produce and maintain training/user guides, data dictionary and report libraries
  • Collaborate with Data Team teams to resolve queries and provide help to other team members to deal with complex queries
  • Provide assistance to other areas of the Data Team as required

Key Skills

  • SAS Base/Macro
  • SAS 9.1, 9.2 - DI Studio 4.2 \ SAS Enterprise Guide 4.3
  • SAS 9.4 GRID ETL Development
  • UNIX / Shell Scripting

What we’ll give you

Come join us and you’ll find yourself at the core of one of the most on-the-go teams in the business. We’re always encouraging internal development and you’ll have access to loads of learning opportunities, events and conferences to build your industry knowledge.

Direct Line Group are an equal opportunity employer who value diversity. We do not discriminate and we recognise and embrace that people work in different ways. We will always adapt so you have the best and most comfortable working environment. If during the recruitment process you require any reasonable adjustments, please just let us know.

Career benefits and rewards

Rewarding you is really important to us, as well as offering a competitive salary and generous holiday entitlement; you can take advantage of a wide range of benefits. The best part is you can pick and choose the benefits to suit your own lifestyle, but also pass on some of the savings to family and friends. Here are just a few we have on offer:

  • A competitive salary, benchmarked against our competitors, which will grow as you do.
  • Pension 9% of your base salary, you can choose to contribute less or more than this, and anything you don’t wish to put in to your pension you can take as cash instead!
  • Private medical insurance (anyone can choose this through our flexible benefits scheme, and managers receive this as standard)
  • Attractive holiday entitlement
  • 50% off our Home, Motor and Pet insurance
  • Free Travel insurance
  • Free Green Flag breakdown cover
  • Flexible rewards including Life insurance, income protection, critical illness insurance, personal accident insurance
  • Retail card, with discounts at big name retailers
  • My Discounts - a discounts website for all our employees, with great discounts, cash back savings and offers across hundreds of brilliant  high street brands, travel, tickets, gym memberships and much more.

Who we are
Direct Line Group is an organisation with a clear mission: to make insurance much easier and better value for customers. We are one of the leading motor, home and small business insurers in the UK. We are home to some of the nation's best-known brands, including Direct Line, Churchill, Privilege, Green Flag and NIG.

Life at Direct Line Group

We recommend that you read our colleagues’ stories and ask them a question on our live discussion platform www.directlinegroupcareers.com/ask-our-people. This will help you learn more about us and be better prepared for interviews.