Senior Microsoft Data Engineer

Who we are in a nutshell.

At BES Group, we pride ourselves in being the leading end to end risk management solutions provider in the UK and Ireland.  That means it’s our job to help keep our customers assets’ legally compliant, operational and, above all else, safe.  And we do this with a team of the very best people, simple.

We have a relatively small IS team dedicated to making a significant impact on our technology organization and landscape. This team collaborates to manage data, software engineering, support and administration, CRM, cloud-based services, and more to support BES Group’s continual growth

What will you be doing?

As a Senior Microsoft Data Engineer for BES Group, you will own the development and implementation of data and reporting solutions using the latest Microsoft technologies: SQL Server Integration Services Azure Synapse Analytics, Azure Analysis Services, Azure Data Lake, Azure SQL Database, Azure Data Factory and Power BI (both dashboards and paginated reports)

You will:

Work with other members of the team or directly with our business users to understand and document business requirements, evaluate options, research, and propose suitable solutions.

Use your stakeholder management skills to translate business requirements into design specifications.

You will ensure that all work is carried through the environments, source controlled with regularity and that deployment packages are robust and well organised. Ensuring all conflicts in this area are merged/escalated effectively whilst supporting the development and enhancement of our CI/CD pipelines.

You will take an active role in ensuring the highest quality of our processes and the data we provide, working with system and business owners to ensure a proactive approach supporting data governance as well as establishing best practice guidelines for code management and deployment between cloud MI environments

As part of our team, you will get:

A salary up to £75,000, depending on experience

Up to 10% pension contribution

2 x life cover

Enhanced maternity / adoption leave

Annual salary review

25 days annual leave plus 8 bank holidays

An additional day’s holiday for your birthday every year

Access to our buy and sell holiday scheme

Opportunity for flexible working

Electric Vehicle salary sacrifice scheme 

Discounts and savings via our employee benefits portal

Health and wellbeing support via our Employee Assistance Programme

Company wide volunteering scheme

Fundraising support for your chosen charity

We want you to be you

Our focus on diversity, equality and inclusion is here to stay. 

Our team is made up of some of the most skilled and talented people and that’s what matters to us.  At BES Group, we want our people to know that they can be their true authentic selves at work, it really is that simple.

What’s more, we’re a Real Living Wage employer across our complete business and we are delighted to have pledged our committed to the military community by signing the Armed Forces Covenant.

To join our team, you will need: 

Having delivered a modern data platform using relevant technologies and services in Microsoft Azure.

Expert in T-SQL including stored procedures, temp tables & CTE’s with performance tuning.

Proficient in the development of SQL Server Integration Services (SSIS) solutions and Azure Data Factory

Demonstrable experience in the use of GIT for CI/CD source control in azure across key areas of the stack

Proficient in developing and deploying Azure Analysis Services Models

Proficient in developing cascading, parameterized reports using SQL Server Reporting Services.

Report development of datasets and reporting in Microsoft Power BI

Ideally experience of using Data Bricks or Azure Synapse

Strong understanding of data modelling concepts

Experience of interpreting and analysing complex data

Knowledge and a proven track record in data / data quality management

Code management & deployment tools

Experience of Microsoft Dynamics CRM

Proficient in debugging, monitoring, tuning and troubleshooting BI solutions.

Ability to work in a matrix environment

Go for it!  Research suggests that some people tend to only apply for roles if they meet all requirements. If you don't meet every point above, but still feel like you could really help make a difference in this role, please apply, you might be exactly what we’re looking for.

To apply for this role, simply click “Apply”.   We ask for some basic contact information and a CV or your LinkedIn profile, it’s that easy!  Please note, successful candidates will be required to complete the relevant background checks as part of the recruitment process. 

BES Group, where our people and our customers come before everything else