Data Analyst - City of London based client

Claremont Consulting Ltd; United Kingdom; On-site; GBP 45,000 - 65,000; Full time

Job summary

A consulting firm in the UK is seeking a Business Reporting Specialist to lead financial reporting efforts. The ideal candidate has strong experience with Dynamics 365 Business Central and Power BI. This role offers opportunities to work with advanced Microsoft technologies and make a significant impact on business decisions. The successful applicant will work with supportive teams and grow their technical expertise in a dynamic environment.

Qualifications

• Proven experience with Dynamics 365 Business Central and its reporting capabilities.
• Strong hands-on experience with Power BI, including DAX and data modelling.
• Ability to translate business requirements into technical solutions.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design and deliver reporting solutions using Power BI.
• Work with finance teams to define reporting requirements.
• Build and maintain data pipelines and ETL processes.
• Develop and support financial dashboards for management.
• Champion data governance across reporting platforms.
• Support ad hoc reporting and data analysis requests.

Skills

Dynamics 365 Business Central

Power BI

Data governance

Stakeholder management

Tools

Microsoft Fabric

Power Platform

Job description

Overview

My client is looking for a talented and technically adept Business or Data Analyst to join their team as a Business Reporting Specialist. This is a fantastic opportunity for a motivated individual to take a leading role in shaping financial reporting infrastructure. My client is going through a business transformation with a new CRM implementation and significant integration across other applications within the company. The destination environment is likely to be on Microsoft Fabric with Power BI reporting. The heavy build and configuration work will be done by a managed service provider, but this role is an excellent opportunity to see how it is all done and to learn new environments. Are you ready to advance your career in a dynamic, forward-thinking environment? If you have a passion for data, expertise in Dynamics Business Central, and strong Power BI skills, my client will want to hear from you!

Responsibilities

• Designing and delivering cutting-edge reporting solutions using Power BI to meet financial and operational needs.
• Working closely with finance and operations teams to identify key performance indicators and define reporting requirements.
• Building and maintaining efficient data pipelines and ETL processes, ensuring accurate and timely data delivery.
• Developing and supporting financial dashboards for both executive management and departmental use.
• Championing data governance and ensuring accuracy across our reporting platforms.
• Supporting stakeholders with ad hoc reporting and data analysis requests.

Opportunity & Environment

This role offers the chance to expand your technical expertise, with opportunities to work on Microsoft’s Azure platform as well as emerging Fabric technologies. The successful applicant will be at the forefront of financial reporting innovation. Collaborate with diverse and supportive teams. Grow existing technical skill-set with access to advanced Microsoft technologies. Make a tangible impact on business decision-making and strategy.

Qualifications

• Proven experience with Dynamics 365 Business Central, including data structures and reporting capabilities.
• Strong hands-on experience with Power BI (DAX, Power Query, data modelling).
• Ability to translate business requirements into (technical) solutions.
• Excellent communication and stakeholder management skills.

Desirable / Beneficial

• An understanding of Microsoft Fabric
• Experience of integrating Dynamics Business Central data with Microsoft Fabric
• Microsoft’s Power Platform (Power Automate, Power Apps, Power Apps etc.)
• ETL processes, data warehousing, and integration strategies
• Microsoft certifications in Dynamics Business Central and/or Power BI and/or Power Platform.
• Experience with financial reporting in a medium sized business (circa 250 people).
• Familiarity with CRMs would be a plus

Please send your CV to me, Martin Warner, and I will get back to you as soon as possible