This is a highly responsible professional position providing functional and technical expertise in analysis, design, development, implementation, maintenance, documentation, testing, training, and ongoing support for all systems used by the Budget and Management Services Division. Primarily using Oracle Planning and Budgeting Cloud Services (Hyperion) programs. This position will serve as the functional lead and represent Budget and Management Services at core team meetings as well as at any other technology-focused meetings or events as assigned.
Serves as the first line of support for user-reported system issues or bugs, triaging and documenting problems for resolution.
Leads the design, implementation, maintenance, and support for updates and improvements within Hyperion and any other software applications utilized by the division, including the SmartView Excel add-in.
Designs, creates, tests, and maintains advanced reports and dashboards within the software applications utilized by the division.
Provides full support for the custom budget amendment application; completes monthly reconciliations of budget amendments into Budgetary Control and the General Ledger within Oracle and resolves any issues or discrepancies.
Performs the annual initial loading of the General Ledger and position data from Oracle into Hyperion, including data validation.
Manages the annual adopted budget upload from Hyperion into Oracle, including data validation; manages the upload of new positions created during the budget process.
Manages the monthly upload of financial data into the OpenGov application.
Develops and conducts training for new users, provides refresher training for existing users, and provides ongoing assistance to users with problems and questions.
Creates, updates, and maintains user guides and standard operating procedures, documents new features and processes in a way that makes complex information understandable to users without a technical background.
Develop SOP and complete all patch testing requirements for Hyperion (twice monthly) and Oracle as necessary, as well as any testing needed for other applicable systems.
Assists with the analysis of current business processes and workflows to identify opportunities for improvement and efficiency gains.
Assists in technical systems design from functional specifications.
Customer Service Skills: maintains in-depth knowledge of Budget and Management Services Division requirements and procedures; establishes and maintains constructive and cooperative working relationships among a diverse group of system users across all divisions, the Clerk of the Circuit Court and Comptroller’s Office, and the county’s IT Division; works with staff to identify development requirements and opportunities for systems utilized by Budget and Management Services.
Communication Skills : presents functional and technical data and conclusions to users and stakeholders at all levels within the organization in a way that is understandable to non-technical people.
Critical Thinking Skills : interpret functional data to determine testing outcomes, report success, and other outputs as assigned.
Problem-Solving Skills : diagnoses and resolves problems based on information provided by others.
Writing Skills writes memos, reports, user manuals, and SOPs to be used by non-technical staff.
Project Management Skills : manages projects from analysis through implementation for systems utilized by Budget and Management Services.
Performs other duties as assigned.
Knowledge of financial principles, budgeting, financial planning, forecasting, and reporting.
Knowledge of Hyperion including developing and modifying business rules and calculation scripts.
Knowledge of general business concepts.
Knowledge of system development methodologies and the ability to apply this knowledge in practice regarding the analysis and development of computer systems.
Knowledge of financial and organizational hierarchy; ability to understand a chart of accounts and account strings.
Ability and willingness to learn and maintain an in-depth knowledge of the division’s business.
Ability to create test plans and scripts, perform functional testing, and maintain system documentation.
Ability to learn and develop complex reports to obtain data from existing county financial systems (Oracle Cloud EPM, Hyperion - including SmartView Excel add-in, and OpenGov) and any future software packages used by Budget and Management Services.
Ability to lead a team and work as part of a team.
Ability to translate system requirements into program specifications.
Ability to follow oral and written instructions.
Ability to use independent judgement and make logical decisions.
Ability to maintain effective working relationships with people at all levels of the organization.
Ability to communicate effectively both orally and in writing to people at all levels of the organization.
Ability to maintain confidential information when necessary.
Ability to sit for long periods of time.
