Finance IT Systems Analyst & Optimization Specialist

City-of-Richmond,-Va; Richmond (VA); On-site; USD 70,000 - 100,000; Full time

Job summary

The Financial IT Specialist at City of Richmond supports development, implementation, and optimization of technology-based solutions used within financial operations. This role focuses on improving business processes, defining system requirements, and translating needs into effective technology and process changes.

You will extract and interpret financial data, map workflows, assist with testing and deployment, train users, and coordinate with Finance, IT, and operational teams to ensure

Qualifications

• Bachelor’s degree in Information Technology, Accounting, Business or related field.
• One year of business systems analysis experience.
• Experience translating business needs into system requirements and user stories.

Responsibilities

• Analyze, interpret, and validate financial system data, workflows, and processes.
• Identify and understand database structures, including ERDs.
• Write SQL scripts to extract and troubleshoot data.
• Collaborate with Finance to resolve data inconsistencies and process inefficiencies.
• Support SharePoint development and Microsoft Forms for financial activities.
• Coordinate with IT/vendors to resolve system issues.
• Review and support QA testing, validation, and sign-off.
• Serve as Automation Coordinator for the department.

Skills

SQL scripting

Data analysis

Process improvement

Project management

QA testing

Communication

Education

Bachelor’s degree in Information Technology

Bachelor’s degree in Accounting

Bachelor’s degree in Business

Tools

Oracle

MUNIS

RAPIDS

Adobe Acrobat

Job description

The Financial IT Specialist at City of Richmond supports development, implementation, and optimization of technology-based solutions used within financial operations. This role focuses on improving business processes, defining system requirements, and translating needs into effective technology and process changes.

You will extract and interpret financial data, map workflows, assist with testing and deployment, train users, and coordinate with Finance, IT, and operational teams to ensure