Associate Data Engineer (Bordereaux)

Join to apply for the Associate Data Engineer (Bordereaux) role at Jensten.

• 
  
• Develop and maintain bordereaux reporting solutions that transform raw data from various systems into standardized formats.
  
• Process and validate bordereaux files (premium and risk data) to ensure accuracy, completeness, and compliance with business requirements.
  
• Assist the wider data engineering team with bug fixes, enhancements, and maintenance of our internal data platform.
  
• Support the development of ETL pipelines using Azure Data Factory and Fabric Data Pipelines.
  
• Maintain existing centralised report generation procedures to ensure all data reported comes from a single source of truth.
  
• Reconcile processed data against internal systems to identify and resolve discrepancies
  
• Map and transform data from SQL databases into standardized templates, ensuring that data is accurate and aligns with the insurer's requirements.
  
• Work closely with underwriting and finance teams to understand bordereaux reporting requirements and ensure that data is processed in a way that supports operational and regulatory needs.
  
• Support the production of accurate and timely bordereaux reports for internal stakeholders and regulatory authorities
  
• Ensure that bordereaux processing meets regulatory standards (e.g. GDPR).
  

• 
  
• Experience in data processing, ETL development, or Insurance bordereaux management
  
• Hands‑on experience in the Insurance industry, particularly in handling premium (desirable)
  
• Experience in using T‑SQL and SQL Server
  
• Experience with Azure, Fabric, Power BI & Excel (desirable)
  
• Experience with SSRS (desirable)
  
• Strong attention to detail, particularly in ensuring data accuracy and consistency during transformations.
  
• Analytical mindset with the ability to troubleshoot data discrepancies and resolve complex data issues.
  
• Strong written and verbal communication skills, with the ability to work closely with both technical and non-technical stakeholders.
  
• Experience working in cross‑functional teams, including business analysts, underwriters, and IT.
  

• 
  
• Competitive salary with an annual pay review and bonus scheme.
  
• 27 days annual leave (includes a day off for your birthday and another for a religious holiday of your choice) + bank holidays
  
• Auto enrolment into our excellent pension scheme (5% employer matched contribution)
  
• Flex‑benefits – a range of flexible benefits to choose from, that are most important to you
  
• Group Life Assurance cover – a massive X4 of salary
  
• 3 months Maternity, Paternity & Adoption leave all fully paid
  
• Professional qualification study support relevant to your role and career
  
• Perks at work – amazing discounts on cinema tickets, meals out, luxury items etc.
  
• Holiday purchase scheme – up to 5 days annually
  

Launched in 2018, Jensten is one of the UK's largest independent broking groups. Growing organically and through strategic acquisition we now place over £650m GWP into the market via retail insurance broking, Lloyd's and London Market broking, and specialist underwriting arms. We fill the void in the market between a consolidator and a provincial broker. We have the scale, ambition and expertise to stand out, but the people, culture and entrepreneurial DNA to maintain our client focus. Which is why we are not just one of the leading independent broking groups, we are one of the most exciting too. Our goal is to have people in our Group that enjoy being part of one team with the shared commitment to delivering insurance distribution excellence. A big part of how we do this is by listening and then acting on what we hear. Our EVP work is key to maintaining and enhancing our culture and making Jensten Group a fantastic place to work, learn and grow.