Data Engineer

We are seeking a skilled Data Engineer to join our Data team at Clear Group. This role is crucial to driving the success of our Data Strategy, ensuring that our data infrastructure is robust, reliable, and scalable to support Clear's rapid growth and commitment to excellence. 

About You 

You are a technically skilled Data Engineer with expertise in building and optimising data pipelines, data warehousing, and working with advanced ETL/ELT frameworks. You have a deep understanding of data architecture and a commitment to enhancing data quality, and you excel at creating seamless, cost-effective data solutions. If you thrive in collaborative environments and enjoy translating data needs into technical solutions, you’ll be an ideal fit. 

Why Join Us? 

At the heart of our culture lies a commitment to protect, excel, and succeed together. Our culture is built on professionalism, resilience, respect, and a commitment to continuous growth. We foster an environment where everyone is empowered to thrive, working collectively to deliver success for our clients, colleagues, and communities. 

The Clear Group Experience 

Joining Clear Group means becoming part of an industry leading team that puts people first. We are committed to creating a work culture that values entrepreneurial spirit, adaptability, and even a bit of fun along the way. 

What you can expect: 

• Career Growth: Ample opportunities to advance within a leading insurance firm. 

• Flexibility: Work arrangements designed to support your work life balance, allowing you to excel in all areas. 

Whether you are an ideal fit or looking to forge your path, we welcome the diverse strengths each candidate brings. Your unique perspective strengthens our team, and we are excited to see the impact you’ll make alongside us. 

How you will make an impact 

As a Data Engineer, you will maintain and update our data pipelines and data warehouse, supporting Insight and Analytics with table creation, business logic, and stakeholder management. Working closely with the Head of Data, you will play a crucial role in enhancing data quality and building trust in our data platform, ensuring Clear’s data infrastructure is future ready. 

Key Responsibilities 

• Data Pipeline Development: Design, build, and maintain scalable ETL/ELT pipelines within Microsoft Fabric using tools like Azure Data Factory, Dataflows, Power Query, and Synapse Pipelines. 

• Data Modelling: Create high performance data models in Synapse and Power BI for effective reporting and analytics. 

• Data Integration: Consolidate diverse data sources into a unified data platform, applying Lakehouse architecture principles. 

• Data Transformation: Develop complex data transformations using SQL, PySpark, and other tools within Microsoft Fabric. 

• Collaboration: Partner with data analysts and business stakeholders to deliver technical solutions aligned with data requirements. 

• Performance Optimisation: Monitor and optimize data pipelines, queries, and storage layers for performance and cost efficiency. 

• Security and Compliance: Implement best practices for data security and ensure compliance with policies and regulations such as GDPR and HIPAA. 

Experience and Qualifications 

• Proficiency in Azure Data Factory, Power Query, Dataflows, and Synapse Pipelines. 

• Advanced understanding of data warehousing (e.g., star schema) and experience with data model design in Synapse and Power BI. 

• Skilled in SQL, Python, and PySpark for data transformation and querying. 

• Extensive ETL/ELT experience, including batch and streaming processes in Fabric tools. 

• Proven ability to optimise data pipelines, ETL jobs, and queries for efficiency and cost effectiveness. 

• Preferred knowledge of Azure Data Lake, Azure SQL Database, Synapse SQL pools, and Delta Lake. 

• Industry experience in insurance, particularly broking (preferred). 

• Bachelor's or master's degree in computer science, Information Technology, or a related field (preferred). 

Right to work  

• Candidates must have the legal right to work in the UK. 

Our Benefits 

Making it Clear – we know that great teams, exciting career opportunities, and a supportive work environment are key to your success. Alongside a competitive salary, we offer a comprehensive range of benefits designed to support your wellbeing, work life balance, and long term future. 

Below are the minimum core benefits you’ll get, depending on your job level these benefits may improve: 

Wellbeing Support: Our Wellbeing Hub provides access to physical and mental health resources, ensuring that you have the support you need. Additional support is available through Group Medical Insurance and our Employee Assistance Programme. You will also have access to gym membership discounts and an eye care scheme to support your overall health. 

Flexible Work Life Balance: We believe in a healthy work life balance, and our hybrid working model reflects this. While we value seeing you in the office, we offer the flexibility of working from home on other days. Additionally, we offer up to 27 days of annual leave, which increases with your length of service, and you have the option to purchase up to 3 extra days. Bank holidays are also included. 

Future Planning: We care about your future, which is why we offer a contributory pension scheme to help you plan for retirement. You’ll also benefit from Group Life Assurance and Group Income Protection, offering peace of mind in case of unforeseen circumstances. 

Reward Schemes: We value the people who help us grow, and that’s why we offer a talent referral scheme. If you introduce a successful candidate to Clear Group, you’ll receive a one off bonus when they complete their probation. We also offer a qualification bonus upon the successful completion and verification of certain qualifications, rewarding your continuous professional development. 

Volunteer Days: At Clear Group, we believe in giving back to the community. We offer volunteer days for you to spend time supporting a cause that’s important to you. This allows you to make a positive impact while balancing your work responsibilities. 

Equal Opportunities and Inclusion  

At Clear Group, Diversity, Equity, and Inclusion are at the heart of our values. We believe in fostering an environment where everyone feels a genuine sense of belonging, and we celebrate differences through inclusiveness. Our staff networks such as the Gender Equality Alliance, Female Alliance in Business, and Early Career Professionals play a pivotal role in making Clear Group a diverse, engaged, and inclusive workplace. 

We are actively expanding these networks to support even more perspectives and experiences. As we build our team, we warmly welcome the unique strengths each candidate brings from their background, education, and culture to their gender identity, language, veteran status, disability, and beliefs. We know that a team rich in diverse voices helps us all thrive, and we look forward to seeing how your experiences will contribute to our shared success. 

Join us at Clear Group and be part of a team that is dedicated to making a difference, shaping the future of our industry, and empowering every individual to thrive.