We’re First Central Insurance & Technology Group (First Central for short), an innovative, market-leading insurance company. We protect the things customers love so they can get on with what matters to them in life.
Data drives us. It fuels our outstanding distribution, finance, technology and legal services. Our underwriting skills are built on data expertise; it creates the insights we need to give the right cover to the right customers at the right price. But, it’s the people inside and outside our business that power us. They make us stand out, help us succeed. We’re ambitious. We’re growing. We’ve won awards.
Fancy a new career in a fast-paced and dynamic workplace? If so, this could be your lucky day! We’re looking for a Data Engineers to join our technology and data teams.
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.
Could you fit the bill? We're big on working flexibly - you'll spend most of your time working from home, with the occasional visit to the office, but of course, it’s your choice - if you prefer to be in the office more - that's good with us too. We've offices located in Haywards Heath, West Sussex, Salford Quays, Manchester, and Guernsey it’s your choice - or maybe you live further afield, we will accept applications for remote workers!
You’ll be the perfect person for us if:
- You’re an excellent PySpark and SQL developer who is keen to further your data engineering career.
- You enjoy the daily opportunity of delivering data from source to consumption using Azure best practice.
- You thrive on turning customer requests into actionable designs and delivery.
- You love working in an agile team.
- You want the opportunity to showcase your talents.
Making it happen. Together
What's involved:
- 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.
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
- 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.
This is just the start. Imagine where you could end up! The journey’s yours.
What can we do for you?
People first. Always. We’re passionate about our colleagues and know the best people deserve an extraordinary working environment. We owe it to them so that’s what we offer. Our workplaces are energetic, inspirational, supportive. To get a taste of the advantages you’ll 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 we’re offering, so feel free to get in touch.
