Functional System Administrator (5270 - Financial Systems Analyst III - Financial Transactions Div)
OPEN UNTIL FILLED
Salary Grade: 15
Salary: $66,536.00 Annually
Pima County's Department of Finance and Risk Management is looking for a skilled, motivated individual to join its Financial Transactions Division. The successful candidate will work on a dedicated team of professionals who are responsible for delivering functional administrative support for Pima County's ERP (Enterprise Resource Planning) systems including the Financial, Budgeting, and Work Management systems. Primary tasks include maintaining the reliability of the ERP systems and providing support to all County users. The ideal candidate will demonstrate the ability to prioritize tasks and meet deadlines while emphasizing accuracy and attention to detail. We are looking for an enthusiastic, dependable, computer-savvy team player with a positive attitude to join our team.
What you'll do:
Work on a team with 3 to 5 other functional system administrators responsible for supporting the County's ERP systems.
Maintain user security access; complete system configuration changes; complete system data reconciliations and balancing; and extract system data using existing and ad-hoc created SQL queries or reports.
Work closely with IT business analysts and department personnel to troubleshoot ERP system-related issues.
Work closely with IT business analysts and department personnel on the enhancement of functionality in the existing ERP systems and the deployment of new ERP systems.
What we're looking for:
An individual who is devoted to providing exceptional customer service.
A team player who enjoys collaborating with co-workers and other County department personnel to achieve a common goal.
A problem solver who is great at seeing system issues for the first time and coming up with innovative ways to approach and resolve issues.
A learner who is looking for a teacher to coach and mentor them on skills that will support them in this position as well as achieving their career goals.
A dependable and reliable employee who is devoted to upholding the mission, vision, and values of our department.
The first review of applications will be on 09/27/2024.
Duties/Responsibilities
(Work assignments may vary depending on the department's needs and will be communicated to the applicant or incumbent by the supervisor.)
Conducts Countywide and departmental budgetary and financial studies concerning current and projected fiscal and operational matters, and develops recommendations on the feasibility of initiating new programs and maintaining or expanding existing services;
Establishes work plans, gathers and analyzes financial and operational data, and prepares reports, listing assumptions, methodologies, findings and recommendations;
Conducts revenue and expenditure forecasting studies and conducts financial impact analyses;
Reviews, analyzes, monitors, evaluates and reports findings related to specifically designated County expense and revenue contracts;
Prepares, analyzes, reviews, evaluates, and monitors Countywide and multiple departmental operating and Capital Improvement Program (CIP) budget requests;
Analyzes Countywide and multiple departmental requests for capital improvement expenditures, obtains information for new requests, and recommends appropriate levels of funding;
Updates Countywide and multiple departmental operating and capital budgets to reflect operating and funding changes;
Researches, analyzes and makes recommendations on departmental requests for additional funding;
Researches, analyzes, and develops recommendations on departmental requests for amendment(s) to the approved CIP;
Monitors and evaluates Countywide and multiple departmental operating budgets and CIP budgets and develops a report on findings with appropriate recommendations;
Provides technical assistance to multiple departments engaged in budget preparation by explaining budget procedures and processes to ensure mutual understanding of the budget requests and in the use of the budgeting system;
Provides zero base budget training (e.g. program/services structure, line-item justifications, goals/objectives/performance measures etc.) to all County departments;
Analyzes the fiscal impact of changes to legislation considered or enacted by the federal, state and local government;
Designs econometrics models to forecast departmental expenditures and revenues, identifies anomalies and prepares monthly and annual reports on long-term projections;
Develops projections and trends using microcomputer software for modeling and forecasting;
Interprets and applies established policies and procedures relating to the operating budgets and CIP budgets and develops recommendations for their revision;
Interprets the budget amendment process for departments;
Participates in the design, development and testing of the budgeting system, screens, and reports;
Prepares the budgeting for annual distribution and use by all County departments;
Researches and gathers various benefits and other information for inclusion in the budgeting, including health, social security, workers' compensation, unemployment insurance, and retirement;
Contacts all taxing jurisdictions in Pima County and compiles listings of property tax rates and levies, as part of the annual Tax Assembly process;
Prepares multiple sections for the annually published Pima County Recommended and Adopted Budget Books.
KNOWLEDGE & SKILLS:
Knowledge of:
data collection, research and fiscal audit methods, designs and technique;
mathematics and statistics as applied to budgetary control and financial management;
general governmental financial and budgetary principles and practices;
automated accounting systems, word processing, spreadsheet and database applications.
methods and techniques of financial management, budget preparation and analysis;
federal, state and local laws and regulations as applied to budget and financial management.
Skill in:
researching, analyzing, interpreting and auditing financial and budgetary data and preparing reports on findings;
developing logical conclusions and preparing recommendations;
performing applicable statistical and mathematical analysis;
communicating effectively, both orally and in writing;
identifying budgetary problems and developing concise recommendations for revision and improvement;
developing long-/short-term financial forecasts;
using a computer to produce reports and spreadsheets;
analyzing management systems and operating efficiencies;
use of computer-based resources to facilitate assigned work.
Minimum Qualifications
(1) A Bachelor's degree from an accredited college or university with a major in accounting, finance, economics, public or business administration or a closely related field as defined by the appointing authority at the time of recruitment and two years of professional level experience in accounting, budgeting, auditing, financial analysis or financial management.
(Additional relevant education from an accredited college or university and/or experience may be substituted.) (A CPA designation may substitute for one year of required experience.)
OR:
(2) Two years of experience with Pima County as an Accountant - Senior, Finance Analyst-Senior, Grant Accountant and Compliance Specialist, Financial Operations Specialist - Central Finance, Internal Auditor I or Finance Accountant - Principal.
Qualifying education and experience must be clearly documented in the "Education" and "Work Experience" sections of the application. Do not substitute a resume for your application or write "see resume" on your application.
Preferred Qualifications: (Be specific in describing your experience in your application. Ensure the descriptions provided illustrate your competencies, specifically addressing the required and preferred qualifications.):
Experience providing ERP system or software support to end-users.
Experience as a subject matter expert in one or more areas of a system or application.
Experience testing system fixes, system enhancements, or participating in a system upgrade or implementation.
Experience reconciling multiple systems, including data mining and data analysis.
Experience managing user access, approval workflows, or configuration changes in a system/application
Experience developing or executing SQL queries or using other industry-standard programming languages.
Bachelor's degree or higher in MIS, finance, accounting, or business analytics.