Data Engineer (Microsoft Stack)

• Proactive Project Delivery: Ownership of work packages from inception through to completion, ensuring design and quality standards are met, within agreed timescales.
• Hybrid Development: Assist in building and optimising robust data feeds from both established on-premises SQL Server environments and evolving cloud-based infrastructures.
• Cross-Functional Collaboration: Ability to liaise directly with project managers and business stakeholders to translate complex requirements into scalable solutions.
• Advanced Analytics & Visualisation: Build data models using star schema principles (Kimball methodology) and develop sophisticated Power BI dashboards to help shape business decisions.

We are an established software development house seeking a motivated, forward-thinking Data Engineer to join our experienced data engineering team.

This role requires a highly motivated individual with strong foundational knowledge who is keen to learn, innovate and go above and beyond to help drive our projects forward. Working alongside experienced senior professionals, you will be part of a team but also have the autonomy to contribute directly to the company’s success while mastering cutting-edge techniques and technologies.

Role Requirements & Experience

We are looking for a developer with at least 5 years of experience seeking a defining role in their career. You must bring a strong command of traditional SQL stack skills coupled with a passionate drive to master modern cloud analytics.

Your background must reflect the following dual skillset:

• On-Premises Implementations: A solid background developing and maintaining data warehouses utilising the traditional Microsoft SQL Server BI Stack (T-SQL, SSIS, SSAS and core database administration skills covering troubleshooting, log shipping and performance tuning).
• Cloud Implementations: Practical experience architecting Microsoft Azure or Fabric landscapes (Lakehouse, ADF, Pipelines, Data Warehouse) and integration with Power BI (semantic models, DAX, security)., * Minimum five years of Data Warehousing (ETL/ELT) experience
• Exceptional knowledge of T-SQL and database modelling (Kimball, star schema preferred)
• Extensive working knowledge of the SQL Server BI Stack
• Hands-on experience building analytical solutions in Microsoft Azure / Fabric
• Extensive use of Power BI, good understanding of DAX
• Experience working in an Agile / Scrum framework
• Experience with Git and Azure DevOps
• Previous experience working with NHS data, whilst not essential, will give you a distinct advantage

• Accelerated Career Growth: We offer an environment that actively recognises and rewards hard work, offering unlimited potential to develop as the company scales.
• Training: We will actively invest in your professional development and will fund training towards recognised, industry certification.
• Flexibility & Wellbeing: Hybrid working options, flexible core hours, generous holidays, contributory pension scheme