JOB
Under limited supervision, the Enterprise Resource Planning (ERP) and Budget Analyst reviews, analyzes, and evaluates business procedures and problems, compiles data, proposes solutions, identifies software bugs or modifications, and formulates the proper solution with IT support or other support. Performs budget analysis for departments, reviews and compiles budgeting for outcome indicators to prepare quarterly and annual budget reports, and reviews and assesses accounts, trends, and outcomes of budget dollars. Works with internal and external customers to coordinate purchasing opportunities and providing product or service research assistance to departments and employees.
Starting salary for this position will be between $64,625.60 and $74,942.40 based on previous experience.
EXAMPLE OF DUTIES
ESSENTIAL FUNCTIONS--Essential functions, as defined under the Americans with Disabilities Act, may include any of the followingrepresentative duties, knowledge, and skills. This list is ILLUSTRATIVE ONLY, and is not a comprehensive listing of all functions and duties performed by incumbents of this class. Employees are required to be in attendance and prepared to begin work at their assigned work location on the specified days and hours. Factors such as regular attendance at the job are not routinely listed in job descriptions, but are an essential function. Essential duties and responsibilities may include, but are not limited to, the following: Supports, assists, and provides exceptional analysis for ERP and Electronic Content Management (ECM) users operating various software and resolves problems; understands all functions of modules for Financial Management (FM), Human Resources (HR), Payroll, Accounts Payable, Budget, Rev Collections, Miscellaneous Billing, Asset Management; Purchasing and other reports; analyzes business procedures and problems, compiles necessary data to solve the issue, proposes a solution, and documents software bugs.Serves as budget analyst for assigned departments and authorized agencies; identifies issues, options, and projected outcomes and makes recommendations for all departments and authorized agencies; assists in the preparation of annual budgets for Administration and the Board of Supervisors.Serves as a resource for Scott County employees, departments, and authorized agencies; provides assistance with purchasing goods, materials supplies, equipment, and services. Includes preparing bid specifications and or requests for proposals. Analyzes bid and proposal responses, consolidates information, and forwards it to the requestor and others. Post request, bids or information on County’s vendor site, Public Purchase.Assists interested vendors in the registration process for doing business with Scott County.Completes and submits purchase orders to vendors or other appropriate parties; follows-up to verify items and delivery confirmation. Makes available purchasing decisions, for Public Access to Procurement Information and/or assist if needed with purchasing FOIA requests.Coordinates information or documentation of equipment, vehicles, and other qualified items to the ERP asset system.Assigns and maintains general ledger accounts and cost centers, capital and grant project numbers, payment codes and billing codes; analyzes accounts and identifies need for change and review for further analysis for Budget Administrative Services Director; assists and supports department managers and supervisors in preparing budget estimates and proposals and conducts research and analysis on proposed programs or other factors affecting budget requirements.Identifies and determines areas where change, use, or increased use of the ERP and ECM system would provide additional speed, accuracy, or efficiency; creates, customizes, designs, and updates Business Analytic reports based on requests and need of users, and prepares and modifies imports for needed processesCoordinates and facilitates testing for annual upgrades to software system, year-end upgrades, and weekly patches and updates; organizes testing with multiple departments, documents testing, offers problem solving and specialized knowledge.Prepares quarterly and annual budget reports; collects, compiles, and analyzes the Budgeting for Outcome Indicators report and identifies any issues with projected outcomes; coordinates, trains, and monitors the development and performance of budget analysts.Coordinates the preparation of special reports for departments, including reporting for ambulance services, conservation services and State of Iowa compliance.Supports grant coordinators in reporting requirements; reconciles federal grants within the ERP system; maintains and provides project level assignments and compiles data for annual Schedule of Federal Awards report.Attends and participates in user to provide users with updates, make recommendations, and receive feedback regarding current and future projects or needs.Demonstrates the ability to exemplify, by his/her actions, the County PRIDE philosophy.Performs related duties as assigned.
SUPPLEMENTAL INFORMATION
License and Certification RequirementsNone.Physical Demands and Working Environment: Work is performed in a standard office environment with limited exposure to adverse conditions.