Finance IT Analyst Senior

City of Richmond; Richmond (VA); On-site; USD 81,000 - 99,000; Full time

Job summary

The City of Richmond seeks a Finance IT Analyst, Senior to provide advanced analytical, technical, and operational support for financial systems within the Department of Finance. The role blends senior-level management analysis with specialized financial systems expertise, supporting system troubleshooting, data extraction, reporting, governance, and process improvement.

You will collaborate with leadership, end-users, technology partners, and external agencies to optimize financial operations,

Qualifications

• Bachelor's degree or equivalent in business, public administration, or related field.
• Experience in finance analysis, reporting, and governance.
• Strong analytical, communication, and collaboration skills.

Responsibilities

• Assist customers and end-users with system access, functionality, navigation, and issue resolution.
• Write SQL scripts to extract, review, validate, and troubleshoot financial data.
• Prepare dashboards, reports, forecasts, and data summaries for leadership and program stakeholders.
• Collaborate with Finance Administrative Unit to draft, revise, and maintain documentation such as policies, SOPs, desk aids, reports, and process maps.
• Participate in cross-functional project teams implementing new or upgraded financial technology solutions.

Skills

Analytical thinking

Critical thinking

Multi-tasking

Communication

Teamwork

Education

Bachelor's degree in business or public administration, or related field

Tools

SQL

Job description

The maximum hiring compensation range for this position is to not exceed 90,000/a year.

The Finance IT Analyst, Senior provides advanced analytical, technical, and operational support for financial systems and programs within the Department of Finance. This role blends senior-level management analysis with specialized financial systems expertise—supporting system troubleshooting, data extraction, reporting, governance, and technology-enabled process improvement. The position independently evaluates complex issues, supports decision-making, and contributes to department-wide technology initiatives, financial process improvements, and policy development. The incumbent frequently collaborates with leadership, end-users, technology partners, and external agencies to optimize financial operations and strengthen the integrity, accessibility, and accuracy of financial data.

This position is considered an Essential Personnel, which means that the incumbent is required to work when the City is closed due to public emergencies, critical or hazardous conditions or inclement weather.

Key Responsibilities:

Financial Systems Support & Troubleshooting:

• Assist customers and end-users with system access, functionality, navigation, and issue resolution.
• Perform troubleshooting of technical and financial system issues, escalating to IT or vendors when necessary.
• Analyze root causes of system errors and recommend corrective actions.
• Review system data flows, configuration, and interface points to ensure accuracy and operational continuity.
• Support QA validation, verification, and testing.

Data Analysis, Reporting & SQL/Database Work:

• Write SQL scripts to extract, review, validate, and troubleshoot financial data.
• Identify, understand, and leverage database structures, including interpretation of entity relationship diagrams (ERDs).
• Compile, analyze, and interpret statistical and financial data to support program evaluation and operational decision-making.
• Prepare dashboards, reports, forecasts, and data summaries for leadership and program stakeholders.
• Support Data Warehouse and Data Analytics initiatives

Program, Process, & Operational Analysis:

• Analyze and coordinate the administrative and operational performance of programs and projects, particularly those involving financial functions.
• Conduct complex financial analyses, reconciliations, and reviews of financial transactions.
• Collaborate with Finance Administrative Unit to draft, revise, and maintain documentation such as policies, SOPs, desk aids, reports, and process maps.
• Evaluate program and system performance, identify gaps, and recommend improvements.

Governance, Compliance & Internal Controls Support:

• Collaborate with Finance Administrative Unit to support development and implementation of governance frameworks, program policies, and technology-supported administrative processes.
• Ensure adherence to regulations, standards, and departmental requirements related to financial system integrity and reporting.
• Participate in audits, system reviews, and process assessments to identify risks, compliance issues, or control needs.
• Oversee or contribute to processing and validation of complex financial transactions.

Project & Technology Implementation Support:

• Participate in cross-functional project teams implementing new or upgraded financial technology solutions.
• Support system testing, validation, user acceptance, and readiness activities.
• Assist in documenting requirements, assessing system impacts, and facilitating end-user training.
• Coordinate project tasks, timelines, and communication between Finance, IT, and external partners.

Stakeholder Engagement, Communication & Liaison Work:

• Participate in cross-functional project teams implementing new or upgraded financial technology solutions.
• Support system testing, validation, user acceptance, and readiness activities.
• Assist in documenting requirements, assessing system impacts, and facilitating end-user training.
• Coordinate project tasks, timelines, and communication between Finance, IT, and external partners.

Leadership, Guidance & Collaboration:

• Serve as a lead worker when assigned, guiding professional, paraprofessional, or support staff.
• Provide training, coaching, and mentoring related to systems, reporting, processes, or compliance requirements.
• Support departmental efforts to standardize practices, develop consistent procedures, and improve service delivery.

KNOWLEDGE, SKILLS, AND ABILITIES:

Knowledge (some combination of the following):

• Analysis and reporting of data
• Audit practices
• Basic accounting knowledge
• Debt and grant management
• Economic and accounting principles
• Background in department of focus
• EDI processes and guidelines
• Education and training principles
• English language including the meaning and spelling of words, composition, and grammar
• General financial reporting
• Laws, rules, and fines in and around ACH transactions
• Ordinances, government regulations, agency rules, and the legislative process
• Payment systems
• Payroll accounting
• Principles for providing customer service, including meeting quality standards for services and customer satisfaction

Skills (some combination of the following):

• Analyzing complex issues
• Building budgets, expenditures, and revenue forecasts
• Communicating with various internal and external departments
• Drafting and revising documents
• Forecasting
• Managing multiple priorities and deadlines
• Managing program in focus area
• Overseeing financial transactions
• Preparing forecasts, reports, analyses for special projects, etc.
• Supporting various activities in area of focus
• Teaching and instructing individuals and groups
• Oral and written communication

Abilities (some combination of the following):

• Adapt
• Analyze information
• Make decisions
• Multi-task
• Problem solve
• Work in teams

MINIMUM TRAINING AND EXPERIENCE:

• Bachelor's degree in business or public administration, or field related to assignment
• Four years of journey-level professional experience in area related to assignment, such as program/project management or management/policy/financial analysis
• An equivalent combination of training and experience (as approved by the department) may be used to meet the minimum qualifications of the classification

PREFERRED TRAINING AND EXPERIENCE:

• Well versed and proficient in finance-based jargon, systems, and reporting.
• Proven ability to identify, understand, and leverage database structures and interpret entity relationship diagrams (ERDs).
• Ability to write SQL scripts for extraction, review, and troubleshooting of financial data.
• Bachelor's degree in business or public administration, or field related to assignment

Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions of the job. Prospective and current employees are invited to discuss accommodations.

ENVIRONMENTAL HAZARDS: Working conditions may include exposure to travel to other locations within the City of Richmond as well as outside of the City of Richmond; exposure to hazardous physical conditions such as mechanical parts, electrical currents, vibrations, etc.; atmospheric conditions such as fumes, odors, dusts, gases, and poor ventilation; inadequate lighting; intense noise; and environmental hazards such as disruptive people, imminent danger, and a threatening environment.

Physical Requirements and Working Environment:Due to the nature of work assignments, incumbents must be able to perform detailed work on multiple, concurrent tasks, with frequent interruptions and under time constraint. The essential duties of this classification may require the ability to regularly talk, hear, and see; frequently reach and perform repetitive motions; and occasionally stoop, kneel, crouch, stand, walk, push, pull, lift, finger, grasp, and feel. The working conditions may not include environmental hazards. In terms of the physical strength to perform the essential duties, this classification is considered to be sedentary, exerting up to 10 pounds of force occasionally, and a negligible amount of force frequently or constantly to move objects.