Job Description

You'll 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.

You'll ensure that data is cleansed, mapped, transformed and optimised for storage to meet requirements for business and technical use cases.

You'll build data observability and data quality by design into all data pipelines, promoting self-testing pipelines that proactively identify processing issues or discrepancies.

You'll 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.

You'll build physical data models that are appropriately designed to meet business needs and optimise storage requirements, ensuring maximum re-use.

You'll carry out unit testing of your own code to ensure appropriate quality.

You'll maintain effective documentation that brings transparency and understandability to pipelines and code created.

You'll follow coding standards, architectural principles, solution design/architecture, and release management processes to ensure safe, high-quality, compliant code.

You'll create low to mid complexity BI solutions including data marts, semantic layers, and reporting & visualisation solutions in recognised BI tools such as Power BI.

Are you passionate about data? Do you have experience in Python, VBA, SQL or similar? In this hands-on technical role, you'll be at the heart of building innovative data solutions, contributing to impactful projects and long-term data products. You'll transform well-defined work packages into powerful data pipelines and robust database solutions that drive value. You'll apply technical problem-solving skills, good data management discipline, and demonstrate curiosity and eagerness to learn new data technologies and techniques.

We promote flexibility: most work from home with occasional office visits. Our offices are in Haywards Heath, West Sussex, Salford Quays, Manchester, and Guernsey, or remote within the UK or Guernsey.

Core Skills

• Hands-on experience in Python, VBA, SQL or similar.
• Creative problem solver with fresh thinking.
• Proactive learner with a genuine curiosity for data technologies.
• Strong time management and organisational skills.
• Team player focused on shared outcomes.
• Resilient under pressure.
• Energetic with a positive attitude.
• High-quality, standards-compliant work with attention to detail.

Additional Requirements

• Good communicator and rapport builder.
• Ability to learn and adopt new technologies.
• Interest in data and understanding of how data drives business value.
• Knowledge of the data lifecycle and CI/CD practices.

People first. We offer an energetic, supportive, and inspirational workplace. We are 1st Central, a market-leading insurance company recognized for our growth, customer focus, and awards, including Insurance Employer of the Year 2024.