ERP and Budget Analyst

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.

Job Responsibilities

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

Standards for Initial Consideration

Education, Training, and Experience Guidelines:
Bachelor's degree in business administration, public administration, social services, political science, education or a related field; AND three (3) years of accounting and financial experience; OR an equivalent combination of education, training, and experience.

Knowledge of:

• General office policies, procedures, and equipment.
• Problem resolution methods and practices.
• ERP and ECM user work processes.
• Budget development, implementation, and monitoring practices.
• Finance, purchasing, HR, payroll, capital assets and accounts payable procedures and modules.
• Applicable local, State, and Federal laws, codes, regulations, and ordinances.

Skill in:

• Preparing and presenting clear and concise reports.
• Prioritizing and organizing work to meet deadlines.
• Using word processing, spreadsheet, pivot tables and presentation software with a high level of proficiency.
• Maintaining confidentiality.
• Establishing and maintaining cooperative working relationships.
• Communicating effectively verbally and in writing.

Supplemental Information

License and Certification Requirements
None.

Physical Demands and Working Environment:
Work is performed in a standard office environment with limited exposure to adverse conditions.

Benefits

The following is a summary of benefits provided to non-union County employees. Benefits for employees covered under a collective bargaining agreement may vary somewhat depending on specific contract provisions.

• Scott County Employment Benefits