Enterprise Resource Planning Administrator

City of Corvallis • City of Corvallis, OR

5d • Onsite

About The Position

The Enterprise Resources Planning (ERP) Administrator facilitates the design, implementation, and maintenance of enterprise application solutions. Works directly with stakeholders from City Departments including Human Resources and Finance to deliver solutions. Leads and performs system implementations, integrations, data design and management, report development, business and workflow analysis and project management activities. Performs a wide range of management, analytical and system maintenance functions. This is a Management Exempt / Non-represented Position. Schedule: Monday - Friday, 8:00am - 5:00pm.

Requirements

• Bachelor’s degree in Information Technology, Computer Science or a related field and a minimum of five years’ experience in system management, system configuration, system data analysis and/or system project implementation.
• OR High school diploma or equivalent and nine years’ experience in system management, system configuration, system data analysis and/or system project implementation.
• Post-secondary education in Information Technology, Computer Science or a closely related field may substitute for up to four years of experience.
• Knowledge of Financial, Payroll and Human Resources systems and business processes.
• Knowledge of Microsoft SQL Server database environments and the use of associated tools for integration development, database objects, and programming objects.
• Knowledge of structured IT change management frameworks and release governance practices.
• Knowledge of principles of technical vendor oversight, Statements of Work (SOW) structure, service-level agreements (SLAs), and public sector technology procurement practices.
• Knowledge of enterprise system security principles.
• Knowledge of principles and practices of information technology database administration, security policies and procedures, backup procedures and information systems pertaining to City departments.
• Skill in project management.
• Skill in analyzing information, research, and organizing work.
• Skill in using technical and analytical knowledge to solve technical problems and making effective decisions.
• Skill in effective oral and written communication.
• Skill in creating written communication materials that effectively summarize findings and support recommendations.
• Skill in promoting change in business processes through the creation of workflows, feature sets, and technological efficiencies.
• Skill in applying organizational and technical change management methodologies to evaluate impact, align stakeholder expectations, guide business process transitions, and drive end-user adoption.
• Skill in administering, maintaining, upgrading, patching, and analyzing complex database systems.
• Skill in generating solutions to address user needs.
• Ability to develop reports and write technical documentation, specifications, and procedures, and to provide end-user training.
• Ability to communicate technical information to a non-technical audience.
• Ability to direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and User Acceptance Testing).
• Ability to work independently and effectively on self-directed priorities and in-group settings with technical and non-technical staff.
• Ability to prioritize and manage multiple assignments and meet deadlines.
• Ability to manage vendor relationships, evaluate vendor performance and deliverables against SOW milestones and SLA requirements, and resolve scope or technical delivery disputes.
• Ability to analyze trends in the industry and make informed decisions about which alternative will have the best long-term value to the organization, based on knowledge of the organization and department’s goals and objectives.
• Ability to use computerized systems for extended periods of time in order to perform the essential functions of the position.
• Ability to attend and incorporate learning from approved trainings on a regular basis.
• Ability to provide training and assign tasks to project teams.
• Ability to provide excellent customer service, get along with coworkers, and maintain effective working relationships.
• Ability to maintain confidentiality and exercise high degree of discretion and judgment in dealing with sensitive or confidential information.
• Ability to remain on-call for after-hours, weekend, and holiday response.
• Ability to travel among City worksites and to training/ conferences.
• Ability to obtain and maintain CJIS security clearance, including completion of required security awareness training and a fingerprint-based background check.
• Demonstrable commitment to sustainability.
• Demonstrable commitment to promoting and enhancing diversity, equity and inclusion.

Nice To Haves

• Experience with on-prem and cloud-based public sector integrated ERP software.
• Experience in and a working knowledge of Tyler Technologies platform.
• Experience in and a working knowledge of NeoGov Software.
• Experience in and a working knowledge of Microsoft Windows server and client operating systems.
• Experience in and a working knowledge of Microsoft SQL databases (SSAS, SSIS, SSMS, SSRS).
• Experience in and a working knowledge of Microsoft Power BI.
• Experience reviewing Statements of Work (SOWs) and coordinating external software vendor/consultant deliverables.
• Project Management Professional (PMP) Certification preferred.
• Certified Change Management Professional (CCMP) Certification or similar preferred.

Responsibilities

• Serve as subject matter expert on multiple complex Human Resources, Payroll and Financial systems, databases, and application platforms.
• Manage implementation including installation, configuration, testing, data validation, support, and ongoing enhancements.
• Ensure ERP systems are kept current, efficient and match the needs of the organization.
• Design and develop ERP reports.
• Extract, transform and load data between various sources.
• Collaborate with city staff and subject matter experts to identify information and reporting requirements.
• Facilitate system training and communication.
• Train managers and end users to ensure understanding; develop and deliver user group presentations and support sessions; prepare instructional documents and resources.
• Provide effective and efficient customer service to internal and end users.
• Analyze issues, errors, and trends, determines root causes, and address problems in a collaborative team environment.
• Provide troubleshooting support and advice in response to system errors by evaluating data, processes, and requirements, and working with city staff to resolve issues.
• Provide technical assistance on applications in development and production.
• Participate in quality assurance and quality control checks.
• Manage technical vendor and consultant engagements supporting ERP platforms and related integrations.
• Review Statements of Work (SOWs), evaluate technical deliverables against contractual specifications, monitor Service Level Agreements (SLAs), and coordinate vendor resources throughout implementation and maintenance lifecycles.
• Lead and coordinate structured technical and operational change management processes for ERP system updates, integrations, and new product implementations.
• Partner with City departments to evaluate downstream workflow impacts, manage release testing and transition schedules, and support user adoption.
• Proactively survey existing ERP systems and develop, recommend, and deploy solutions that enhance system optimization and user experience levels.
• Drive technology innovation, identify alternative solutions, and implement new system technologies, capabilities, solutions, and tools.
• Perform research and remain informed of industry trends and best practices and make recommendations related to Human Resources and Financial applications to provide creative, efficient, and effective solutions.
• Ensure successful application and database interfaces; install and test various system and application software packages.
• Provide project leadership by exercising independent judgment in developing the ERP applications and managing the scope to meet deadlines.
• Conduct project management activities including business case development, requirements-gathering, cost estimates, project tasks, Information Technology personnel support, and resource planning.
• Work with stakeholders to collaboratively develop project plans.
• Ensure all required documentation and reporting is completed in accordance with City standards.
• Conduct post-project evaluations.
• Provide technical analysis including designing and maintaining complex applications and troubleshooting systems containing highly sensitive information.
• Access sensitive and confidential information concerning management policies in the area of collective bargaining.
• Comply with City and department policy regarding access, and maintain the confidentiality of the information.
• Participate in the Emergency Management program including planning, classes, training sessions, exercises and emergency events as required.
• Respond as directed during unforeseen events, inclement weather, emergencies, or officially declared States of Emergency to support the continuity and restoration of critical public services, facilities, and infrastructure.
• Act ethically and honestly; apply ethical standards of behavior to daily work activities and interactions.
• Build confidence in the City through own actions.
• Maintain effective work relationships.
• Conform with all safety rules and perform work in a safe manner.
• Deliver excellent customer service to diverse audiences.
• Adhere to all City and Department policies.
• Arrive to work, meetings, and other work-related functions on time and maintain regular job attendance.
• Perform other duties as assigned.

Benefits

• The City of Corvallis offers a comprehensive benefits package for Management Exempt employees. Benefits include medical, dental, vision, life insurance, disability insurance, paid holidays, paid sick leave, vacation leave, and retirement plan.

What This Job Offers

• Job Type: Full-time
• Career Level: Manager