Financial Data & Systems Analyst

City Of Roswell•Roswell, GA

17h•$72,242 - $93,913•Onsite

About The Position

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.

Requirements

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.
Must possess a valid State of Georgia Driver’s License or obtain one within 90 days.
Knowledge of performance management frameworks, strategic planning processes, and business process improvement methodologies applicable to municipal operations.
Demonstrated ability to assess, improve, and redesign operational processes to enhance efficiency, effectiveness, and service delivery.
Ability to understand the operations, workflows, and business functions across various city departments and apply that knowledge to support analysis, planning, and continuous improvement initiatives.
Knowledge of quantitative and qualitative analysis techniques, statistical methods, and forecasting models to inform executive-level decision-making.
Proficiency in Microsoft Office Suite with advanced expertise in Excel and PowerPoint, and demonstrated experience using data visualization platforms such as Power BI or Tableau.
Familiarity with statistical and analytical tools such as SPSS, SQL, Minitab, or comparable software for evaluating large datasets and producing evidence-based insights.
Understanding of enterprise systems and the ability to use or learn financial and operational platforms (e.g., Munis, PeopleSoft, Workday).
Strong analytical and critical thinking abilities, with the capacity to interpret complex data and convert findings into actionable recommendations.
Excellent written and verbal communication skills, with the ability to tailor content for technical and non-technical audiences, including senior leadership and elected officials.
Strong project management skills, with the ability to plan, prioritize, and manage multiple initiatives simultaneously under minimal supervision.
High attention to detail and accuracy in reporting, data interpretation, and process documentation.
Ability to build collaborative relationships with staff at all levels and foster a culture of innovation and continuous improvement.
Strong integrity, discretion, and professionalism when handling confidential or politically sensitive information.

Nice To Haves

Master’s Degree and professional certifications such as Six Sigma, PMP, dashboard creation, or similar credentials are preferred.
Commitment to public service, operational excellence, and data-informed governance and community affairs is preferred.

Responsibilities

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.
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.
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.
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.
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.
Perform other related duties as assigned.