> Markdown version of [/jobs/ext/3180088-data-operations-lead](https://www.wearedevelopers.com/jobs/ext/3180088-data-operations-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Operations Lead - **Company:** ERM - **Location:** London, UK - **Experience:** Expert - **Salary:** £66,641.0 - **Contract:** Temporary contract - **Skills:** Business Analytics Applications, Business Software, Cloud Database, Databases, Data Governance, Extract Transform Load (ETL), Data Warehousing, Database Design, Query Languages, Dimensional Modeling, PostgreSQL, Uptime, Microsoft SQL Server, Networking Basics, Query Optimization, Power BI, DataOps, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Data Streaming, Data Processing, Enterprise Software Applications, Azure Data Factory, Database Optimization, Backend, Powerquery, Microsoft Fabric, Data Analytics, Data Management, Tools for Reporting, Data Pipelines - **Published:** September 30, 2026 - **Apply:** https://www.adzuna.co.uk/jobs/details/5902864226 ## About the Role * 5+ years of experience as a Database Administrator, Data Engineer, BI Engineer, or similar role. * Advanced expertise in Microsoft SQL Server and related technologies. * Strong proficiency in SQL, stored procedures, functions, views, query optimization, and database performance tuning. * Experience with database design, schema development, logical and physical data modelling. * Strong understanding of query languages and analytics technologies, including SQL, MDX, DAX, Power Query (M), and PostgreSQL. * Experience building, maintaining, and optimizing ETL/ELT processes using SSIS, Azure Data Factory, Microsoft Fabric, or equivalent tools. * Hands-on experience developing and supporting Power BI solutions, including Power BI Desktop and Power BI Service. * Experience creating and maintaining analytics data pipelines that support reporting, insights, and operational decision-making. * Knowledge of Microsoft Fabric architecture, including OneLake, Lakehouses, Warehouses, Pipelines, and Notebooks. * Understanding of business intelligence best practices, including dimensional modelling, data warehousing, and data governance. * Experience supporting mission-critical systems with a strong focus on uptime, stability, and service excellence. * Working knowledge of Windows Server environments and networking fundamentals. * Experience operating within regional or global organizations. * Bachelor's degree in a relevant field or equivalent combination of education and experience. Preferred * Experience supporting enterprise finance systems or ERP platforms. * Experience working with SSRS, Report Builder, and other reporting technologies. * Knowledge of cloud-based data architectures and modern analytics platforms. * Experience supporting bespoke business applications with complex database dependencies. * Exposure to service management or ITIL-aligned support environments. * Experience mentoring colleagues and contributing to technical capability development within a team. * Certifications in Microsoft SQL Server, Power BI, Fabric, Azure Data, or related technologies. ## Description * Act as the subject matter expert for SQL Server databases, business intelligence platforms, and supporting back-end systems. * Maintain maximum uptime, performance, reliability, and security across enterprise database environments. * Monitor, troubleshoot, and resolve database-related incidents, performance issues, and service disruptions. * Participate in on-call and occasional out-of-hours support to maintain business-critical services. Support and Enhance Enterprise Systems * Ensure the smooth operation and optimal performance of ERM's finance systems and other SQL-dependent applications. * Partner with software vendors and internal stakeholders to identify, troubleshoot, and resolve system issues. * Develop enhancements that improve performance, scalability, and user experience. * Support integration and data flows across multiple systems and platforms. Drive Data and Analytics Excellence * Design, develop, and maintain robust data models, data warehouses, and analytical solutions. * Build and optimize data pipelines that transform data into actionable business insights. * Ensure datasets from multiple sources remain accurate, centralized, governed, and accessible. * Develop and maintain Power BI reports, dashboards, and reporting solutions that support strategic and operational decision-making. Advance Microsoft Fabric and Modern Data Capabilities * Support and enhance ERM's Microsoft Fabric environment, including analytics engineering, data orchestration, and reporting capabilities. * Contribute to the development of scalable modern data architecture and best practices. * Identify opportunities to improve data processing efficiency, reporting performance, and platform scalability. Collaborate Across the Business * Partner closely with IT teams, business stakeholders, vendors, and technology leaders to deliver solutions that support organizational objectives. * Help translate business requirements into technical solutions that deliver measurable value. * Foster collaborative working relationships across teams and functions. Deliver Technical Leadership and Operational Excellence * Act as a trusted technical expert and escalation point for complex database and analytics challenges. * Maintain accurate documentation, support records, and technical standards. * Contribute to continuous improvement initiatives that enhance team capability, service quality, and operational effectiveness. * Research emerging technologies and recommend improvements that strengthen ERM's data and analytics capabilities. ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [DevOps at Netflix](https://www.wearedevelopers.com/videos/270-devops-at-netflix) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean) - [Leading with Reliability: Applying SRE Principles to Build Stronger Engineering Organizations](https://www.wearedevelopers.com/videos/100185-leading-with-reliability-applying-sre-principles-to-build-stronger-engineering-organizations) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)