Financial Data & Systems Analyst

Financial Data & Systems Analyst

The Financial Data & Systems Analyst serves as a technical and analytical resource for the City's financial systems, budget databases, forecasting, and enterprise reporting. This position administers and maintains financial management systems, develops and analyzes complex financial data, and creates automated reports, dashboards, and key performance indicators (KPIs) that support budget development, long-range financial planning, and executive decision-making. Working collaboratively with Finance, Information Technology, and City departments, the Financial Data & Systems Analyst improves business processes through data integration, automation, and advanced analytics while ensuring the integrity, security, and reliability of the City's financial information.

Financial Systems Administration

• Serve as an administrator for the City's budget, forecasting, and financial management systems.
• Maintain complex financial databases containing operating, capital, personnel, grant, and project budget information.
• Configure and maintain system workflows, business processes, and user access.
• Coordinate software upgrades, testing, implementation of new functionality, and customer relationships.
• Troubleshoot financial system issues and provide technical support and training to Finance staff and departmental users.
• Develop and maintain system documentation, business procedures, and user training materials.
• Evaluate existing financial systems and recommend enhancements that improve efficiency, reporting capabilities, and data integrity.

Enterprise Financial Data Management

• Adopt and maintain enterprise financial databases supporting the City's operating budget, capital improvement program, grants, debt, and long-range financial plans.
• Develop and maintain financial data models supporting revenue forecasting, expenditure analysis, personnel budgeting, capital planning, and financial performance measurement.
• Collect, validate, reconcile, and maintain large financial datasets from multiple enterprise systems while ensuring data accuracy and consistency.
• Design and implement automated data validation processes to improve data quality and reduce manual processing.
• Develop SQL and DAX queries, data extracts, integrations, and automated workflows supporting financial reporting and analysis.
• Monitor financial data quality across multiple systems and recommend corrective actions when discrepancies are identified.
• Develop standards and procedures for financial data governance, documentation, and reporting consistency.

Budget Management & Financial Analysis

• Support development and administration of the City's annual operating and capital budgets.
• Develop and maintain multi-year financial forecasts projection models, and scenario analyses.
• Monitor revenues, expenditures, personnel costs, grants, and capital tracking throughout the fiscal year.
• Analyze budget trends, financial variances, and organizational performance to identify opportunities, risks, and emerging issues.
• Assist departments with budget preparation, financial planning, forecasting, and performance measurement.
• Develop financial models supporting strategic planning and long-range financial sustainability.

Business Intelligence & Reporting

• Develop, maintain, and enhance executive dashboards, financial reports, and enterprise key performance indicators (KPIs).
• Design automated reporting solutions that improve efficiency and reporting accuracy.
• Produce recurring and ad hoc financial analyses for internal and external stakeholders.
• Utilize data visualization techniques to communicate financial information clearly and effectively.
• Develop interactive dashboards supporting departmental performance and organizational decision-making.

Process Improvement & Innovation

• Identify opportunities to automate budgeting, forecasting, reconciliation, and reporting processes.
• Lead initiatives that improve financial reporting efficiency through technology and process redesign.
• Research emerging technologies, analytics tools, and financial reporting best practices.
• Participate in cross-functional projects supporting enterprise data management and organizational performance improvement.

Other Duties

• Perform other related duties as assigned.

Education and Experience:

• Requires a Bachelor's Degree in Business, Finance, Data Analytics, Public Administration, Economics, or a related field from an accredited institution; three years of progressively responsible experience in financial planning and analysis, data analytics, project management, or performance improvement; or an equivalent combination of education, training, and experience.

Licenses or

Certifications:

• Must possess a valid State of Georgia Driver's License or obtain one within 90 days.
• Master's Degree and professional certifications such as Six Sigma, PMP, dashboard creation, or similar credentials are preferred.

• Knowledge of performance management frameworks, strategic…