Ascot Lloyd group

We are seeking a Senior Data Engineer to join our Azure native data team in a leading UK financial services firm. This role is key to maintaining and evolving our data platform, supporting both ongoing enhancements and greenfield development. You will work on data integration, ETL pipelines, analytics, and AI driven insights, ensuring robust data solutions that support business growth. This is a hybrid role, with an expectation of three days per week working from the Birmingham office and at least monthly travel to London or other offices. You will 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. You will also support a production Azure Synapse Analytics environment to ensure current business requirements continue to be met. You will work within an Agile Scrum framework, delivering work through the Azure DevOps backlog, and will help integrate machine learning and AI models into our data processes as we expand our advanced analytics and insight capabilities. The Senior Data Engineer will coach and mentor Data Engineers and Power BI developers, enhancing their expertise and capability. You will provide design and engineering leadership to build, maintain and shape the future data architecture. Collaboration is central to the role. You will work within an Agile Scrum environment, using Azure DevOps for backlog management and version control, and contributing to mentorship and knowledge sharing within the team. This is an opportunity to make a real impact in a small, skilled team, helping shape the firm's data strategy and capabilities. Technical Skills Data Integration & ETL Data Engineering & Platforms: 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. ETL Development: Skilled in designing and optimising ETL workflows, with knowledge of best practices for data transformation, validation, and loading. Data Analytics & Machine Learning Power BI: Proficiency in developing, publishing, and managing Power BI reports and dashboards, with strong data visualisation skills. SQL & Data Management: Advanced knowledge of SQL for querying, transforming, and managing data, with hands on experience in SQL Management Studio. Azure Machine Learning: Some experience desirable in implementing machine learning models within Azure Machine Learning to enhance reporting and predictive analytics. Data Storage & Processing Azure Data Lake: Knowledge of Azure Data Lake for efficient storage and retrieval of large datasets. Azure Synapse Analytics (Familiarity): Familiarity with Azure Synapse, with the potential to transition to it for complex data processing needs in the future. AI Integrations ChatGPT / Copilot Integrations: Experience integrating with ChatGPT or Microsoft Copilot to automate data processing or enhance analytical insights. Version Control & Collaboration Source Control: Experience with Git or other version control systems, ideally within Azure DevOps for seamless integration with CI/CD. Azure DevOps Backlog & Agile: Skilled in working with an Agile Scrum framework, including managing work items in Azure DevOps and completing deliverables within a 2 week sprint cadence. Soft Skills Documentation & Knowledge Sharing: Excellent documentation practices for data pipelines, analytics models, and processes, ensuring knowledge transfer and transparency. Mentorship & Leadership: Committed to mentoring data engineers, providing guidance on best practices, technical skills, and professional development. Problem Solving & Adaptability: Capable of resolving complex data challenges and adapting solutions to changing business requirements. Collaboration & Communication: 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.

Ascot Lloyd group is seeking a Senior Data Engineer to join their Azure-native data team in Birmingham. This hybrid role involves designing and optimizing data pipelines and analytics solutions to support business growth and enhance data capabilities. Collaboration within an Agile environment, executing machine learning integrations, and mentoring team members are key aspects of the role. Candidates should have strong technical skills in data integration, ETL development, and experience with Azure services.

Ascot Lloyd group seeks a Power Platform Engineer in Birmingham to design, build and operate automation solutions using Microsoft Power Platform. You'll work closely with business teams to improve processes, enhance operational efficiency, and operationalise AI capabilities. Your role includes building Power Apps and workflows, automating business operations, and ensuring compliance with governance standards. We're looking for someone with strong analytical skills and practical experience in AI enablement and process automation.

The Power Platform Engineer designs, builds, operates and owns business automation and AI assisted solutions using Microsoft Power Platform, AI Foundry and Copilot Studio. The focus is on automating time consuming business processes, improving operational efficiency, and enabling the secure, governed use of AI driven assistants and workflows across the organisation. Working closely with business teams, this role requires regular in office collaboration to observe, understand and improve real business processes alongside end users. The position is a key contributor to Ascot Lloyd's AI and Automation strategy, responsible for shaping use cases with the business and safely operationalising Power App capabilities in a controlled, compliant and scalable manner within a regulated environment. Key Responsibilities Spend time embedded with business teams to directly observe processes, pain points and workarounds, ensuring solutions address real operational challenges. Design, build, operate and continuously improve Power Apps, Power Automate workflows and solutions to automate and digitise end to end business processes. Engineer AI assisted copilots and agents using Copilot Studio, contributing directly to enterprise AI patterns, standards and adoption. Act as a key technical partner for the AI Centre of Excellence, translating AI and automation strategy into delivered, governed business capabilities. Design and support attended UI based automations (RPA) using Power Automate Desktop where APIs are unavailable, ensuring appropriate controls, auditability and FCA aligned governance. Own and continuously improve existing Power Platform and Copilot solutions developed by business users and citizen engineers. Implement and enforce governance, security, environment and lifecycle controls for Power Platform and AI solutions in line with FCA, GDPR and internal policy. Work closely with business teams to translate process, operational and policy requirements into effective, automated solutions. Collaborate with other engineers and the data team, including the Azure Integration Engineer, to consume centrally provided APIs, events and AI capabilities rather than embedding integration logic in low code solutions. Monitor, troubleshoot and optimise Power Platform and Copilot solutions to ensure reliability, performance and auditability. Produce clear documentation and guidance to support safe, consistent use of Power Platform and AI capabilities. Lead controlled rollout and adoption of automation and AI enabled capabilities across the business. Experience / Skills Required Power Platform & Automation Engineering: Strong hands on experience designing, building and operating Power Apps and Power Automate workflows, including complex, long running and approval based automations that digitise end to end business processes. Workflow & Process Automation: Proven ability to analyse business processes and engineer reliable, maintainable automation solutions that reduce manual effort and operational risk. Copilot Studio & AI Enablement: Experience designing, building and maintaining AI assisted copilots and agents using Copilot Studio for practical business, operational and compliance use cases. Automation & AI Application: Practical experience applying automation and AI together across operational, administrative, policy and compliance processes, selecting the appropriate approach for each scenario. Governance & Control: Strong understanding of Power Platform environments, DLP policies, security roles and solution lifecycle management within regulated environments, including financial services, with awareness of FCA aligned governance and control requirements. Integration Consumption: Experience consuming secure APIs, connectors and events provided by central integration services rather than embedding integration logic in low code solutions. Operational Ownership: Ability to monitor, diagnose and resolve issues, optimise performance and support live automation and AI solutions in production. Delivery Comfortable working within Agile delivery models, including Scrum and Kanban. Able to take solutions from discovery through build, release and ongoing support. Soft Skills Strong analytical and problem solving skills with a process improvement mindset. Strong written and verbal communication skills, with the ability to engage effectively with both technical and non technical stakeholders. Comfortable working closely with business users and supporting citizen Engineer initiatives at a deeper technical level. Organised, reliable and comfortable taking ownership of business critical automation solutions. Willing to visit Ascot Lloyd offices as required to support delivery, adoption and collaboration.