Reporting Systems & Automation Analyst

Instant Impact; Greater London; On-site; GBP 60,000 - 90,000; Full time

Job summary

Instant Impact is seeking a Reporting Systems & Automation Analyst in London to deliver reporting, automation and business system solutions across Compliance and Risk. You will design, develop and enhance applications, dashboards and workflows using the Microsoft Power Platform, collaborating with stakeholders to improve efficiency, data quality and insight.

Ideal candidates have hands-on experience with Power Apps, Power Automate, Power BI, SQL Server and Dataverse, translating business needs

Qualifications

• Experience designing and delivering reporting, automation and BI solutions using the Power Platform.
• Ability to gather requirements and translate into scalable technical solutions.
• Strong data visualization and data quality focus.
• Experience in a financial services or regulated environment preferred.

Responsibilities

• Design, develop and maintain Power Apps and Power Automate solutions for Compliance and Risk.
• Develop and enhance Power BI dashboards to deliver meaningful insights.
• Support and maintain business systems; investigate and resolve issues.
• Translate business requirements into scalable automation and reporting solutions.
• Manage testing, releases and continuous improvement of systems.
• Document configurations, processes and change records; ensure data integrity.
• Work with Dataverse, SharePoint, SQL Server and integrated data sources.
• Develop system integrations and APIs; automated workflows between apps.
• Identify opportunities to improve processes through automation.

Skills

Power Apps

Power Automate

Power BI dashboards

SQL Server

Dataverse

SharePoint

APIs and connectors

Low-code development

Data analysis

Tools

Power Apps

Power Automate

Power BI

SQL Server

Dataverse

SharePoint

APIs

Job description

Reporting Systems & Automation Analyst

Department: Client Role

Employment Type: Permanent - Full Time

Location: London, UK

We are currently representing a leading global Financial Services firm in the appointment of high-calibre professionals as part of a period of strategic growth and investment.

Our client operates at the intersection of corporate, fiduciary and regulatory services, partnering with private equity houses, investment managers and international financial institutions. Backed by long-term institutional investment and an established global brand, the firm is scaling its capabilities, technology and international footprint.

This is an opportunity to join a business that combines the agility of a growth platform with the credibility, client base and governance of a market leader.

The Role

As a Reporting Systems & Automation Analyst, you will play a key role in delivering innovative reporting, automation and business system solutions across Compliance and Risk. Working closely with stakeholders across the business, you will design, develop and enhance applications, dashboards and workflows using the Microsoft Power Platform, helping to improve operational efficiency, data quality and business insight.

Key Responsibilities

• Design, develop and maintain solutions using Microsoft Power Apps and Power Automate to support Compliance and Risk functions
• Develop and enhance Power BI dashboards and reporting solutions, delivering meaningful insights for business stakeholders
• Support and maintain business systems, investigating and resolving application and system issues
• Gather and translate business requirements into scalable system, reporting and automation solutions
• Manage system enhancements, testing, releases and ongoing continuous improvement initiatives
• Maintain the accuracy and integrity of system data across multiple platforms and reporting environments
• Work with Dataverse, SharePoint, SQL Server and integrated data sources to support reporting and automation solutions
• Develop and maintain system integrations, APIs and automated workflows between business applications
• Produce clear technical documentation, including system configurations, processes and change records
• Identify opportunities to improve business processes through automation and technology-led solutions

Skills, Knowledge and Expertise

• Proven experience developing solutions using Microsoft Power Platform, including Power Apps and Power Automate
• Experience building Power BI dashboards and reporting solutions, with strong data visualisation capability
• Strong understanding of low-code application development and business process automation
• Experience working with SQL Server, SQL Management Studio and structured data environments
• Experience working with Dataverse, SharePoint and system integrations, including APIs and connectors
• Experience supporting and enhancing business systems within a commercial environment
• Strong understanding of system development lifecycles, including testing, releases and change management
• Ability to gather, analyse and translate business requirements into practical technical solutions
• Strong analytical, problem-solving and documentation skills, with excellent attention to detail
• Excellent communication skills, with the ability to engage both technical and non-technical stakeholders
• Understanding of KYC data and corporate structures is advantageous