Lead Business Intelligence Developer

ROLE OVERVIEW

We have an exciting opportunity for a Lead BI Developer to be a critical part of GRIDSERVE’s future success by enabling insights through data.There are huge opportunities for the business to exploit data to derive insights, improve the performance of our charging infrastructure and delight our customers. Our Lead BI Developer and the BI development team will be at the forefront of enabling our future business success in a highly rewarding role for someone who wants to make a difference through insights and analytics.

MAIN RESPONSIBILITIES

Leadership

• Lead, manage, and mentor the BI Team and support the wider BI community at GRIDSERVE.
• Support the creation and implementation of the BI strategy and roadmap in alignment with business objectives.
• Set performance goals, conduct regular reviews, and provide professional development opportunities for team members.
• Oversee multiple BI projects, ensuring timely delivery and quality outcomes.
• Stakeholder management

BI Development and Implementation

• Define and enforce BI development standards, processes, and best practices.
• Develop, test, and implement data, reporting, and analytic solutions in Azure.
• Design, develop, and support mission-critical BI applications.
• Create advanced SQL queries, Stored Procedures, and Power Pivot models.

Insight Generation

• Analyse complex data sets and transform them into actionable insights.
• Collaborate with business leaders to understand data needs and translate them into effective BI solutions.
• Translate complex business logic into database design using Stored Procedures, User Defined Functions, Views, and T-SQL.
• Develop and optimise DAX functions in Power BI.

Automation and Optimisation

• Automate Power BI data refreshes using PowerShell scripts and Azure Automation.
• Optimise table performance through index analysis and enhancements.
• Cleanse data using Derived Columns, Lookups, and Conditional Split.

Best Practices

• Stay updated on industry best practices and trends to improve processes and systems.
• Adhere to all company policies, procedures, and business ethics codes, including the anti-bribery policy and Environmental and Quality Management System (compliant with ISO 9001 and 14001).

PERSON SPECIFICATION

We encourage candidates from diverse backgrounds to apply. If you meet some but not all of the criteria, we still want to hear from you. Your unique skills and experiences are valuable to us.

Required Skills and Experience

• Ability to lead and support the rest of the BI team.
• Excellent problem-solving skills, with the ability to analyse data, identify issues and opportunities, and design pragmatic solutions.
• Strong written and verbal communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Experience with Data Modeling Techniques
• Source control (e.g., Git) and CI/CD for BI environments to streamline deployments

Power BI Expertise

• Minimum of 7-10 years in BI development
• Extensive experience in Power BI report development e.g. Dashboard creation, data refresh automation, and managing gateways.
• Understanding of security concepts in Power BI including RLS (Row Level Security).
• Strong experience with DAX and creating complex Power BI models and measures.
• Power Query scripting capability
• Understanding of Power BI service tiers and constraints.

SQL and Database Skills

• Proficiency as a SQL Developer, including advanced SQL queries involving multiple tables, query tuning, and optimization.
• Experience with database design, interrogation, and programming, including Stored Procedures, Views, and User Defined Functions.

Azure and Data Services

• Strong experience with Azure data services, including Azure Data Lake, and Synapse Analytics .
• Deep understanding of Data Warehousing concepts and best practices.
• Proven experience working with large data sets and optimizing data processing.
• Ability to create and debug Azure Data Factory pipelines
• Awareness of MS Dataverse and Power Platform

Desirable Qualifications and Certifications

• Bachelor's degree in relevant field.
• BI certifications e.g. Certified Business Intelligence Professional (CBIP) or Microsoft Azure Power BI certification.