Senior Data Engineer

• Design, build and optimise data pipelines, data models and analytics solutions across SQL Server, Azure Data Lake and Power BI and lead the strategic migration to Microsoft Fabric as the data Platform
• Support a production Azure Synapse Analytics environment to ensure current business requirements continue to be met
• Work within an Agile Scrum framework, delivering work through the Azure DevOps backlog
• Help integrate machine learning and AI models into our data processes as we expand our advanced analytics and insight capabilities
• Coach and mentor Data Engineers and Power BI developers, enhancing their expertise and capability
• Provide design and engineering leadership to build, maintain and shape the future data architecture
• Collaborate within an Agile Scrum environment, using Azure DevOps for backlog management and version control

• Strong experience designing and delivering data pipelines, data models and analytics solutions with a Microsoft Fabric‑first mindset, helping to accelerate adoption of Fabric (e.g. Lakehouse, Warehouse, OneLake), while also supporting and enhancing existing SQL Server, Azure Data Lake and Azure Synapse Analytics environments in production
• Integrate multiple external and internal systems data sources into Fabric Data Platform
• API integration experience is necessary
• Skilled in designing and optimising ETL workflows, with knowledge of best practices for data transformation, validation, and loading
• Proficiency in developing, publishing, and managing Power BI reports and dashboards, with strong data visualisation skills
• Advanced knowledge of SQL for querying, transforming, and managing data, with hands-on experience in SQL Management Studio
• Some experience desirable in implementing machine learning models within Azure Machine Learning to enhance reporting and predictive analytics
• Knowledge of Azure Data Lake for efficient storage and retrieval of large datasets
• Familiarity with Azure Synapse, with the potential to transition to it for complex data processing needs in the future
• Experience integrating with ChatGPT or Microsoft Copilot to automate data processing or enhance analytical insights
• Experience with Git or other version control systems, ideally within Azure DevOps for seamless integration with CI/CD
• Skilled in working with an Agile Scrum framework, including managing work items in Azure DevOps and completing deliverables within a 2-week sprint cadence
• Excellent documentation practices for data pipelines, analytics models, and processes, ensuring knowledge transfer and transparency
• Committed to mentoring data engineers, providing guidance on best practices, technical skills, and professional development
• Capable of resolving complex data challenges and adapting solutions to changing business requirements
• Strong communication skills for working effectively with cross-functional teams, including data scientists, product teams, and stakeholders
• Financial Services sector and specifically Wealth Management experience or working in a highly regulated sector will be an added advantage

Financial Services sector and specifically Wealth Management experience or working in a highly regulated sector will be an added advantage