Enterprise Resource Planning Administrator

City of Corvallis Information Technology
The Information Technology Department provides robust, reliable, and innovative technology services across the organization. The department supports operational efficiency and employee productivity by delivering high-quality information technology services and innovative solutions. IT staff are committed to excellence in service, performance, and reliability while fostering a culture of collaboration, innovation, and stewardship.

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.  

Schedule: Monday - Friday, 8:00am - 5:00pm
Management Exempt / Non-represented Position

To be considered you must include a resume and answer to supplemental question. Cover letter is preferred. 

First review of applications will be at 8:00am on October 19th. Then reviewed weekly as needed.

Duties include, but are not limited to the following:

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

It is the responsibility of all City of Corvallis employees to:

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

Qualifying Education / Experience

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

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

Desired Qualifications

• Experience with on-prem and cloud-based public sector integrated ERP software.
• Experience in and a working knowledge of the following:
  1. Tyler Technologies platform
  2. NeoGov Software
  3. Microsoft Windows server and client operating systems
  4. Microsoft SQL databases (SSAS, SSIS, SSMS, SSRS)
  5. Microsoft Power BI
• Experience reviewing Statements of Work (SOWs) and coordinating external software vendor/consultant deliverables.

Certifications / Licenses

• Project Management Professional (PMP) Certification preferred.
• Certified Change Management Professional (CCMP) Certification or similar preferred.

Knowledge / Skills / Abilities
Knowledge of: Financial, Payroll and Human Resources systems and business processes; Microsoft SQL Server database environments and the use of associated tools for integration development, database objects, and programming objects; structured IT change management frameworks and release governance practices; principles of technical vendor oversight, Statements of Work (SOW) structure, service-level agreements (SLAs), and public sector technology procurement practices; enterprise system security principles; 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; analyzing information, research, and organizing work; using technical and analytical knowledge to solve technical problems and making effective decisions; effective oral and written communication; creating written communication materials that effectively summarize findings and support recommendations; promoting change in business processes through the creation of workflows, feature sets, and technological efficiencies; applying organizational and technical change management methodologies to evaluate impact, align stakeholder expectations, guide business process transitions, and drive end-user adoption; administering, maintaining, upgrading, patching, and analyzing complex database systems; generating solutions to address user needs.

Ability to: develop reports and write technical documentation, specifications, and procedures, and to provide end-user training; communicate technical information to a non-technical audience; direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and User Acceptance Testing); work independently and effectively on self-directed priorities and in-group settings with technical and non-technical staff; prioritize and manage multiple assignments and meet deadlines; manage vendor relationships, evaluate vendor performance and deliverables against SOW milestones and SLA requirements, and resolve scope or technical delivery disputes; 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; use computerized systems for extended periods of time in order to perform the essential functions of the position; attend and incorporate learning from approved trainings on a regular basis; provide training and assign tasks to project teams; provide excellent customer service, get along with coworkers, and maintain effective working relationships; maintain confidentiality and exercise high degree of discretion and judgment in dealing with sensitive or confidential information; remain on-call for after-hours, weekend, and holiday response; travel among City worksites and to training/ conferences; use the following tools and/or equipment: multi-line phone system, cell phone, computers with associated software, computer equipment, computer tablet, copy and fax machines, and other related tools and equipment; obtain and maintain CJIS security clearance, including completion of required security awareness training and a fingerprint-based background check.

In Addition: the employee shall not pose a direct threat to the health or safety of the individual or others in the workplace; have demonstrable commitment to sustainability; and have demonstrable commitment to promoting and enhancing diversity, equity and inclusion.

Qualified applicants must submit an online application located on the City of Corvallis website(click on “Apply” above).  

First review of applications will be October 19th. Then reviewed weekly as needed.

To be considered you must include a resume and answer to supplemental question.

Applications will be accepted until position is filled.

Resumes will not be accepted in lieu of a completed online application. Late or incomplete applications will not be accepted/considered. 

*Please do not include personal or protected information in attached resumes or cover letters, this includes your birth date, age, dates of education, and graduation dates.*