Data Engineer - (Synapse)

Data Engineer - (Synapse)

Location:
Haywards Heath or Manchester
Salary:
Department:
Technology and Data
Apply for this job

Job Purpose:          

Working with Data Engineering, Business Services and Technical partners to create and integrate Azure Data Engineering pipelines transforming core systems data into knowledge. 

The successful Azure Data Engineer will be a self-starter with a very strong background in Azure, looking to build on their extensive Synapse & Data Factory skills and experience in a dynamic and demanding team environment. 
  
This is an excellent opportunity to join an organisation that highly values its data and its people. The role offers flexibility around remote working.  

Job Responsibilities:

  • Working with other members of the Data Engineering team, you will actively participate in the design and development of processes and technologies that support secure and efficient data ETL, connecting to a variety of on- and off- premise data sources
  • Ensure data is cleansed, mapped, transformed and otherwise optimised for storage, and to meet requirements for business and technical use cases
  • Apply business and logic rules to derive insight from company data, and deliver these in real-time to the quote ratings engine
  • Generate and schedule data enrichment processes
  • Work closely with the Scrum Master to understand business requirements of items in the backlog, and translate those into technical deliverables
  • Develop effective, scalable solutions that can be efficiently tested, deployed, updated, maintained and managed
  • Load transformed data into storage and reporting structures in destinations including data warehouse, high speed indexes, real-time reporting systems and analytics applications
  • Support relationships with the other areas of FCG to ensure that requirements can be developed
  • Ensure solutions support the architectural direction of FCG technology and use approved technical components
  • Work to the agreed prioritisation of requirements for development and to the agreed delivery dates against these requirements
  • Assists in the identification of root causes and fixes for major incidents where required

Qualifications / Experience: 

Core Competencies 

  • Experience working in an Agile environment
  • Expert in Synapse and Azure Data Factory
  • Advanced SQL coding skills
  • Microsoft best practices working with
    • Azure Data Lake (Gen 1 and 2)
    • Azure Analysis Services
    • Azure SQL Data Warehouse (Synapse Analytics)
    • Azure Data Factory
  • A minimum of two years’ experience in Data Engineering
  • Experience of working with large data sets in an enterprise environment
  • Create and populate staging areas and data pipelines to perform a range of transformations
  • Microsoft best practices working with Azure
  • Strong data modelling skills
  • Logical and physical model design and implementation
  • Problem solver and solution finder

Desirable Competencies 

  • A Computer Science, Software Engineering, or related degree 
  • Microsoft Certified qualifications 
  • An understanding of software development lifecycle 
  • Understanding of the retail Insurance business  
  • Experience of testing tools and performance monitoring
  • Appreciation of Data reporting and visualisation using Power BI
  • Experience working in a regulated environment
  • Understanding of the retail Insurance business

Behaviours

  • An organised and pro-active approach
  • A flexible approach and positive attitude
  • Emphasis on attention to detail and accuracy
  • Strives to drive business improvements to contribute to the success of the business
  • Embrace, embed and incorporate the company values

Apply for this job

glassdoor

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

Based on 98 Glassdoor reviews (July 2020)

Benefits

View all benefits >

Flexible working

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

YOUday

We give you an extra day off to celebrate a special day.

Holiday Extra

Not only do you get a generous holiday entitlement, you can also buy additional leave.

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.