Data Operations Engineer

Data Operations Engineer

Location:
Guernsey, Haywards Heath or Manchester
Salary:
up to £59,000 depending on level of experience
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 Operations Engineer to join our Technology and Data team in Salford Quays, Manchester, Haywards Heath, West Sussex, or our offices in Guernsey. 

With an evolving, ever-changing business model, this role will be pivotal in collaborating with Data Analysts, Data Scientists and other Data Consumers to gather and populate data warehouse table structure to support optimising the reporting function. You’ll be responsible for the day to day delivery and long-term strategy of the teams ensuring strategic change, and BAU change is delivered on time and cost, engaging with Development, Architecture, Data Change, IT Ops, Business teams and senior stakeholders. Leading in the areas of solutions design, code development, quality assurance, data modelling, business intelligence, cross-team communication, project management and application maintenance, you will have a real opportunity to make a difference and further enhance your skills.

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

  • Have solid experience/understanding of all elements of data engineering, including business intelligence.
  • Proven data warehousing, data management and analytics skills.
  • Extensive experience of working with Pyspark, Apache Spark or Python.
  • Advanced SQL coding skills.
  • Experience working with Microsoft best practices working with
    • Azure Data Lake (Gen 1 and 2)
    • Azure Analysis Services
    • Azure SQL Data Warehouse (Synapse Analytics)
    • Azure Data Factory
    • Databricks or similar Spark environment

Job responsibilities:

  • Support the Business and Data Analysts to design, develop and maintain data pipelines, data governance compliance, procedures and tooling to support data warehousing.
  • Define and promote the department’s best practices and design principles for data warehousing techniques and architecture.
  • Assist in the development of business intelligence, business data standards and processes.
  • Guide the business in identifying any new data needs and deliver mechanisms for acquiring and reporting such information as well as addressing the actual needs.
  • Create and support the data pipelines in order to facilitate the accommodation of data into the warehouse.
  • Experience in Synapse data mappings, external tables, schema creation from SSMS
  • Analyse all data from sources and develop logical models for various business intelligence sources.
  • Monitor all data integrity performance and adopt appropriate tools.
  • Coordinate with analytical team and collect all technical requirements.
  • Participate in designing system data models, data integrations and automated data management solutions.

Skills, knowledge & experience:

  • Solid experience/understanding of all elements of data engineering (extract/transform/load).
  • Business Intelligence experience with proven data warehousing, data management and analytics skills.
  • Demonstrable experience of delivering highly scalable data platforms
  • Experience gathering requirements and understanding the needs of diverse stakeholders.
  • Strong experience in SQL and Pyspark
  • Microsoft best practices working with
    • Azure Data Lake (Gen 1 and 2)
    • Azure Analysis Services
    • Azure SQL Data Warehouse (Synapse Analytics)
    • Azure Data Factory
    • Databricks or similar Spark environment
  • A minimum of two years' experience in Data Engineering using Python
  • Demonstrate a strong understanding of dimensional modelling as well as other data warehousing techniques.
  • Extensively familiar with ETL (Extraction, Transformation & Load), data warehousing and business intelligence tools.
  • Strong understanding of data system architectures including storage, compute (including analytics and machine learning).
  • Microsoft best practises working with Azure
  • Experience of working with large data sets in an enterprise environment
  • Experience working in an Agile environment
  • Proven time management and organisation skills (must be able to prioritise workload and meet deadlines.)
  • Insurance products, insurance distribution channels, claims handling, technology, data sources and databases and the wider motor insurance industry
  • Self-motivated and enthusiastic
  • Calm under pressure
  • Organised and pro-active
  • Takes initiative to make decisions

 

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.
 
If you’d like to work for an award-winning employer in a fast-paced environment, apply now!
 
Want to know what it’s really like to work at First Central? Take a look at our Glassdoor reviews.

View more about our Benefits

Apply for this job

glassdoor

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

Based on 150 Glassdoor reviews (October 2021)

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.