Associate Data Engineer

The role

We're now looking for a motivated & experienced Associate Data Engineer to join the Jensten Group. Based from our Oldham office (with hybrid working options, remote options also considered), you'll be working in our JenTech Division- in the Data & Insights team. Reporting to the Lead Data Engineer, the main purpose of the role is to be responsible for the development, management, and automation of bordereaux data processing and reporting systems. This role is critical in ensuring accurate and timely reporting of insurance data from brokers and underwriters to capacity providers. The ideal candidate will have experience in insurance data processing, data mapping, and transforming data from various formats into standardized templates for regulatory and operational reporting. Additional responsibilities include supporting the wider engineering team in the development and maintenance of our internal data platform built on the Microsoft Azure and Fabric stack. Some key objectives & responsibilities will include:

• 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

As our Associate Data Engineer, you'll have a strong teamwork ethic, communication, and collaborative skills with a keen eye for detail. You'll work closely with other IT professionals, management, and various stakeholders within the Group. There's plenty of scope for development with this role, as you'll gain specialised knowledge in insurance data processing and regulatory reporting. And career wise, there's the opportunity to grow into more senior roles such as Data/ Analytics Engineer, as you expand your skills in data automation and analysis. You'll be or have:

• 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

When you join us, you can expect a supportive culture and an attractive range of rewards and benefits which include:

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

And that is why you should join us

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.