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