Enterprise Systems Analyst

Company Overview

Clermont County Auditor is dedicated to ensuring transparency and accountability in government. We leverage technology and innovative solutions to enhance our processes and provide accurate information to the public.

Summary

The Systems' Analyst primary functions will be focused on the Auditor's Enterprise systems but will also be a part of our cross-division Technology Development team which includes the maintenance, troubleshooting and security of the Technology Systems of the Clermont County Auditor’s office. These solutions involve the Clermont County Auditor’s office, Clermont County Departments/Agencies and Clermont County citizens and support many of the basic functions of County government

Work Characteristics and Job Description:

Undergraduate degree is preferred in a technical relevant field of work or commensurate industry experience is required.

Must have a general understanding of accounting and payroll processes and Enterprise Resource Planning (ERP) Systems to help the County utilize the ERP system to be most effective and efficient.

Expert knowledge of Microsoft SQL Server Reporting Services (SSRS)

Advanced SQL skills including data extraction, aggregation, and query optimization

Strong analytical and problem-solving abilities; excellent communication and collaboration skills

Ability to translate business requirements into effective report designs

Attention to detail and commitment to data accuracy

The individual must have good customer service skills to be able to work with individuals throughout the County.

Knowledge of Monitoring and implementing security measures

Review diagnostics and assess the functionality and efficiency of systems

Manages application and OS updates and assures application/OS/hardware compatibility.

Establishes and enforces procedures for data access security and access rights.

Ability to Create and maintain datasets and views for consumption in open data

Possesses General knowledge of desktop support and applications

Familiarity with cloud computing platforms, particularly Amazon Web Services.

Handle multiple priorities, timely response to requests, excellent follow through, and ability to track time and tasks

Job Duties include:

Administrator of ERP system including running utilities, reviewing and approving new users and roles, and to periodically check settings

Assists users with problems and password resets

Works with ERP vendor, hardware vendor and OS software vendor as needed

Works with the Deputy Auditors on developing systems and processes that encourage cross-functional cooperation and support initiative

Works with departments on utilizing the ERP system to be more effective and efficient.

Install and update software and hardware as needed

Creates reports as needed in Sequel Reporting Services

Manages the Records Retention Schedule within Content Management Systems

Creates datasets and views for consumption in open data

Monitor security certificates, security applications and compliance of requirements

Offer technical desktop support to staff and troubleshoot computer problems

Resolves hardware and software problems for users

Provides user support for all Auditor application programs.

The individual assists in all other duties as may be required or assigned. Requires knowledge of general office practices and procedures. Employee must exhibit evidence of the major worker characteristics noted above.

Job Type: Full-time

Pay: $50,000.00 - $60,000.00 per year

Benefits:

• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Retirement plan
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• Do you have any prior Government Experience?

Education:

• Associate (Required)

Experience:

• SSRS: 3 years (Required)

Ability to Commute:

• Batavia, OH 45103 (Required)

Ability to Relocate:

• Batavia, OH 45103: Relocate before starting work (Required)

Work Location: In person

Salary : $50,000 - $60,000