ERP Specialist

GUILFORD COUNTY GOVERNMENT

Empower Successful People to thrive in a Strong Community supported by Quality Government

Description

GENERAL STATEMENT OF DUTIES

This professional and technical position provides support for enterprise resource planning (ERP) systems and is also responsible for creating, maintaining, and supporting software applications, integrations, and analytical reports. This role combines business analysis, technical delivery, and production support to ensure reliable and effective enterprise-ERP solutions.

DISTINGUISHING FEATURES OF THIS CLASSThe ERP Specialist serves as a business requirements analyst, software developer, and application support resource. The role also includes task leadership responsibilities and coordination of resources across teams to complete assignments and utilizes AI tools when permitted to optimize the creation and delivery of enterprise solutions effectively and efficiently. This position reports to the Enterprise Applications Manager within the Information Technology Department.

Examples of Duties

DUTIES AND RESPONSIBILITIES

Essential duties and responsibilities include, but are not limited to:

• Provide configuration, integration, troubleshooting, and end user support for human resources ERP modules and timekeeping systems.
• Analyze departmental business processes and translate requirements into detailed specifications for purchased or internally developed applications.
• Develop, support, modernize, test, deploy, optimize interfaces and integration across enterprise applications using various software and scripting languages using industry best practices.
• Recommend and implement improvements for assigned applications.
• Develop and maintain high-quality documentation that assists IT staff and end users with ERP and non-ERP applications, business processes, requirement designs, support procedures, and knowledge transfer,
• Develop test plans, scripts and datasets for units, integration, system, and user acceptance testing.
• Manage or conduct ERP and other enterprise applications testing efforts.
• Update applications to implement enhancements, defect fixes, and improve operational efficiency.
• Collaborate with cross-departmental teams to resolve problems and deliver solutions
• Communicate effectively with coworkers and IT staff to provide responsive, high-quality support services.
• Design and develop complex business reports and data extracts based on detailed requirements.
• Perform other duties as assigned.

RECRUITMENT STANDARDS

Knowledge, Skills, and Abilities

• ERP Systems
• Knowledge and experience supporting modules such as Human Resources, Payroll, Benefits Administration, Talent Management & Recruiting, Employee Self-Service.
• Knowledge and experience supporting workforce management systems (ex. UKG).
• Knowledge and experience planning, managing, executing, or participating in system upgrades.
• Knowledge and experience working with departmental leadership, end users, and vendors to identify and resolve problems with ERP systems and update these systems as needed.
• Knowledge and experience integrating ERP systems with other applications.
• Knowledge and experience with workflow configuration, user administration, and role-based access control preferred.
• Knowledge and experience with Lawson and UKG implemented for public-sector preferred.
• Open to learning other ERP modules like Financials, Budget, EPL etc.
• Working knowledge of .NET, C#, VB.NET, Postman, Power Automate, and utilization of RESTful APIs.
• Knowledge and experience with units, integration, system, and user acceptance testing of batch and online applications.
• Knowledge and skills working with Microsoft SQL Server SSIS development and administration for Extraction Transformation and Loading and interface file creation tasks.
• Knowledge of database security and basic administrative functions.
• Knowledge of Visual Studio, and GitHub repositories.
• Skills with Microsoft SQL Server and Transact SQL.
• Skills in SSRS and Power BI report/dashboard development preferred.
• Ability to develop stored procedures, complex queries, and optimized SQL solutions.
• Ability to lead tasks supporting small to medium non-ERP applications, including implementations of newly purchased systems.
• Programming Skills Utilizing AI Tools
• Working knowledge of .NET, C#, VB.NET, Postman, Power Automate, and utilization of RESTful APIs.
• Knowledge and experience with units, integration, system, and user acceptance testing of batch and online applications.
• Knowledge and skills working with Microsoft SQL Server SSIS development and administration for Extraction Transformation and Loading and interface file creation tasks.
• Knowledge of database security and basic administrative functions.
• Knowledge of Visual Studio, and GitHub repositories.
• Skills with Microsoft SQL Server and Transact SQL.
• Skills in SSRS and Power BI report/dashboard development preferred.
• Ability to develop stored procedures, complex queries, and optimized SQL solutions.
• Ability to lead tasks supporting small to medium non-ERP applications, including implementations of newly purchased systems.
• Knowledge of change management and service desk procedures.
• Working knowledge of project management methodologies, including Agile and Waterfall.
• Excellent written, oral, and interpersonal communication skills.
• Ability to demonstrate strong attention to detail in analysis, testing, documentation and production support.
• Ability to demonstrate initiative and curiosity to learn new skills independently, adapt quickly to changing priorities, and remain open to new ERP platforms and tools.
• Ability to apply critical thinking and structured problem solving to diagnose root causes and recommend practical and sustainable solutions.
• Ability to work independently with minimal supervision.
• Ability to establish and maintain effective working relationships within and across departments.

Typical Qualifications MINIMUM QUALIFICATIONSFour-year degree in Information Technology, Computer Science or related field with at least 3 years of experience performing the functions of systems analyst and at least 4 years of experience as a programmer. OR a two-year degree in Information Technology, Computer Science or a related field with at least 5 years of experience performing the functions of systems analyst and at least 6 years of experience as a programmer: OR High School diploma or GED with at least 7 years of experience performing the functions of systems analyst and at least 8 years of experience as a programmer. Supplemental Information Physical DemandsAn employee in this position must be able to perform the basic life operational functions of fingering, talking, hearing, and repetitive motions. The employee must be able to perform sedentary work exerting up to 10 pounds of force occasionally to move objects. The employee is required to have close visual acuity for transcription.

Working ConditionsWork consists of an office environment. The worker is not substantially exposed to adverse environmental conditions.

May Require Driving This position may require driving for this position whether driving a County owned or personal vehicle to conduct county business such as but not limited to attending conferences, meetings, or any other county related functions. Motor Vehicle Reports may be verified for valid driver’s license and that the driving record is compatible with the county’s driving criteria. If a personal vehicle is operated for county business proper insurance is maintained as per Guilford County’s vehicle use policy.

Special Note: This generic class description gives an overview of the job class, its essential job functions and recommended job requirements. However, for each individual position assigned to this class, there is available a completed job description with physical abilities checklist which can be reviewed before initiating a selection process. They can provide additional detailed information on which to base various personnel actions and can assist management in making legal defensible personnel decisions.

Benefits

We are excited about the opportunity of having you as a prospective new employee! You probably already know our county is a wonderful county to live in, but did you know it is also a wonderful place to work? Below are a few of the reasons why we love working for Guilford County. We offer Health Insurance (UnitedHealthCare) to all benefitted employees working a minimum of 20 hours per week. The shared cost of the premium is based on scheduled/budgeted hours. If you are a full-time employee working 40 hours a week you can expect to pay less than $35 a month for medical coverage, dental coverage for $4 a month and vision coverage for $5 a month. That's less than $45 a month for medical, dental & vision coverage; that's unheard of. Telehealth UHC Virtual Visits are available to you with no copay or out of pocket expense. We are excited to inform you Guilford County has an Employee Wellness Center (24/7 access) with strength training equipment, cardio machines and a group exercise room with virtual or in person coaching from our Wellness Specialist! Employee Assistance Program, 100% funded by the county. A superb benefit for you and your family absolutely free. Confidential help with personal or work-related issues. 13 paid holidays, 12 sick days, and 12 vacation days a year. That's 37 paid days a year, totaling almost 2 months of paid time off. Employer contributes 5% into your 401(k) - no match required. Enrollment in the State Retirement Plan by contributing 6%. Longevity pay beginning at five years of service. We provide a $10,000 Life and AD&D benefit to eligible employees. Flexible spending accounts (FSA) allow you to set aside tax-free dollars for health care and dependent care. Voluntary Life, AD&D, Short-Term and Long-Term Disability.

Guilford County is committed to providing Equal Employment Opportunity (EEO) to employees and applicants for employment regardless of color, religion, sex, national origin, age, disability, genetic information, sexual orientation or political affiliation. The County is committed to complying with all applicable federal, state and local laws that pertain to employment, and to providing a work environment that is free from discrimination of any kind. If you need an auxiliary aide, make the request forty-eight (48) hours in advance of the time the accommodation is needed by calling 336-641-3324.