Functional Systems Administrator (Financial Transactions Division)

Salary Grade: 12 Pay Range Hiring Range: $54,863 - $65,836 Annually Full Range: $54,863 - $76,809 Annually Salary offers are based on the candidate's equivalent experience and internal equity with other employees within the same job classification. 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 have the ability to be coached and learn quickly while demonstrating good communication and dependability. We are looking for an enthusiastic, skillful, 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.
• Assist in maintaining user security access; completing system configuration changes; completing system data reconciliations and balancing; and extracting system data using existing and ad-hoc created SQL queries.
• Work closely with IT business analysts and department personnel to troubleshoot ERP system-related issues.
• Participate in the ongoing County's multi-year ERP replacement project.

• 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.

(Work assignments may vary depending on the department's needs and will be communicated to the applicant or incumbent by the supervisor.) Assists in preparing, analyzing, reviewing, evaluating, and monitoring Countywide and multiple departmental operating and CIP budget requests; Assists in 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; Assists in providing technical assistance to departments engaged in budget preparation by explaining financial policies, procedures, and processes to ensure mutual understanding of requests and proper use of the automated budget system; Assists in the development of initial recommendations for department core funding levels based on revenue and expenditure projections overall program budgets and departmental performance measures; Assists in compiling, analyzing, and preparing budget data for publication in the annual Countywide Requested, Recommended, and Adopted Budget documents; Processes business and financial system user security access and approval workflow requests; Uses internal tools and procedures for reconciling and balancing financial data between multiple systems; Assists with providing user support and troubleshooting issues for business and financial systems used Countywide; Assists with testing of enhancements and configurations of business and financial systems used Countywide; Creates and maintains a chart of account elements in the County's financial system; Assists in ensuring county inventory is safeguarded by conducting reconciliations and observing departments are utilizing proper controls; Assists in the preparation of internal financial and budget reports by gathering, analyzing, tabulating, and interpreting data; Assists in monitoring multiple departments' spending throughout the year and assists in gathering data to be used to provide recommended forecast data; Gathers information for multiple departments' programs, goals, and objectives and compiles the data to be used to analyze those targets. KNOWLEDGE & SKILLS: Knowledge of:

• County policies and procedures;
• automated accounting systems, spreadsheet, and database applications;
• methods and techniques of financial management and budget preparation and analysis;
• data collection, research techniques, methodologies, and analysis methods;
• principles and practices of budgeting and accounting.

• communicating effectively, both orally and in writing;
• identifying problems and developing clear, concise, and logical conclusions and recommendations;
• researching, analyzing, interpreting, and auditing financial and budgetary data and preparing reports on findings;
• performing statistical and mathematical analysis.

(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. OR (2) An Associate's degree with a focus in accounting, finance, economics, public or business administration, or a closely related field as defined by the appointing authority at the time of recruitment from an accredited college or university and two years of professional experience in accounting, budgeting, auditing or accounting analysis, or financial management research. (Additional relevant experience and/or education from an accredited college or university may be substituted.) 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.):

• Master's degree in finance, accounting, business analytics, or a closely related field.
• Work or college-level course experience using Microsoft Excel or Microsoft Access.
• Customer service experience in a professional business setting.