Finance Systems & IT Support Analyst

Smart Managed Solutions; City Of London; On-site; GBP 40,000 - 55,000; Full time

Job summary

A financial solutions provider in London is seeking a Finance Systems & IT Support Analyst. This role involves providing expert-level support for finance-related systems, system administration, and data management. The ideal candidate will have strong experience with Microsoft Dynamics, proficiency in SQL, and familiarity with data visualization tools such as Power BI. Competitive salary and opportunities for continuous improvement in financial systems are offered in this position.

Qualifications

• Strong hands-on experience with Microsoft Dynamics (Evision, Jet reports)
• Proficient in SQL for query writing, data manipulation, and reporting.
• Working knowledge of Metabase and Power BI.
• Experience with DBT for data transformation and pipeline management.
• Excellent troubleshooting and communication skills.

Responsibilities

• Serve as the primary IT point of contact for Finance systems.
• Support and administer Microsoft Dynamics and related applications.
• Develop and maintain SQL scripts for Finance data analysis.
• Manage data pipelines using DBT.
• Maintain and optimise Metabase dashboards.

Skills

Hands-on experience with Microsoft Dynamics

Proficient in SQL

Working knowledge of Metabase

Experience with Power BI

Experience with DBT

Excellent troubleshooting skills

Strong communication skills

Tools

SQL Server

Visual Studio

Power Automate

Azure Data Services

Job description

Overview

The Finance Systems & IT Support Analyst acts as the dedicated technical specialist for all Finance-related systems, providing expert-level support, system administration, and data management across platforms such as Microsoft Dynamics, SQL Server, Visual Studio, Power Bi, Metabase and associated tools. In addition to Finance systems expertise, this role provides general IT function, contributing to the stability, integration, and performance of business-critical applications across the organisation.

Key Responsibilities

Finance Systems Administration & Support

• Serve as the primary IT point of contact for Finance systems, ensuring smooth operation and timely issue resolution.
• Support and administer Microsoft Dynamics, Evision and related financial applications.
• Develop and maintain SQL scripts, queries, and reports to support Finance data analysis and system integrations.
• Manage data pipelines and transformations using DBT and other tools to ensure data accuracy and integrity.
• Maintain and optimise Metabase dashboards and reports, ensuring reliable, insightful financial reporting.
• Oversee user access, permissions, and system configurations in accordance with IT and Finance policies.

Collaboration & Continuous Improvement

• Work closely with Finance teams to understand system needs, recommend improvements, and implement solutions.
• Collaborate with vendors and internal IT teams on system upgrades, integrations, and performance enhancements.
• Document system configurations, processes, and best practices to support training and compliance requirements.
• Identify opportunities to automate workflows and improve reporting efficiency across systems.

General IT

• Provide comprehensive IT support for business-critical applications, including troubleshooting, system administration, and technical escalation as required, contributing to the overall IT service function.
• Support data integrity, backup, and compliance processes in collaboration with IT Operations.
• Assist with audit preparation, ensuring Finance systems meet internal and external compliance standards.

Qualifications & Experience

Essential:

• Strong hands-on experience with Microsoft Dynamics (Evision, Jet reports)
• Proficient in SQL for query writing, data manipulation, and reporting.
• Working knowledge of Metabase and Power BI.
• Experience with DBT for data transformation and pipeline management.
• Excellent troubleshooting, communication, and documentation skills.

Desirable:

• Exposure to ERP or finance system integrations and data warehousing concepts.
• Experience supporting or developing APIs or data exchange workflows.
• Familiarity with Power Automate, Power BI, or Azure Data Services.
• Experience within facilities management, construction, property, or professional services industries.

Key Competencies

• Analytical mindset with strong attention to detail.
• Collaborative communicator who can bridge Finance and IT teams.
• Problem-solver with a proactive and structured approach.
• Adaptable and capable of managing multiple priorities effectively.
• Customer-focused and committed to delivering high-quality system support.