Data Engineer

Data Engineer

Location:
Guernsey, Haywards Heath, Home Office (Remote) or Manchester
Salary:
up to £55,000 plus excellent benefits package
Department:
Technology and Data
Apply for this job

We’re First Central Insurance & Technology Group (First Central for short), an award-winning innovative insurance and technology organisation, delivering market-leading motor insurance, underwriting, distribution, finance, technology and legal services.
 

We currently have an exciting opportunity for a Data Engineer to join our Technology and Data Team in either Salford Quays, Manchester or Haywards Heath, West Sussex.

This is a hands-on technical role where you’ll be providing technical data solution build on projects and for persistent data products.  The role will involve taking responsibility for designing and implementing data pipelines and database population, ensuring alignment of data solutions to the technical design and overall data platform patterns.

To be successful in this role, you’ll need:

  • A grounding in data principals and technology, preferably cloud.
  • A passion for data.
  • Experience of designing and building end to end data solutions.
  • Engineering and database skills in SQL Server and/or Azure (Datafactory, Synapse) and the associated ETL technologies.
  • Experience of developing in an agile environment.

Job responsibilities:

  • Develop low to high complexity, secure, governed, high quality, efficient data pipelines from a variety of on and off premise, internal and external data sources
  • Ensure that data is cleansed, mapped, transformed and optimised for storage to meet requirements for business and technical use cases.
  • Build data observability and data quality by design into all Data pipelines, promoting self-testing pipelines that proactively identify processing issues or discrepancies.
  • Build solutions that pipe transform data into data lake storage areas, physical database models and reporting structures across data lake, data warehouse, business intelligence systems and analytics applications.
  • Build physical data models that are appropriately designed to meet business needs and optimise storage requirements, ensuring maximum re-use.
  • Carry out unit testing of own code, and peer testing of others code to ensure appropriate quality
  • Maintain effective, and appropriate documentation that brings transparency and understandability to pipelines created and code created.
  • Follow coding standards, architectural principles, solution design/architecture and release management processes to ensure safe, high quality, compliant code.
  • Coach and mentor Associate data engineers.
  • Create low to high complexity BI solutions including data mart, semantic layer, and reporting & visualisation solutions in recognised BI tools such as PowerBI.
  • Any other reasonable duties.

Job-specific competencies

Experience & knowledge

  • Requires experience of designing and building end to end data solutions (2-5 years).
  • Engineering and database skills in SQL Server and/or Azure (Datafactory, Synapse) and the associated ETL technologies.
  • Experience of working with large, event based, datasets in an enterprise environment.
  • Experience of testing techniques and tools.
  • Proven to be an excellent communicator with an desire to build rapport with others.
  • Keen and active interest in the use of data, with active external networks.
  • Brings ideas on how data can drive value for businesses.
  • Good understanding of the full data lifecycle.
  • Experience of Continuous Integration / Continuous Delivery (CI/CD).
  • Experience of working in an agile environment and self-managing teams.

Skills & Qualifications

  • An excellent creative problem solver.
  • Proactive and optimistic about what can be achieved.
  • Very good time management and organisation skills with the ability to prioritise multiple demands.
  • Supporting and enthusiastic team player focussed on delivering shared outcomes.
  • Comfortable advising and supporting less experienced engineers.
  • Energetic and proactive, and someone who motivates others by their “can do, will do” attitude.
  • Able to follow, and make recommendations to improve, standards and designs, ensuring their work is of high quality

What can we do for you?


We believe we can offer you a great working environment as we’re so passionate about our people. Here are just some of the benefits and perks that we offer…

  • Fantastic training and development opportunities
  • Employee benefit packages to suit your lifestyle
  • Flexible working
  • YOUday – we give you an extra day off to celebrate a special day
  • The opportunity to take a paid day off each year to do charity work
  • A health cash plan
  • Help with travel expenses
  • The opportunity to buy additional holiday
  • Company pension scheme
  • Group life assurance
  • Enhanced maternity and paternity pay
  • Professional subscription fees paid

Employee wellbeing is high on the agenda here too. We provide a weekly free fruit delivery, discounted membership at a local health club and access to an Employee Assistance Programme, which promotes physical and emotional wellbeing at work and at home. In addition, we provide wellbeing events throughout the year to support physical and mental health.

For further information on what we can offer and to learn more about this role, feel free to contact our dedicated Recruitment team.

View more about our Benefits

Apply for this job

glassdoor

86% of people would recommend a friend to work at First Central

Based on 164 Glassdoor reviews (March 2022)

Benefits

View all benefits >

Flexible working

We support colleagues who wish to work flexibly whilst meeting the needs of the business.

YOUday

If it’s your birthday or you just fancy some me-time, get an extra day off for whatever you want.

Holiday Extra

We give you two opportunities each year to buy or sell up to five days of holiday.

Volunteering

Get a day off each year to take part in volunteering activities.

Health cash plan

Claim money back on your healthcare costs, such as dental check-ups and eye tests.

Season ticket loan

We provide interest-free loans to cover the cost of season tickets for rail, bus or car parking.