Associate Data Engineer

First Central Services UK; Manchester; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

A leading insurance firm in Manchester is looking for an Associate Data Engineer to develop data solutions and pipelines. The ideal candidate will have experience in Python, VBA, and SQL, along with strong problem-solving and time management skills. This role offers flexibility, allowing remote work within the UK, and provides a supportive workplace culture.

Benefits

Supportive workplace culture

Flexible working arrangements

Opportunities for learning and development

Qualifications

• Hands-on experience in Python, VBA, SQL, or a similar coding language.
• Strong time management and organisational skills.
• Creative problem solver who enjoys tackling challenges.

Responsibilities

• Develop data pipelines from various data sources.
• Ensure data is cleansed, mapped, and transformed for use.
• Maintain effective documentation for data pipelines.

Skills

Python

VBA

SQL

Creative problem solving

Time management

Team collaboration

Attention to detail

Tools

Power BI

Apache Hive

AWS

Hadoop

Redshift

Job description

Were 1st Central a market-leading insurance company utilising smart data and technology at pace. Rapid growth has been based on giving our 1.4 million customers exactly what they want : great value insurance with an excellent service. And thats the same for our colleagues too; we won Insurance Employer of the Year at the British Insurance Awards 2024 and our Glassdoor score is pretty mega too!

Are you passionate about data Do you have experience in Python VBA SQL or a similar coding language

Weve got an amazing opportunity for an aspiring data enthusiast to join us as an Associate Data Engineer come be part of something great!

In this hands-on technical role youll be at the heart of building innovative data solutionscontributing to impactful projects and long-term data products. Youll take well-defined work packages and transform them into powerful data pipelines and robust database solutions that drive real value. Youll apply technical problem-solving skills and good data management discipline to any tasks or work packages allocated and will demonstrate a natural curiosity and hunger to learn new data technologies and techniques.

Were big on flexibility - youllspend most of your time working from home with the occasional visit to the office but of courseitsyour choice - if you prefer to be in the office more -thats good with us offices located in Haywards HeathWest Sussex Salford Quays Manchester and Guernsey its your choice - or maybe you live further afield well accept applications for remote workers who are based in the UK or Guernsey.

Core skills were looking for to succeed in the role :

T echnical Skills :

Youll have hands-on experience in Python VBA SQL or a similar coding language.

Creative Problem Solving :

Youre a creative problem solver who enjoys tackling challenges with fresh thinking.

Proactive Learning :

Youre proactive with a genuine thirst for learning and self-improvement.

Time Management & Organisation :

Youll have strong time management and organisational skills to stay on top of priorities.

Team Collaboration :

You thrive in collaborative environments and enjoy working toward shared outcomes.

Resilience Under Pressure :

Youre resilient and perform effectively under pressure even in demanding situations.

Positive Energy & Motivation :

You bring energy and positivity motivating others with your can do will do attitude.

Quality-Focused Execution :

Youre able to follow standards and design carefully ensuring your work is consistently high quality.

Attention to Detail :

Youll have a keen eye for detail and take pride in precision.

Whats involved :

• Youll develop low to mid complexity secure governed high quality efficient data pipelines from a variety of on and off premise internal and external data sources.
• Youll ensure that data is cleansed mapped transformed and optimised for storage to meet requirements for business and technical use cases.
• Youll build data observability and data quality by design into all Data pipelines promoting self-testing pipelines that proactively identify processing issues or discrepancies.
• Youll 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.
• Youll build physical data models that are appropriately designed to meet business needs and optimise storage requirements ensuring maximum re-use.
• Youll carry out unit testing of own code to ensure appropriate quality.
• Youll maintain effective and appropriate documentation that brings transparency and understandability to pipelines created and code created.
• Youll follow coding standards architectural principles solution design / architecture and release management processes to ensure safe high quality compliant code.
• Youll create low to mid complexity BI solutions including data mart semantic layer and reporting & visualisation solutions in recognised BI tools such as Power Bi.

Experience & knowledge

• Proven to be a good communicator with an experience of building rapport with others.
• Experience of being able to learn and adopt new technologies.
• Some experience in Python VBA SQL or any other coding language.
• Keen and active interest in the use of data.
• Knowledge of how the use of data can drive value for businesses.
• Broad understanding of the data lifecycle.
• Aware of Continuous Integration / Continuous Delivery (CI / CD).

Skills

• A creative problem solver.
• Proactive and a thirst for learning.
• Very good time management and organisation skills.
• Must have the ability to work as part of a wider team focussed on shared outcomes.
• Resilient and comfortable able to work effectively in demanding situations.
• Energetic and proactive and someone who motivates others by their can do will do attitude.
• Able to follow standards and designs ensuring their work is of high quality.
• Attention to detail.

This is just the be beginning. Imagine where you could end up! The journeys yours to shape

What can we do for you

People first. Always. Were passionate about our colleagues and know the best people deserve an extraordinary working environment. We owe it to them so thats what we offer. Our workplaces are energetic inspirational supportive. To get a taste of the advantages youll enjoy take a look at all our perks in full here .

Intrigued Our Talent team can tell you everything you need to know about what we want and what were offering so feel free to get in touch.

Required Experience :

IC

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type :

Full-Time

Experience :

years

Vacancy :

1