Charleston County is looking for an experienced ERP Systems Specialist to join our team. The ERP System Specialist will be the lead technical resource for the County’s Enterprise Resource Planning (ERP) software and is responsible for supporting, maintaining and developing application software to ensure there is no disruption to the operations of the core functionalities: HR, Payroll, Finance (GL & AP), Budget and Procurement. This position will also provide functional analysis and application knowledge to support these mission critical functions.

HIRING SALARY RANGE: $90,272 - $118,310 (salary dependent upon applicant’s qualifications)

PAY RANGE: $90,272 to $146,328

Duties and Responsibilities (order does not indicate importance)

Provides support, maintenance and development for our financial/HR ERP system and auxiliary applications. Monitors application and job servers. Designs and/or maintains system tables and configuration, scheduled jobs, interfaces, screen defaults, custom menus and executables. Assists end users with technical issues and documents problem resolution and new processes. 

Writes complex queries for data extracts in response to routine requests, audits, investigations and FOIAs. Designs/maintains custom/canned reports using the ERP’s proprietary report writing tool (CDD) and Cognos. Reviews data and reports any issues to applicable end users for corrective action. Makes recommendations on data cleanup and archiving. Updates database using SQL utilities to do mass inserts, updates and deletions of records.

Supports Payroll staff with all issues related to payroll processing, including time entry, pay policies, mandatory deductions (e.g., FICA, Medicare, FIT/SIT and retirement) and wage calculations. Writes and modifies payroll calculation codes as contributions/deductions/hour codes are added or updated, pay policies are enacted or calculation inconsistencies are noted. (Requires considerable testing and is one of the highest risk responsibilities of this position.) Assists with annual reconciling and generating tax documents for employees and vendors (i.e., W2, ACA, 1099-MISC, 1099-NEC). 

Leads the technical effort for periodic implementation of new functionality, modules or upgrades including associated third-party solutions. Participates in the solicitation process for ERP related solutions or services by helping draft scope, providing feedback and assisting in the selection process. Assists with other special projects indirectly related to our ERP.

Coordinates with other internal IT teams. Duties include: providing technical training and system overview to new technical team members; scheduling Windows patching, disaster recovery efforts and auxiliary system updates; and troubleshooting issues arising from the same that impact our ERP. 

Collaborates with core departments to provide analytical and consultative support on functional matters, including making recommendations for streamlining, best practices and alternative solutions. Evaluates the impact of new or proposed policies/mandates/functionality on business processes and ERP configuration and provides feedback.

Working Conditions and Relationships

While there is specific direction for some tasks/projects, much of the work performed is goal-oriented, achieved with independent analysis and supplemented with collaborative discussion with the end users. Regularly interacts with other managers from the core departments both in an advisory and technical capacity to assist them with problem resolution, project planning and implementation. 

Often works on multiple projects concurrently and thus must be flexible to handle new/unexpected challenges quickly. Some issues may be related to normal functions but are time-sensitive, other challenges are related to new agency policies or federal/state mandates that need to be addressed with a very short turnaround. Many of these projects are related to employee records/pay and involve sensitive personal information (e.g., SSN, DOB), which requires absolute attention to detail and protection of the data. Modifications to any part of the payroll process have to be thoroughly tested and vetted before releasing. Mistakes made could have severe time and financial consequences.

Works closely with the IT System Manager to provide the technical guidance needed for our projects and oversees the collaborative efforts with the County’s IT contractor on tasks related to our ERP and associated solutions.

• Three (3) years of experience working with an ERP solution, preferably in a government setting.
  1. Experience with migrating an ERP system is highly desired
  2. Experience in supporting and programming for a payroll department to meet policies is highly desired
  3. Experience with CentralSquare Technologies’ public administration software, OneSolution / Finance Enterprise, is desired
  4. Experience with UKG (formerly Kronos) timekeeping/scheduling solutions is desired
  5. Experience with AP Technology SecureCheck is helpful
• Should have a proficient working knowledge of:
  1. IIS web servers
  2. MS Windows operating system
  3. Microsoft Excel (e.g., writing/supporting formulas and macros)
• Should be experienced in providing advanced end user support (e.g., system maintenance and report development) using the following technologies:
  1. Analytics : IBM Cognos (preferred) and/or Microsoft Power BI
  2. Databases: SQL 2012, 2014, 2016, 2022
  3. Development Software/Framework : VB.NET, Unix shell scripting, MVC framework, SSIS, SSRS
  4. Remote Assistance Tools: AnyConnect and GoToAssist
• Should possess the ability to:
  1. Multi-task and change priorities quickly and to think outside the box when troubleshooting.
  2. Exercise tact, discretion and sound judgement in addressing sensitive or confidential matters.
  3. Communicate confidently with upper management and to effectively discuss complex technical issues/solutions with audiences of varying degrees of technical aptitude and understanding.
  4. Clearly document issues and resolutions for future reference.