Senior Business Intelligence Analyst
CurrentDesigned and implemented modern data stack consisting of Fivetran data pipelines (ELT), Azure Synapse cloud data warehouse (Dedicated SQL Pool), and Power BI.Creation of new, automated, self-service reporting, embedded in the Open Energy Market platform.Using SQL, DAX and Power BI to create reports such as:- Mark to Market Reporting- Half Hourly Consumption- Volume ForecastingOff platform reporting (integrating SharePoint data sources via Power Automate) such as:- Fund benchmarking (vs fixed contracts)- Seasonal fund price performance- Fixed tender supplier scorecard- kVa review- Ad hoc reports to generate significant time savings