Remote PowerBI Developer

• Design and implement efficient SQL queries and database structures to support complex business processes and hierarchical data relationships.
• Develop recursive queries and CTEs to traverse and manipulate hierarchical data.
• Optimise stored procedures and troubleshoot performance issues using execution plans and query tuning techniques.
• Collaborate with developers and analysts to translate business requirements into efficient database logic.
• Enforce data governance, integrity, and consistency across database systems.
• Design and maintain advanced interactive Power BI dashboards and reports.
• Build robust data models using DAX and manage ETL processes from various sources, including SQL Server, Excel, and cloud platforms.
• Gather and translate complex business requirements into technical specifications.
• Promote best practices in data governance and maintain documentation for report logic and dashboard functionality.
• Optimise Power BI solutions for performance and scalability.
• Support re-platforming initiatives with data-driven insights.
• Mentor junior analysts and contribute to a culture of continuous learning.
• Identify opportunities for new data solutions and contribute to the analytics roadmap.

Technologies:

• Backend
• Cloud
• DAX
• ETL
• Excel
• Support
• Power BI
• Power Query
• SQL

• 5+ years of experience in SQL development with enterprise-grade relational databases (SQL Server).
• 4+ years of experience in Power BI development with a strong portfolio of dashboards.
• Expertise in hierarchical data patterns, including adjacency lists, nested sets, and recursive CTEs.
• Strong proficiency in DAX, M-Query, and Power Query.
• Solid understanding of indexing, query optimisation, and performance tuning.
• Experience with stored procedures, complex joins, and relational database design.
• Strong analytical, problem-solving, and communication skills., We are hiring a full-time Senior Data & BI Developer with a salary of £55,000 - £65,000 per annum. We are looking for a highly skilled professional who can bridge backend data architecture and front-end analytics, combining deep SQL expertise with advanced Power BI capabilities to support mission-critical business logic, reporting systems, and strategic insights. In this role, you will work with complex hierarchical data models, optimise database performance, and develop impactful dashboards that empower stakeholders across our organisation.