Associate Data Engineer (Bordereaux)

Jensten
Huntingdon
1 week ago
Create job alert

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


Responsibilities

  • 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).

About You

  • 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.

Rewards & Benefits

  • 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

About Us

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.


#J-18808-Ljbffr

Related Jobs

View all jobs

Associate Data Engineer

Associate Data Engineer: Python & SQL Pipelines

Bordereaux Data Engineer — Azure ETL & Reporting

Senior Data Engineer & Power BI Lead – Hybrid Manchester

Lead Data Engineer

Lead Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Science Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.