A Central London based Mid-Tier bank seeking to hire a Data & BI Analyst. The role will play a crucial role in transitioning to and supporting the business new Azure Data Warehouse.
Responsibilities:
Maintenance of Azure and BI Processes
* Support the Azure data warehouse Finance adoption and migration process
* Support and maintain Power BI reporting and processes.
* Ensure data accuracy and integrity within the new Azure data warehouse
* Documentation for new processes, including user manuals and process flow diagrams
* Collaborate with IT and other departments to resolve any technical issues in the Azure reporting processes
* Oversee System Reconciliations and Exception Reporting Analysis
Continued Adoption of the Data Warehouse
* Facilitate the integration of new data sources into the Azure data warehouse
* Conduct training sessions and workshops to increase data warehouse literacy across the team
* Develop strategies to enhance user engagement with the data warehouse
* Provide ongoing support and guidance to users for effective data warehouse utilisation
* Analyse and report on data warehouse usage and suggest improvements
Support and Creation of PowerBI Dashboards
* Design, develop, and maintain PowerBI dashboards and reports for various Finance needs
* Work closely with stakeholders to understand their data visualisation requirements
* Provide training and support to users on self-serve data sets and utilising PowerBI
Support Automation and Reporting Solutions
* Identify opportunities for automation in finance reporting processes
* Implement and maintain reporting solutions using tools like Alteryx and other automation applications
* Develop and automate robust, scalable financial reports and models


Skills and Experience sought:
* Strong systems and data management skills
* Effective business communication skills around Power BI
* Azure Experience: Proficiency in Azure data services and cloud architecture, beneficial for data management and analytics
* Power BI and Automation Expertise: Proficiency in data visualisation and automation tools
* SQL and programming experience: Ability to write and optimise queries and scripts for reporting and data analysis
* Strong foundation of financial knowledge
* Project Management: Experience managing data and BI projects is advantageous
* Programming and Data Handling: With capabilities in data extraction, manipulation, and visualisation
* Advanced Excel Proficiency: pivot tables, complex formulas, and VB
* Automation and AI Tools: Familiarity with automation technologies and machine learning/AI principles is an advantage
* Proven ability to drive change and implement improvements
* Ability to plan, organise, and prioritise workloads to meet deadlines.
* Accuracy and attention to detail