Treasury Systems Analyst
Job description
Department: Treasury Anticipated Work Schedule: M-F Reports To: Administrator, Tax Collection Division Full Time or Part Time: FT Regular or Temporary: Reg Bargaining Unit: N/A Classified or Unclassified: Classified FLSA : Exempt Summary The purpose of this classification is to plan, direct, and manage the business use of applications for the Treasurer’s Office and provide technical support for related software.
This is a technical, journey-level classification that ensures that business applications meet the needs of the Treasurer’s Office and makes the necessary changes to applications to meet those needs. This position also acts as the primary liaison between the Treasurer’s Office, the Information Technology (IT) Department, and software vendors to ensure technologies meet business needs.
Positions at this level work under general supervision of a manager-level position and receive instruction or assistance as unusual situations arise and are expected to exercise judgment and initiative. Essential Job Functions The following duties are normal for this classification. These are not to be construed as exclusive or all-inclusive.
Other duties may be required and assigned. Manages data within Treasury applications; monitors and audits data within applications for accuracy; compares data in multiple systems to ensure data integrity; researches errors and discrepancies; resolves errors and determines how to prevent future data accuracy issues; performs mass import and export of data for use in other systems; identifies areas for business process improvements.
Calculates and creates tax bills; configures and runs system operations to calculate individual tax bills based on parcel values, tax rates, and special assessments; manually calculates bills for a representative sample of parcels to validate system accuracy. Designs, develops, and runs reports within applications for use by management and department personnel; creates standard reports within applications utilizing the report builder feature; develops technical specifications for complex reports to be written by IT; runs regular reports; provides/adjusts query parameters; validates data output (e.
g. escrow report, settlement report, surplus report). Maintains global system settings (e.g., tax year and half, collection periods, default allocation); configures mass-processing jobs within the system (e.g., applies interest, applies penalties). Provides technical support for applications; monitors and reviews system performance and user interfaces; troubleshoots system issues; identifies areas for system improvement; creates testing scenarios to ensure systems functionally meet the department’s needs; leads and coordinates testing efforts for new system software or features and ensures issues are identified, tracked, and resolved; responds to questions and issues from department personnel; develops training materials and manuals for end users and future system administrators; conducts training sessions.
Communicates with the IT Department and software vendors regarding project requirements and business needs; works with functional managers to discuss business requirements; translates business requirements and local and State taxation laws and policies into technical specifications; develops functional and effective data transmittal procedures with other areas of the Fiscal Office; recommends system enhancements and changes to vendors.
Minimum Requirements Bachelor's degree in accounting, finance, or related field with five (5) years of computer information systems or software development experience; or any equivalent combination of training and experience as defined below: Highest degree of education attained Experience required High school diploma/GED Not Qualified Unrelated associate degree Not Qualified Related associate degree 7 years Unrelated bachelor’s degree Not Qualified Related bachelor’s degree 5 years Unrelated master’s/doctoral degree Not Qualified Related master’s/doctoral degree 2 years Related degree fields: information technology, computer science, management information systems, mathematics, statistics, project management, business administration, public administration, business technology.
Related work experience: computer information systems, application development, tax appraisal, title agency, real tax appraisal. Additional Requirements Ability to operate a variety of automated office machines and equipment including personal computer, phone, and multifunction printers. Ability to operate a variety of software and databases including treasury database software (MVP, Infor), email software (Microsoft Outlook), productivity software (Microsoft Excel, Access, Outlook, Word, PowerPoint, Teams, etc.)
, business intelligence software (Power BI, Tableau). Ability to add, subtract, multiply, divide, calculate decimals and percentages, and perform routine statistics. Requires the ability to perform mid-level data analysis including the ability to audit, deduce, assess, conclude, and appraise. Requires discretion in determining and referencing established criteria to define impact and develop alternatives.
Ability to comprehend a variety of informational documents including system reports (e.g., adder/remitter Report, Auditor Refund Report, Exempt Abstract Report, Tax Abstract Report, TIF Report, Tax Lien Reports, Special Assessment Reports) system performance reports, data sets, software specifications, source materials, internal data requests, public records requests, and other reports and records.
Ability to comprehend a variety of reference books and manuals including the Employee Handbook, pertinent sections of the Ohio Revised Code and Ohio Administrative Code, Cuyahoga County Charter and County Code as pertains to the Treasurer, computer software manuals, systems documentation and manuals, software product manuals, standard operating procedures, security standards, and the Ohio Revised Code.
Ability to prepare mass billing files, contract maintenance reports, escrow reports, tax distribution reports, delinquent tax reports, treasurer refund reports, manufactured home reports, memos, correspondence, training documents, email notifications, and other job-related documents using prescribed format and conforming to all rules of punctuation, grammar, diction, and style.
Ability to convince and influence others, to record and deliver information, to explain procedures, and to follow instructions. Ability to use and interpret accounting, computer software, and local and state tax code language and terminology. Ability to communicate effectively with the Treasurer, Administrators, vendors, other departments, and other County employees.
Application Process This is a competitive, classified position. The Personnel Review Commission (PRC) will check your application to make sure you meet the minimum qualifications. If you do, the PRC will invite you to take a civil service examination. The exam is specific to this position. Everyone who passes the exam goes on an eligibility list.
To fill this opening, the PRC sends the hiring department and Human Resources (HR) a certified eligibility list with the top 25% candidates (or at least the ten highest scoring candidates, whichever is greater). HR helps the hiring department decide who from the certified list to follow up with for interviews and then a job offer.
Most of our communication with candidates is through email. Regularly check the email address you gave us in your job profile. Watch your Spam folder, just in case. If we offer you a job, you must pass a drug screen and background check before the offer becomes final. Prior criminal convictions do not automatically disqualify you from employment; the County looks at criminal convictions on a case-by-case basis using the guidelines in Chapter 306 of the County Code .
Conviction of some misdemeanors and felonies may preclude applicants from serving in some positions. Aside from circumstances set forth is Section 306.02(A)(1) of the Cuyahoga County Code, all job openings will require a background check at the time of conditional offers of employment, and conditional offers of employment become permanent only upon successful completion of the background check process.
EQUAL OPPORTUNITY EMPLOYER Cuyahoga County is committed to fostering a diverse and inclusive workforce, which includes building an environment that respects the individual, promotes innovation and offers opportunities for all employees to develop to their full potential. A diverse workforce helps the County realize its full potential.
The County benefits from the creativity and innovation that results when people with different experiences, perspectives, and cultural backgrounds work together. The County is committed to providing equal employment opportunities for all individuals regardless of race, color, ancestry, national origin, language, religion, citizenship status, sex, age, marital status, sexual preference or orientation, gender identity/expression, military/veteran status, disability, genetic information, membership in a collective bargaining unit, status with regard to public assistance, or political affiliation.
If you are a person with a disability and unable to use or access this site as a result of your disability, you may request a reasonable accommodation by calling (216) 443-7248 or via email to ADA@Cuyahoga. County.us . Cuyahoga County is committed to fostering a diverse and inclusive workforce, which includes building an environment that respects the individual, promotes innovation and offers opportunities for all employees to develop to their full potential.
A diverse workforce helps the County realize its full potential. The County benefits from the creativity and innovation that results when people with different experiences, perspectives, and cultural backgrounds work together.
Description copied from Cuyahoga County's careers page. Read the full posting before you apply.
More jobs at Cuyahoga County
Administrator, Social Program 4
Cuyahoga County· US:OH:ClevelandSenior Grants Coordinator
Cuyahoga County· US:OH:ClevelandMorgue Technician
Cuyahoga County· US:OH:ClevelandDirector, Law
Cuyahoga County· US:OH:ClevelandCorrections Officer
Cuyahoga County· US:OH:Cleveland· $55k