Data & BI Analyst - Marks Sattin : Job Details

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