- Company Name
- Smart Managed Solutions
- Job Title
- Finance Systems & IT Support Analyst
- Job Description
-
**Job Title**
Finance Systems & IT Support Analyst
**Role Summary**
Provide specialized technical support and administration for finance‑related systems, ensuring their reliability, performance, and data integrity. Act as the primary liaison between finance and IT to enhance system functionality, automate processes, and maintain compliance across key platforms such as Microsoft Dynamics, SQL Server, Power BI, Metabase, and DBT.
**Expectations**
Deliver high‑quality, timely solutions for finance system issues; manage data pipelines, dashboards, and user access; collaborate with finance staff and internal IT to optimize applications; uphold data governance and audit readiness; continuously improve processes through automation and documentation.
**Key Responsibilities**
- Serve as the main IT contact for Finance applications – Microsoft Dynamics, Evision, and related tools.
- Develop and maintain SQL queries, scripts, and reports supporting finance analysis and integrations.
- Build and manage data pipelines/pipelines using DBT to ensure accurate, timely data flow.
- Maintain, optimize, and secure Metabase dashboards and Power BI visualisations.
- Oversee user permissions, system configurations, and compliance with IT and Finance policies.
- Collaborate with Finance teams to identify system needs, recommend enhancements, and implement solutions.
- Partner with vendors and other IT teams for upgrades, integrations, and performance improvements.
- Document system configurations, processes, and best‑practice guides.
- Identify and automate workflow opportunities to boost reporting effectiveness.
- Provide general IT support for business‑critical applications, troubleshooting and escalating as needed.
- Support backup, data integrity, and compliance processes in coordination with IT Operations.
- Assist in audit preparation to ensure adherence to internal/external standards.
**Required Skills**
- Hands‑on experience with Microsoft Dynamics (Evision, Jet Reports).
- Advanced SQL proficiency for querying, manipulation, and reporting.
- Working knowledge of Metabase and Power BI dashboards.
- Experience with DBT for data transformation and pipeline management.
- Strong troubleshooting, analytical, and documentation capabilities.
- Effective communication and collaborative skills bridging Finance and IT.
- Familiarity with API integration, Power Automate, or Azure Data Services is a plus.
**Required Education & Certifications**
- Bachelor’s degree in Finance, Information Systems, Computer Science, or related discipline.
- Relevant certifications (e.g., Microsoft Dynamics 365 Finance, SQL Server DBA, Power BI) strongly preferred.
---