> Markdown version of [/jobs/ext/3275311-sql-bi-operations-lead](https://www.wearedevelopers.com/jobs/ext/3275311-sql-bi-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). --- # SQL & BI Operations Lead - **Company:** SystemsAccountants - **Location:** UK (Remote available) - **Experience:** Expert - **Salary:** £80,000.0 - £90,000.0 - **Contract:** Temporary contract - **Skills:** Databases, Data Infrastructure, Extract Transform Load (ETL), Data Systems, Database Design, Database Queries, Software Debugging, Microsoft SQL Server, Windows Servers, Power BI, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Agent, SQL Server Integration Services, SQL Server Analysis Services, Azure Data Factory, System Availability, Database Performance, Powerquery, Microsoft Fabric, Tools for Reporting - **Published:** September 15, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=dce2ed7e7c1d0ef0 ## About the Role 5+ years' experience working with SQL Server / DBA / Data Platform support . Strong SQL skills, including queries, stored procedures, functions and views. Strong experience debugging and optimising SQL queries. Experience with SSAS, SSIS and SSRS . Strong knowledge of Power BI , including Power BI Desktop and Service. Good understanding of DAX, MDX and Power Query / M . Experience with SQL Server Agent and scheduled jobs. Strong understanding of database design and both logical and physical data modelling. Experience working with ETL pipelines and dimensional modelling. Exposure to Microsoft Fabric , including Lakehouses, Warehouses, Pipelines and OneLake. Experience building or supporting analytics pipelines using Fabric, Azure Data Factory or SSIS. Good understanding of Windows Server and networking. Experience working within a service desk or operational support environment. What We're Looking For This role would suit someone who enjoys being the go-to technical person for a SQL and BI environment . You should be comfortable supporting users, investigating tickets, debugging complex problems and keeping systems running reliably, rather than purely focusing on new development. The successful candidate will combine strong SQL and BI technical knowledge with a service-focused approach, strong problem-solving skills and the ability to work independently across a distributed organisation. Experience operating within a large, regional or global environment would be particularly beneficial. ## Description We are looking for an experienced SQL & BI Operations Lead to take ownership of the day-to-day support, administration and reliability of a Microsoft SQL Server and Business Intelligence environment. This is a hands-on operational role focused on keeping key databases, data models and reporting services running smoothly, resolving user issues, debugging technical problems and ensuring high availability across business-critical data systems. The environment includes SQL Server, SSAS, SSIS, Power BI and Microsoft Fabric , with the main focus remaining on SQL and its related technologies. Key Responsibilities Act as the technical SME for the SQL and BI environment . Ensure maximum uptime and performance across business-critical SQL databases. Manage and resolve escalated user issues, support tickets and technical incidents. Troubleshoot and debug issues across SQL Server, SSRS, SSAS, SSIS and Power BI . Support SQL queries, stored procedures, functions and views. Investigate database performance issues and optimise queries. Maintain and support scheduled jobs and ETL processes. Support and maintain data models and reporting solutions. Ensure data from multiple sources remains centralised and accessible. Support finance and other business-critical systems that rely on SQL. Work with software vendors and internal teams to investigate and resolve system issues. Maintain clear technical documentation and support records. Keep users informed on the progress of support issues and agreed actions. Support occasional out-of-hours work where required for critical incidents or maintenance. Work closely with wider IT, Finance and Data teams to ensure a reliable service. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [IT Salaries in UK](https://www.wearedevelopers.com/magazine/288-it-salaries-in-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Software Engineer Salary in The UK](https://www.wearedevelopers.com/magazine/231-software-engineer-salary-in-the-uk)