Data Engineer

We’re now looking for a motivated & experienced Data Engineer to join the Jensten Group, based from our Oldham office (we will also consider remote working for the right person). The main purpose of the role is to play a pivotal role in designing, building, and maintaining scalable data solutions to support business intelligence, analytics, and reporting needs. This position requires expertise in Azure/Microsoft data stack, database management, data transformation processes, and modern development practices, with a focus on enabling robust and efficient data-driven decision-making.

Reporting to the BI Analyst, you’ll work closely with the wider data and technology team, as well as other stakeholders to ensure data is collected, stored and processed in line with business needs. Some key objectives & responsibilities will include:

• Data Pipeline Development: Improve and maintain existing SSIS data flows, and work towards implementation of Azure Data Factory pipelines to replace existing SSIS architecture.
• Data Modelling & Transformation: Leverage T-SQL and SSIS to manage and transform data, ensuring high-quality outputs, as well as assisting our Data Analysts with Azure Analysis Services models and implementation of new Fabric models.
• Database Management: Maintain, improve, & optimise the existing SQL Databases hosted on our VMs and in Azure, and assist in implementation of OneLake with medallion architecture.
• Reporting & Visualization: Collaborate with business teams and our analysts to deliver insightful and actionable dashboards and reports using Power BI and SSRS.
• Development & Source Control: Leverage DevOps practices to streamline deployments, monitor pipelines, & maintain operational efficiency, and use Git source control to manage code repositories, enforce versioning, and support collaborative development workflows.
• Collaboration & Strategy: Work closely with stakeholders to understand business objectives and translate them into technical solutions, and also partner with cross-functional teams to establish data architecture best practices and maintain a cohesive data strategy.

As our Data Engineer, you’ll have a strong teamwork ethic, communication, and collaborative skills with a keen eye for detail. Also having strong technical skills, you’ll work closely with other IT professionals, management, and various stakeholders within the Group. You’ll also be or have:

• Experience in data engineering or a similar role.
• Extensive experience with T-SQL, SSIS, and SQL Server.
• Experience using DevOps and Git.
• Proficient with Analysis Services (ideally in Azure).
• Experience with Azure Data Factory.
• Exposure to Data Lake architecture and/or OneLake.
• Knowledge of the component parts of the Fabric stack.
• Strong analytical and problem solving mentality.
• Clear communication skills and the ability to work independently.
• Detail-oriented with a commitment to delivering high-quality work.
• Collaborative mindset with the ability to work effectively in a team environment.
• Adaptable and eager to learn new tools and technologies.

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.

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.

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.