Senior Business Intelligence Developer

GRIDSERVE is a forward-thinking, technology-enabled sustainable energy business. We are committed to delivering net zero transport at the speed and scale the climate crisis requires to prevent global temperature rises exceeding 1.5 C of warming. We deliver net zero transport through our pioneering and multi award-winning Sun-to-Wheel platform: developing, delivering and operating world class customer-focused electric vehicle charging networks powered by solar energy and batteries. We support the success of our networks and the EV transition through driving the uptake and success of electric vehicles with GRIDSERVE Car Leasing. Everything we do is underpinned and connected by a technology-agnostic, proprietary data platform that grows and improves every day. Get in touch ROLE OVERVIEW Join GRIDSERVE as a Senior 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 Senior 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 Support the evolution of our enterprise data technologies using Azure. Lead, manage, and mentor the BI and Data Analyst Team. Develop, test, and implement data, reporting, and analytic solutions in Azure. Design, develop, and support mission-critical BI applications. Translate complex business logic into database design using Stored Procedures, User Defined Functions, Views, and T-SQL. Collaborate with stakeholders to develop comprehensive Power BI models that enhance performance and achieve business objectives. Architect and document Power BI solutions integrated with Azure services. Write and optimize complex DAX functions in Power BI and Power Pivot. Analyze complex data sets and transform them into actionable insights. Automate Power BI data refreshes using PowerShell scripts and Azure Automation. Create Workspaces and Content Packs for business user access. Install, configure, and manage Enterprise and Personal Gateways in PowerBI Service. Develop Calculated Columns and Measures in Power BI Desktop. Create advanced SQL queries and Stored Procedures for Power Pivot models. Optimize table performance through index analysis and enhancements. Cleanse data using Derived Columns, Lookups, and Conditional Split. Design and develop reports using Charts, Gauges, Tables, and Matrices. Create Parameterized, Dashboard, Linked, and Sub Reports. Develop drill-down and drill-through reports for multi-dimensional analysis. Stay updated on industry best practices and trends to improve processes and systems. Assist in other related duties as and when requested by GRIDSERVE Senior Management. Adhere to all company policies, procedures, and business ethics codes, including anti-bribery policy and Environmental and Quality Management System (compliant with ISO 9001 and 14001). PERSON SPECIFICATION Required experience Extensive Power BI report development experience, including dashboard creation and data visualisation. Experience as a SQL Developer and BI Developer. Strong experience with DAX, SQL, and Azure data services. Deep understanding of Data Warehousing concepts and best practices. Proficient in database design, interrogation, and programming. Expertise in writing advanced SQL, including query tuning and optimisation. Expert in creating and developing Power BI dashboards and integrating them with Azure services. Proficient in creating and using Stored Procedures, Views, and User Defined Functions. Experience with creating Sub-Queries and joins for complex queries involving multiple tables. Strong data modelling experience using ER diagrams and dimensional data modelling. Experience with developing U-SQL scripts for processing large data sets in Azure Data Lake. Proven experience working with large data sets and optimizing data processing. Excellent problem-solving skills, with the ability to analyse data, identify issues/opportunities, and design pragmatic solutions. Required skills and abilities Demonstrated accuracy and attention to detail with excellent written and verbal communication skills. Self-driven, focused, and quality-oriented with a strong team ethic. Innovative thinker with sound judgment and solution-oriented mindset. Ability to foster self-motivation and meet tight deadlines. Proactive, innovative, and able to work effectively in a team environment. Analytical mindset with a keen eye for detail. Ability to manage multiple projects simultaneously and prioritize effectively. Required qualifications and certifications Bachelor's degree or higher in Computer Science, Information Systems, or a related field desirable. Certified Business Intelligence Professional (CBIP) or equivalent industry qualifications Microsoft Azure AI Engineer Associate desirable Equal Opportunity statement: GRIDSERVE is committed to being an Equal Opportunity Employer. We ensure that all individuals are treated with fairness and respect in our hiring process, regardless of gender (including gender identity, gender expression, and gender reassignment), race (including colour, nationality, ethnic or national origin), religion or belief, marital or civil partnership status, disability, age, sexual orientation, pregnancy or maternity, trade union membership, or membership in any other legally protected category. Company culture & values GRIDSERVE prides itself in providing a workplace that is friendly, encourages creativity and independence, empowering each team member to work at their best. We are passionate with an entrepreneurial spirit, hard-working but always find time to let our hair down . We aim to work with awesome people who align with our values to achieve greater results. Consider the values below and ask how well these resonate with the principles you hold: Be awesome We aim to delight: great is our minimum bar Positively charged We are positive people who approach life and every task full of healthy energy Synergy seekers We have each other s back, and appreciate that the whole is greater than the sum of its parts Legacy creators We strive to deliver positive change through strong ethics and sustainable choices Straight up We are open, honest, direct people who accept responsibility and sweep nothing under the carpet Risk mitigators We stack the odds in our favour by taking risks we have the ability to influence Thought leaders We have the strength and conviction to create a better path, and to follow gut instincts Solutions focussed We embrace problems as opportunities and focus our time and energy on solutions Our dedication extends to fostering an inclusive environment where employees are empowered, and diversity is embraced. We encourage everyone to participate actively and respond to our commitment to equality. Company benefits: Financial benefits: competitive pay, share options, pension, life insurance, income protection, retail & entertainment discounts. Wellbeing and work life balance: 33 days annual leave inc. public holidays, remote and flexible working, generous maternity and paternity leave, excellent family cover private health, employee assistance programme, 24/7 GP access Planet friendly: EV leasing salary sacrifice scheme, EV leasing referral, cycle to work scheme Growth: a dynamic, challenging and rewarding environment with excellent learning and development resources via our top inhouse LMS and exciting career progression opportunities Join us in delivering a better and more sustainable future GRIDSERVE TechForGood SustainableEnergy