Loading...
HomeMy WebLinkAboutResolutions - 2025.05.22 - 42117 AGENDA ITEM: Implementing the Salary Administration Plan 2nd Quarterly Report for FY 2025 DEPARTMENT: Human Resources MEETING: Board of Commissioners DATE: Thursday, May 22, 2025 6:00 PM - Click to View Agenda ITEM SUMMARY SHEET COMMITTEE REPORT TO BOARD Resolution #2025-5267 Motion to authorize the implementation of the Salary Administration Plan 2nd Quarterly Report for FY 2025, effective May 31, 2025; further, to change the classifications according to the attached Schedule B; further to change the salary grade of classifications according to the attached Schedule C; further, to reclassify positions according to the attached Schedule D; further, to amend the FY 2025-2027 budget as detailed in the attached Schedule A - Budget Amendment. ITEM CATEGORY SPONSORED BY HR Quarterly Report Brendan Johnson INTRODUCTION AND BACKGROUND Merit Rule 2 provides a process for departments and employees to request a review of the salary grade placement of classifications. The 2nd Quarterly Report for FY 2025 identifies the job studies conducted and the salary grade changes recommended by the Human Resources Department from January 2025 through March 2025. This Quarterly Report seeks approval for the following changes to be effective May 31, 2025: • Change the salary grade of two classifications within the Public Services department. • Create one new classification with an increase in salary grade in the Parks & Recreation Department. • Create ten new classifications with no change in point factors or salary grade within the Information Technology and Human Resources Departments. POLICY ANALYSIS The FY 2025 2nd Quarterly Report requests the adoption of the 2nd Quarterly Report with the following changes: Salary Grade Change of 3 Classifications: • Manager, Animal Control - increase salary grade from 129 to 130 (5% increase) to better reflect the responsibilities of the position (see Schedule C for more detail) • Manager, Medical Examiner - increase salary grade from 129 to 130 (5% increase) to better reflect the exposure to unavoidable hazards (see Schedule C for more detail) • Retitle Technical Office Specialist to Parks Administrative Specialist and increase salary grade from 112 to 114 to accurately reflect the duties being performed (See Schedule C for more detail) Retitle 10 Classifications with no Changes in Salary Grade: Information Technology 1. IT Business Analyst to CLEMIS Business Analyst 2. IT User Support Specialist II to CLEMIS User Support Specialist II 3. IT Supervisor I to CLEMIS Supervisor I 4. Project Support Specialist to CLEMIS Support Specialist 5. Systems Analyst Senior to CLEMIS Systems Analyst Senior 6. Administrator CLEMIS to CLEMIS Administrator 7. 9-1-1 Operator to CLEMIS 9-1-1 Operator 8. IT Application Architect to CLEMIS IT Application Architect Human Resources 1. HR Business Partner to HR Business Partner (Non-union) 2. HR Business Partner Senior to HR Business Partner Senior (Non-union) Financial Impact The General Fund/General Purpose impact of this request would be $5,152 (prorated) for FY 2025; $24,661 for FY 2026 and $29,375 for FY 2027. With this request, the remaining balance in the Non-Departmental Classification and Rate Change would be $165,361. For the Proprietary Funded positions, the offsets are within their own budgets. FISCAL IMPACT: Budget Amendment Attached Committee members can contact Barbara Winter, Policy and Fiscal Analysis Supervisor at 248.821.3065 or winterb@oakgov.com or the department contact persons listed for additional information. CONTACT Heather Mason, Manager Human Resources Hailey Matthews, Human Resources Analyst - Senior ITEM REVIEW TRACKING Aaron Snover, Board of Commissioners Created/Initiated - 5/23/2025 AGENDA DEADLINE: 05/08/2025 4:30 PM ATTACHMENTS 1. 2nd - 2025 SCHEDULE A - Budget Amendment 2. 2nd 2025 SCHEDULE B - Classification Changes 3. 2nd 2025 SCHEDULE C - Factor Changes 4. 2nd 2025 SCHEDULE D - Biweekly Increases 5. 2nd 2025 SCHEDULE E - Draft Job Descriptions COMMITTEE TRACKING 2025-05-13 Legislative Affairs & Government Operations - Recommend to Board 2025-05-22 Full Board - Adopt Motioned by: Commissioner Angela Powell Seconded by: Commissioner Christine Long Yes: Charles Cavell, Ann Erickson Gault, Marcia Gershenson, Robert Hoffman, Brendan Johnson, Karen Joliat, Christine Long, Penny Luebs, Gwen Markham, Kristen Nelson, Angela Powell, Yolanda Smith Charles, Michael Spisz, Linnie Taylor, Philip Weipert, David Woodward (16) No: None (0) Abstain: None (0) Absent: Michael Gingell, Robert Smiley (2) Passed Oakland County, Michigan HUMAN RESOURCES - SALARY ADMINISTRATION PLAN 2nd QUARTERLY REPORT FOR FY 2025 - SALARY GRADE & CLASSIFICATION ADJUSTMENTS Schedule "A" DETAIL R/E Fund Name Division Name Fund # (FND)Cost Center (CCN) # Account # (RC/SC) Program # (PRG) Grant ID (GRN) # Project ID # (PROJ) Region (REG) Budget Fund Affiliate (BFA) Ledger Account Summary Account Title FY 2025 Amendment FY 2026 Amendment FY 2027 Amendment E General Fund Non Departmental Transfers FND10100 CCN9090101 SC730359 PRG196030 730000 Contigency $(5,152)$(24,661)$(29,375.00) E General Fund Animal Control FND10100 CCN1070801 SC702010 PRG114000 702000 Salaries Regular 2,271.00 7,193.00 7,522.00 E General Fund Animal Control FND10100 CCN1070801 SC722790 PRG114000 722000 Social Security 174.00 550.00 575.00 E General Fund Animal Control FND10100 CCN1070801 SC722770 PRG114000 722000 Retirement 998.00 3,825.00 4,224.00 E General Fund Animal Control FND10100 CCN1070801 SC722810 PRG114000 722000 Disability 91.00 259.00 267.00 E General Fund Animal Control FND10100 CCN1070801 SC722820 PRG114000 722000 Unemployment Insurance 1.00 19.00 19.00 E General Fund Animal Control FND10100 CCN1070801 SC722760 PRG114000 722000 Group Life 15.00 47.00 48.00 E General Fund Animal Control FND10100 CCN1070801 SC722750 PRG114000 722000 Workers Compensation 278.00 871.00 892.00 E General Fund Medical Examiner FND10100 CCN1070601 SC702010 PRG132030 702000 Salaries Regular 4,766.00 20,413.00 21,045.00 E General Fund Medical Examiner FND10100 CCN1070601 SC722790 PRG132030 722000 Social Security 365.00 1,562.00 1,610.00 E General Fund Medical Examiner FND10100 CCN1070601 SC722770 PRG132030 722000 Retirement 890.00 4,743.00 5,184.00 E General Fund Medical Examiner FND10100 CCN1070601 SC722810 PRG132030 722000 Disability 129.00 472.00 486.00 E General Fund Medical Examiner FND10100 CCN1070601 SC722820 PRG132030 722000 Unemployment Insurance 3.00 25.00 26.00 E General Fund Medical Examiner FND10100 CCN1070601 SC722760 PRG132030 722000 Group Life 20.00 78.00 81.00 E General Fund Medical Examiner FND10100 CCN1070601 SC722750 PRG132030 722000 Workers Compensation 269.00 879.00 900.00 E General Fund Fiscal Services FND10100 CCN1020601 SC702010 PRG182040 702000 Salaries Regular (5,533.00)(17,277.00)(14,839.00) E General Fund Fiscal Services FND10100 CCN1020601 SC722790 PRG182040 722000 Social Security (423.00)(1,322.00)(1,135.00) E General Fund Fiscal Services FND10100 CCN1020601 SC722770 PRG182040 722000 Retirement (2,314.00)(6,668.00)(5,880.00) E General Fund Fiscal Services FND10100 CCN1020601 SC722810 PRG182040 722000 Disability (59.00)(200.00)(155.00) E General Fund Fiscal Services FND10100 CCN1020601 SC722820 PRG182040 722000 Unemployment Insurance (3.00)-1.00 E General Fund Fiscal Services FND10100 CCN1020601 SC722760 PRG182040 722000 Group Life (8.00)(23.00)(16.00) E General Fund Fiscal Services FND10100 CCN1020601 SC722750 PRG182040 722000 Workers Compensation 143.00 470.00 505.00 E General Fund Fiscal Services FND10100 CCN1020601 SC722780 PRG182040 722000 Hospitalization (Personnel)2,951.00 8,374.00 7,666.00 E General Fund Fiscal Services FND10100 CCN1020601 SC722800 PRG182040 722000 Dental 115.00 332.00 311.00 E General Fund Fiscal Services FND10100 CCN1020601 SC722850 PRG182040 722000 Optical 13.00 39.00 38.00 Total Expenditures $-$-$- E Parks and Recreation PR Planned Use of Balance FND50800 CCN5060666 SC796500 PRG160666 796500 Budgeted Equity Adjustments $(1,772)$(5,121)$(5,121.00) E Parks and Recreation PR Development & Engineering FND50800 CCN5060190 SC702010 PRG160700 702000 Salaries Regular 1,312.00 3,793.00 3,793.00 E Parks and Recreation PR Development & Engineering FND50800 CCN5060190 SC722900 PRG160700 722000 Fringe Benefit Adjustments 460.00 1,328.00 1,328.00 Total Expenditures $-$-$- OAKLAND COUNTY HUMAN RESOURCES DEPARTMENT SALARY ADMINISTRATION SECOND QUARTERLY REPORT FOR FY2025 SCHEDULE B – CLASSIFICATION CHANGES DEPARTMENT CLASSIFICATION PROPOSED GRADE REASON Public Services/Animal Control Manager Animal Control UNI/130 Increasing the salary grade from 129 to 130. Public Services/Medical Examiner Manager Medical Examiner UNI/130 Increasing the salary grade from 129 to 130. Parks & Recreation Technical Office Specialist To new title Parks Administrative Specialist UNI/114 Create a new classification to accurately reflect the duties being performed. Increasing the salary grade from 112 to 114. Information Technology IT Business Analyst To new title CLEMIS Business Analyst UNI/124 Create a new classification, with no change in factor ratings or salary grade. Information Technology IT User Support Specialist II To new title CLEMIS User Support Specialist II UNI/121 Create a new classification, with no change in factor ratings or salary grade. Information Technology IT Supervisor I To new title CLEMIS Supervisor I UNI/130 Create a new classification, with no change in factor ratings or salary grade. Information Technology Project Support Specialist To new title CLEMIS Support Specialist UNI/112 Create a new classification, with no change in factor ratings or salary grade. Information Technology Systems Analyst Senior To new title CLEMIS Systems Analyst Senior UNI/129 Create a new classification, with no change in factor ratings or salary grade. Information Technology Administrator CLEMIS To new title CLEMIS Administrator UNI/127 Create a new classification, with no change in factor ratings or salary grade. Sched. B Page 2 Information Technology 9-1-1 Operator To new title CLEMIS 9-1-1 Operator UNI/127 Create a new classification, with no change in factor ratings or salary grade. Information Technology IT Application Architect To new title CLEMIS IT Application Architect UNI/132 Create a new classification, with no change in factor ratings or salary grade. Human Resources HR Business Partner – 070 To new title HR Business Partner – UNI UNI/126 Create a new UNI Non-Union classification, with no change in factor ratings or salary grade. Human Resources HR Business Partner Senior – 070 To new title HR Business Partner Senior – UNI UNI/127 Create a new UNI Non-Union classification, with no change in factor ratings or salary grade. OAKLAND COUNTY SALARY ADMINISTRATION SECOND QUARTERLY REPORT FOR FY2025 SCHEDULE C – FACTOR & SALARY GRADE CHANGES Department/Division Classification From Grade To Grade Explanation of Factor Changes Public Services/Animal Control Manager Animal Control 129 130 Increase Factor 3, People Responsibility, from level 6 to 8 to accurately reflect that this classification negotiates, exchanges ideas, information, and opinions with others to formulate policy and programs or arrive jointly at decisions, conclusions, or solutions. Increase Factor 4, Assets Responsibility, from level 3 to 5 to accurately reflect that this classification is responsible for achieving major economies and/or preventing major losses through the management of a moderate sized department, authorizing expenditures of large amounts of money. This classification serves as Deputy County Treasurer responsible for the distribution and sale of dog licenses throughout the County by local, municipal and township treasurers and the collection of revenue by such sales. Decrease Factor 5, Experience Requirement, from level 9 to 7 to accurately reflect that this classification requires 6 years of experience. Decrease Factor 6, Educational Requirement, from level 6 to 5 to accurately reflect that this classification requires a bachelors degree in business administration, public administration or a related field. Decrease Factor 7, Mathematical Requirements, from level 4 to 2 to accurately reflect that this classification uses addition and subtraction, multiplication, division, and/or calculates ratios, rates, and percentages. Increase Factor 9, Judgement Responsibility, from level 3 to 5 to accurately reflect that this classification is responsible for the actions of others, requiring development of procedures and constant decisions affecting subordinate workers, crime victims, patients, customers, clients, or others in the general public; works in a very fluid environment with guidelines but significant variation. Increase Factor 11, Impact of Errors, from level 4 to 5 to accurately reflect that the impact of errors is serious – affects most units in the department and may affect other County departments/functions or citizens. Decrease Factor 12, Physical Demands, from level 4 to 3 to accurately reflect that this classification Performs light work that involves walking or standing most of the time and involves exerting up to 20 pounds. Increase Factor 13, Equipment Usage, from level 4 to 5 to accurately reflect that this classification Coordinates the activities of those operating or repairing complex machines, tools, or equipment that requires extended training and may involve installation and testing; extensive latitude for judgment regarding attainment of a standard or in selecting appropriate items. Increase Factor 14, Unavoidable Hazards, from level 1 to 8 to accurately reflect that this classification is exposed to radiation such as near x-ray equipment, disease/pathogens such as in an Animal Control facility, toxic/caustic chemicals, or in areas where explosions are possible. Public Services/Medical Examiner Manager Medical Examiner 129 130 Increase Factor 14, Unavoidable Hazards, from level 2 to 8 to accurately reflect that this classification is exposed to radiation such as near x-ray equipment, disease/pathogens such as in a medical facility, toxic/caustic chemicals, or in areas where explosions are possible. Sched. C page 2 Parks & Recreation Technical Office Specialist To new title Parks Administrative Specialist 112 114 Increase Factor 2, Data Responsibility, from level 4 to 5 to accurately reflect that this classification gathers, organizes, analyzes, examines, or evaluates data or information and may prescribe action based on these data or information. Increase Factor 4, Assets Responsibility, from level 2 to 3 to accurately reflect that this classification is responsible for achieving moderate economies and/or preventing moderate losses through the handling supplies of high value or moderate amounts of money. Increase Factor 5, Experience Requirement, from level 5 to 6 to accurately reflect that this classification requires 4 years of experience. Increase Factor 8, Communications Requirement, from level 4 to 5 to accurately reflect that this classification reads journals, manuals, and professional publications; speaks informally to groups of co-workers, staff in other organizational agencies, general public, people in other organizations, and presents training; composes original reports, training, and other written materials Biweekly Position #Fund Classification Plan Grade Step Biweek Classification Plan Grade Step Biweek Difference P00002282 GF/GP Manager Animal Control UNI 129 84 5,344.03 Manager Animal Control UNI 130 84 5,611.25 267.22 5% P00002552 GF/GP Manager Medical Examiner UNI 129 72 5,150.43 Manager Medical Examiner UNI 130 72 5,407.94 257.51 5% P00005210 PR Parks Technical Office Specialist UNI 112 84 2,331.58 Parks Administrative Specialist UNI 114 72 2,477.45 145.87 6% P00009581 PR IT Business Analyst UNI 124 84 4,187.21 CLEMIS Business Analyst UNI 124 84 4,187.21 0.00 0% P00012415 PR IT Business Analyst UNI 124 84 4,187.21 CLEMIS Business Analyst UNI 124 84 4,187.21 0.00 0% P00009232 PR IT Business Analyst UNI 124 72 4,035.49 CLEMIS Business Analyst UNI 124 72 4,035.49 0.00 0% P00009234 PR IT Business Analyst UNI 124 84 4,187.21 CLEMIS Business Analyst UNI 124 84 4,187.21 0.00 0% P00011883 PR Project Support Specialist UNI 112 84 2,331.58 CLEMIS Support Specialist UNI 112 84 2,331.58 0.00 0% P00010484 PR Systems Analyst Senior UNI 129 84 5,344.03 CLEMIS Systems Analyst Senior UNI 129 84 5,344.03 0.00 0% P00001957 PR Systems Analyst Senior UNI 129 72 5,150.43 CLEMIS Systems Analyst Senior UNI 129 72 5,150.43 0.00 0% P00004730 PR IT Supervisor I UNI 130 84 5,611.25 CLEMIS Supervisor I UNI 130 84 5,611.25 0.00 0% P00012416 PR IT User Support Specialist II UNI 121 84 3,617.09 CLEMIS User Support Specialist II UNI 121 84 3,617.09 0.00 0% P00009582 PR IT User Support Specialist II UNI 121 12 2,830.75 CLEMIS User Support Specialist II UNI 121 12 2,830.75 0.00 0% P00016213 PR 9-1-1 Operator UNI 127 60 4,495.97 CLEMIS 9-1-1 operator UNI 127 60 4,495.97 0.00 0% P00010253 PR Administrator- CLEMIS HRL 127 72 58.39 CLEMIS Administrator HRL 127 72 58.39 0.00 0% P00011397 PR IT Application Architect UNI 132 84 6,186.39 CLEMIS IT Application Architect UNI 132 84 6,186.39 0.00 0% P00016183 GF/GP HR Business Partner 070 126 24 3,802.21 HR Business Partner UNI 126 24 3,802.21 0.00 0% Illustrative Cost - Annual GF 13,643 Illustrative Cost - Annual PR 3,793 % Change SALARY ADMINISTRATION SECOND QUARTERLY REPORT FOR FY2025 OAKLAND COUNTY CURRENT PROPOSED SCHEDULE D - POSITION CHANGES & ILLUSTRATIVE COST OAKLAND COUNTY SALARY ADMINISTRATION SECOND QUARTERLY REPORT FOR FY2025 SCHEDULE E – DRAFT JOB DESCRIPTIONS JOB DESCRIPTIONS This section contains the draft job descriptions for any new classifications that will be created as a result of this Quarterly Report. These drafts are not official, and the content may be revised after the adoption of the Salary Administration Plan Quarterly Report. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS 9-1-1 COUNTY OPERATOR Department: Information Technology /CLEMIS Reports To: Chief - CLEMIS FLSA Status: Exempt Salary Plan: UNI/127 GENERAL SUMMARY Responsible for the support, planning, development, and facilitation of the Oakland County 9-1-1 system. Sets policy and procedures for all Public Safety Answering Points (PSAP) across Oakland County to ensure consistent support of the 9-1-1 System. Manages all wireless 9-1-1 routing for all PSAPs and carriers, including ESQK assignment, ESN assignments, default routing, and coordination of testing between carriers and Oakland PSAPs. Ensures the efficient 9-1-1 System functioning, mitigating service interruption, including smooth transition of backup system in the event of a system failure. Maintains knowledge of current and emerging 9-1-1 technology, legislative mandates, and tariffs. Leads and directs system-wide planning including routing of wireless calls to PSAPs, providing PSAP boundaries to service providers, coordinating third-party interfaces to the 9-1-1 system, and migration to evolving 9-1-1 standards. Serve as a liaison between the County and service suppliers, and state and federal regulatory agencies, including drafting and presenting legislative language for adoption. Leads regular meetings of the Public Safety Answering Place (PSAP) Coordinators Subcommittee and will assist the Chairperson of the PSAP Coordinator’s Subcommittee with quarterly reports for the CLEMIS Advisory Committee. Responsible for researching and recommending budget items and monitor related expenses for compliance with statutory allowable expenditures of 9-1-1 fees. Annually, this position requires approximately 30% travel within the State of Michigan and 5% out of state. Utilizes current Countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Plans, directs, and coordinates professional, para-professional, user support, clerical and technical employees assigned to specific CLEMIS projects. ESSENTIAL JOB FUNCTIONS Serves as Senior Coordinator for Oakland County 9-1-1 system. In collaboration with PSAP Coordinators and CLEMIS Advisory Board, sets policy and procedures for all PSAPs. Provides leadership for the planning, implementation, and training of PSAP emergency technological and communication systems, including 9-1-1. Maintains a current knowledge of, safety and participates in the development of, public safety legislation, standards, and technology. CLASS TITLE: CLMIS 9-1-1 COUNTY OPERATOR 2 Completes the annual 9-1-1 Report to the Legislature for all Oakland County PSAPs which includes collection of data and compilation into a single report, along with supporting documentation from Fiscal Services regarding the appropriate use of surcharge expenditures and establishing the rate for the Oakland County operational 9-1-1 fee. Coordinates completion of State 9-1-1 Committee Compliance Review for Oakland County. Assist with the annual update of surcharge rate and Board of Commissioners process. Notify service providers, State 9-1-1 Committee, and Michigan Public Services Commission of the new rate utilizing processes mandated by statute. Facilitates quarterly meetings of the PSAP Coordinators for all PSAPs within Oakland County, including identifying and coordinating guest speakers with educational material. Draft the agenda and any PSAP recommended policies (9-1-1 wireless testing, 911 transfers, etc.). Manages all wireless 9-1-1 routing for all PSAPs and all carriers, including ESQK assignment, ESN assignments, default routing, and coordination of testing between carriers and Oakland PSAPs. Manages all VoIP routing for all PSAPs and all providers, including customer-reported address validation against MSAG and VDB, ESN assignment, default routing, and coordination of testing between VSPs, VNPs, and PSAPs. Assists with PSAP consolidation, including drafting RFPs for PSAP services, assisting consultants with evaluations of potential PSAP consolidation, attending pre-consolidation meetings including city, village, and council meetings. When consolidation does occur, assist PSAP(s) with transition, including the moving or procurement of equipment, and assuring the proper documentation is received by the County Clerk and true copies forwarded to the providers within statutory timeframe. Notify the State 9-1-1 Office and National PSAP registry of any changes in PSAP Coordinators, or of any PSAPs that cease to function as a PSAP. In cooperation with Corporation Counsel, prepares rewrites and amendments of the Oakland County Final 911 Service Plan for compliance with current legislation and terminology. Leads the revised plan through all the statutory steps (public notices, public hearings, distribution of the tentative plan to all cities, villages, and townships, etc.) with the Board of Commissioners and the County Clerk. Coordinates with the ESINET provider, subcontractors, and current customer premise equipment (CPE) provider for updates and enhancements. As needed, coordinates resources for ESINET and replacements of 9-1-1 for Oakland County PSAPs, including researching vendors and equipment, drafting RFPs, facilitating a PSAP selection committee, and assisting with ordering, installation, training, and coordination of cutover for PSAPs, and review of invoices. Due to the nature of supporting critical emergency systems work may be required, either planned or unplanned, during non-business hours, weekends, and holidays. This position is required to be on-call 24x7x365. Utilizes current Countywide and/or department specific software to complete assignments. CLASS TITLE: CLMIS 9-1-1 COUNTY OPERATOR 3 ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate accurately to convey information using tact and diplomacy. Ability to operate a motor vehicle and/or be a passenger. WORKING CONDITIONS Work is carried out in a typical office environment. Will be required to travel to other locations during the course of work. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGE, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a bachelor’s degree from an accredited college or university with a major in Business Administration, Public Administration, Criminal Justice, Computer Science, or a closely related field. 2. Have at least five (5) years of full-time work experience in the planning, management, and implementation of public safety emergency telecommunications systems. NOTE: A master’s degree in business administration, Public Administration, Criminal Justice, Computer Science, or a closely related field may substitute for one year of experience as described above. 3. Possess a valid motor vehicle operator's or chauffeur's license. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable knowledge of and experience in working with equipment utilized in delivering public safety communication and management information services and emergency services. 2. Considerable experience in working with public safety agencies, political subdivisions, and emergency response situations. 3. Considerable ability to deal tactfully with public officials, and considerable experience in preparing effective presentations and speaking before committees and public groups. CLASS TITLE: CLMIS 9-1-1 COUNTY OPERATOR 4 4. Considerable ability to cope with difficult and/or emergency situations requiring immediate decisions in accordance with departmental policies and objectives. 5. Considerable ability to coordinate with a staff of professional, technical, and clerical employees. 6. Considerable knowledge of pertinent rules, regulations, policies, procedures, and legislation, including those of the Federal Communication, Commission, Federal Emergency Management Agency, Department of Justice, Michigan Public Services Commission, LEIN, NCIC, State and County Emergency Management Divisions, State 9-1-1 Committee, and other related regulatory bodies. 7. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail, and Internet software. 8. Knowledge of and experience in working with public safety communications, dispatch, and information management systems. 9. Ability to compile statistics, decipher pertinent information, and present oral and written financial, operational, and other types of departmental reports to officials and other interested groups or individuals. C. SPECIAL REQUIREMENTS 1. Must maintain a valid motor vehicle operator’s or chauffeur’s license. 2. Must pass a background check performed by the County or other appropriate agencies as required. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS ADMINISTRATOR Department: Information Technology / CLEMIS Reports To: Manager – CLEMIS FLSA Status: Exempt Salary Plan: UNI/127 GENERAL SUMMARY Assists in a variety of CLEMIS (Courts and Law Enforcement Management Information System) projects. Assists in the development and revision of strategic plans to best address changing County needs by utilizing new software technologies and legacy systems. Works closely with the law enforcement community as a project manager in the design, installation, and implementation of electronic data and communication systems related to emergency response, Computer-Aided Dispatch (CAD), the Law Enforcement Information Network (LEIN), 9-1-1, voice radio and mobile data dispatch systems. Organizes and prepares highly effective presentations on a variety of project related issues. . Discusses and evaluates vendor and in-house approaches. Effectively recommends on budget preparation and monitors expenses of specific projects. Maintains a current knowledge of public safety technology and participates in County CLEMIS and State leadership committees. Utilizes current countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Plans, directs, staffs, and manages professional, para-professional, user support, clerical and technical employees assigned to specific CLEMIS projects. Instructs, assigns, schedules, checks and makes effective recommendations on performance appraisal. Participates in decisions to select, hire, discipline, discharge, and ward pay increases and/or promotions. ESSENTIAL JOB FUNCTIONS Provides project management for the planning and implementation of PSAP (Public Safety Answering Point) emergency technological and communication system, including 9-1-1, voice radio communications, mobile data communications, computer-aided dispatch, and LEIN and NCIC. Maintains a current knowledge of public safety radio, computer, and telephonic technology. Develops and manages requests for proposals and emergency communication system equipment and services, and develops and administers related contracts. Coordinates the development of public safety voice and mobile data infrastructure enhancements, including technical specifications and licensure. Plans and coordinates effective integration of voice and mobile data DRAFT 4-25-25 communications with public safety user agencies. Coordinates the training of staff in the effective operation and deployment of new technologies at various County cities, villages and townships. Functions as Oakland County E9-1-1 Coordinator, providing liaison between the Oakland County PSAPs, the telecommunication service suppliers, and the pertinent state and federal regulatory agencies and committees. Provides for the enhancement and maintenance of the County’s 9-1-1 system. Maintains a current knowledge of applicable state and federal legislation and pending legislation. Maintains current knowledge of LEIN and NCIC rules, regulations, standards, and operations. Coordinates with agencies and political subdivisions of Oakland County concerning CLEMIS programs to ensure a viable master plan for improved police and fire communications and records coordination. Prepares oral and written reports regarding CLEMIS projects and emergency management activities. Utilizes current countywide and/or department specific software to complete assignments. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGE, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a Bachelor's Degree from an accredited college or university with a major in Business Administration, Public Administration, Criminal Justice, Computer Science, or a closely related field. 2. Have at least five (5) years of full-time work experience in the planning and implementation of public safety management information, telecommunications, and/or radio communication systems. NOTE: A Master’s Degree in Business Administration, Public Administration, Criminal Justice, Computer Science, or a closely related field may substitute for one year of experience as described above. 3. Posses a valid motor vehicle operator’s or chauffeur’s license. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable knowledge of and experience in working with public safety communications, dispatch, and information management systems, including E9-1-1, LEIN, Computer-Aided DRAFT 4-25-25 Dispatch, mobile data, and voice radio. 2. Considerable knowledge of and experience in working with equipment utilized in delivering public safety communication and management information services and emergency services. 3. Considerable experience in working with public safety agencies, political subdivisions, and emergency response situations. 4. Considerable ability to compile statistics, decipher pertinent information, and present oral and written financial, operational and other types of departmental reports to officials and other interested groups or individuals 5. Considerable ability to deal tactfully with public officials, and considerable experience in preparing effective presentations and speaking before committees and public groups. 6. Considerable ability to cope with difficult and/or emergency situations requiring immediate decisions in accordance with departmental policies and objectives. 7. Considerable ability to effectively supervise a staff of professional, technical and clerical employees. 8. Considerable knowledge of pertinent rules, regulations, policies, procedures and legislation, including those of the Federal Communication, Commission, Federal Emergency Management Agency, Michigan Public Services Commission, LEIN, NCIC, MSP-Emergency Management Division, Emergency Telephone Services Committee, and other related regulatory bodies. 9. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail and Internet software. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS APPLICATION ARCHITECT Department: Information Technology Reports To: Chief or Manager FLSA Status: Exempt Salary Plan: UNI/132 GENERAL SUMMARY Defines and guides the evolution of the organization’s overall enterprise application portfolio from current to future state. Analyzes enterprise business drivers to determine corresponding change requirements for the organization. Analyzes the IT environment to detect critical deficiencies, and recommend solutions for improvement. Analyze technology industry and market trends, and determine their potential impact on the enterprise. Define the principles to guide solution decisions for the enterprise. Design and lead the implementation of enterprise application architecture based on enterprise business requirements and IT strategies. Design and direct the governance activities associated with ensuring compliance with established standards and practices. Prepares and presents oral and written reports to officials within and outside the County. On call 24 hours a day, 7 days per week to respond to emergencies concerning systems operations. Utilizes current countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Performs as a technical expert for all applications. May provide work leader responsibilities including assigning, assisting and checking the work of others. ESSENTIAL JOB FUNCTIONS Develop and advocate a road map of the evolution of the enterprise application portfolio from current to future state (as defined by the Enterprise Architecture Program). Coordinate solution architecture implementation and modification activities. Facilitate the evaluation and selection of software product standards, as well as the design of standard software configurations. Consult with application or infrastructure development projects to fit systems or infrastructure to architecture, and identify when it is necessary to modify the solution architecture to accommodate project needs. Work closely with the Enterprise Architecture Program to ensure alignment of plans with what is being delivered. CLASS TITLE: CLEMIS APPLICATION ARCHITECT 2 Identify the organizational impact (for example, on skills, processes, structures or culture) and financial impact of the Enterprise Architecture Program. Recommends and establishes department standards for the systems development life cycle (SDLC), involving design and documentation of specifications, selection and implementation of SDLC tools, and technical review. Applies an advanced knowledge of systems development techniques to guide highly complex programming assignments and system design projects, to ensure proper interpretation and completion and adherence to standards. Completes programming functions on highly complex programs, including the design and development of new automated systems from their inception to implementation. Utilizes current county-wide and/or department specific software to complete assignments. NON-ESSENTIAL JOB FUNCTIONS Prepares and presents oral or written reports to customers or department management in response to their requests and identified needs. Maintains effective customer communication during system development and operation. Document all solution architecture design and analysis work. ESSENTIAL PHYSICAL & MENTAL REQUIREMENTS Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a normal office environment. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Business Administration, or a field directly related to their operating department's subject matter area. 2. Have had at least five (5) years of full-time work experience at a computer facility involving systems software, systems analysis, or programming; two (2) years of which were in a project leader or CLASS TITLE: CLEMIS APPLICATION ARCHITECT 3 supervisory capacity of professional technical staff. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable knowledge of and ability in programming techniques, such as coding, testing, debugging, documentation, computer operations and applications. 2. Exposure to multiple, diverse technologies and processing environments. 3. Experience completing a highly complex enterprise application development project from initial concept through implementation. 4. Exceptional interpersonal skills, including teamwork, facilitation and negotiation. 5. Strong leadership skills. 6. Excellent analytical and technical skills. 7. Excellent written and verbal communication skills. 8. Excellent planning and organizational skills. 9. Knowledge of all components of an enterprise technical architecture. 10. Knowledge of business process re-engineering principles and processes. 11. Basic knowledge of financial models and budgeting. 12. Strong understanding of network architecture and application development methodologies. 13. Strong understanding of SOA, object-oriented analysis and design, and/or client/server systems. 14. Ability to understand the long-term ("big picture") and short-term perspectives of situations. 15. Ability to translate business needs into solution architecture requirements. 16. Ability to estimate the financial impact of solution architecture alternatives. 17. Ability to apply multiple technical solutions to business problems. 18. Ability to quickly comprehend the functions and capabilities of new technologies. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS BUSINESS ANALYST Department: Information Technology Reports To: An assigned professional supervisor FLSA Status: Non-Exempt Salary Plan: UNI/124 GENERAL SUMMARY Possesses and applies a comprehensive knowledge of operating department application needs. Acts as liaison between the Information Technology department and the CLEMIS municipalities, and local agencies involved in the implementation, maintenance and modification of critical Countywide software applications. As a senior technical employee, is very knowledgeable of the business practices of a complex area, facilitates work group sessions to ascertain needs, identifies user problems and their solutions, and determines process flow. Works with user committees to design proposals for improved applications. Supports analytical functions by assisting programmers in ascertaining user needs and adapting user procedures to final program design. May develop scope and approach for application projects. May work with a project team performing systems analysis necessary in the design and implementation of critical Countywide applications, which are highly integrated into multiple department business operations. Provides input, facilitates, and implements process re-engineering changes required to meet Information Technology requirements and operating department needs. Provides reports and return on investment analysis of departmental Information Technology related projects. Acts as the work leader of a small staff. Develops training approaches and materials to meet identified needs. Ensures that Service Center needs are met. Utilizes current Countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Functions as a lead worker over lower level staff. Instructs, assigns, and reviews the work of lower level staff. ESSENTIAL JOB FUNCTIONS Trains users in all aspects of the operation of their particular system. Responds to questions of application programmer staff working on software related requests of operating departments. Provides an operating department and a systems perspective. Maintains records of difficulties encountered by systems users, reviews and collects related data, and CLASS TITLE: CLEMIS BUSINESS ANALYST 2 provides such data to be used in correcting and/or modifying the programs involved for the team leader. Performs application system administration functions such as maintenance of user access identification, and application access levels. Answers all manner of inquiry regarding the functioning of various hardware and software systems. Assists customers in the resolution of difficulties encountered in the operation of their particular system. Communicates with vendors to resolve hardware and software difficulties. Provides for the instruction of operating departments in the preparation of input data and the interpretation and use of subsequent output generated. Prepares or assists in preparing and maintaining user manuals, training guides, detailed procedures, helpful hint guides, newsletters, etc. Maintains records of difficulties encountered by users and provides recommended solutions to prevent further difficulties after collecting and reviewing related data. Reviews and forwards for approval invoices covering contracted and non-contracted services performed for various cities, villages, townships and other local governmental agencies. Visits users to ascertain the services desired and reviews specific problem areas relative to Information Technology services. Keeps user agencies or departments informed of modifications in procedures, input/output reports, system capabilities, and other related changes. Communicates and carries out Information Technology department policies and procedures. Evaluates new technologies for Countywide or operating department use. Assists with acceptance testing of new software installations, enhancements, and upgrades. Utilizes current Countywide and/or department specific software to complete assignments. ADDITIONAL DUTIES & RESPONSIBLITIES Prepares and analyzes information for detailed, complex or coded reports. Facilitates business process work group sessions, documents findings, and assimilates recommendations for process improvements or the application of standard or new technologies. May perform needs assessments and prepare project scope and approach and return on investment analysis applying Information Technology standards to particular customer needs. Assists in the application for federal and state grants for Information Technology department programs, CLASS TITLE: CLEMIS BUSINESS ANALYST 3 and with subsequent grant provision compliance. Monitors data flow between Information Technology and user departments or agencies to ensure input data is timely and correct and that users receive generated reports as scheduled. Coordinates computer moves, system upgrades and system maintenance with other Information Technology staff and the operating department or agency. Confirms software business requirements comply with local, state, or federal mandates. Manages and monitors progress of operating department’s project deliverables commitments to insure they are completed on-time. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. Ability to operate a motor vehicle and/or be a passenger. WORKING CONDITIONS Work is performed in a typical office environment. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. A. Possess a Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Business Administration, Public Administration, Communications, Criminal Justice, Law Enforcement, Fire Science, and Emergency Management; AND B. Have had at least two (2) years of full-time work experience in the development and support of information systems within the assigned subject matter area: CLEMIS, GIS, Data Warehousing, Finance, Personnel, Public Safety, Law Enforcement, Fire Services, Emergency Management/Disaster Control, Project Management, Tax Appraisal/Equalization, Courts, Health and Human Services. OR 2. A. Possess a Bachelor's Degree from an accredited college or university with any field of CLASS TITLE: CLEMIS BUSINESS ANALYST 4 study; AND B. Have had at least four (4) years of full-time work experience in the development and support of information systems within the assigned subject matter area: CLEMIS, GIS, Data Warehousing, Finance, Personnel, Public Safety, Law Enforcement, Fire Services, Emergency Management/Disaster Control, Project Management, Tax Appraisal/Equalization, Courts, Health and Human Services. OR 3. A. Possess an Associate’s degree from an accredited college or university in in Computer Science, Information Systems, Business Administration, Public Administration, Communications, Criminal Justice, Law Enforcement, Fire Science, and Emergency Management; AND B. Have had at least four (4) years of full-time work experience in the development and support of information systems within the assigned subject matter area: CLEMIS, GIS, Data Warehousing, Finance, Personnel, Public Safety, Law Enforcement, Fire Services, Emergency Management/Disaster Control, Project Management, Tax Appraisal/Equalization, Courts, Health and Human Services. OR 4. A. Be a high school graduate or possess the General Education Development (GED) certification; AND B. Have had at least six (6) years of full-time work experience in the development and support of information systems within the assigned subject matter area: CLEMIS, GIS, Data Warehousing, Finance, Personnel, Public Safety, Law Enforcement, Fire Services, Emergency Management/Disaster Control, Project Management, Tax Appraisal/Equalization, Courts, Health and Human Services. OR B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable ability to interpret technical procedures to agency employees, public officials and other less technical personnel. 2. Considerable knowledge of data processing capabilities, operations, and applications. 3. Considerable ability to establish and maintain effective working relationships with other department employees and with representatives of user departments and municipalities. 4. Considerable ability to follow complex oral and written instructions. 5. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail and Internet software. 6. Reasonable knowledge of current hardware and software technologies and uses. 7. Reasonable oral presentation ability, writing proficiency, and visual graphics design. CLASS TITLE: CLEMIS BUSINESS ANALYST 5 5. Strong attention to detail and highly organized. 6. Demonstrated critical and analytical thinking skills and abilities. C. SPECIAL REQUIREMENTS 1. Must pass a background check performed by the County or other appropriate agencies as required. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS IT SUPERVISOR I Department: Information Technology Reports To: A Manager or Chief within Information Technology Department FLSA Status: Exempt Salary Plan: UNI/130 GENERAL SUMMARY Responsible for ensuring that complex software applications/systems or infrastructure are designed, configured, or coded, built, tested, and completed accurately and on time. Prepares budgets and monitors project expenses. Works closely with a wide variety of customers to select, modify, install, and maintain efficient computer systems. Participates with operating departments in the development and implementation of multi-phase multi-year programs. Provides effective presentations on a variety of project related issues. Confers with user representatives to determine needs and identify areas of potential improvement. Monitors effective use of technology and assists in training user personnel in the operation of new or modified systems procedures. Provides expert application/technology advice for a variety of computer system needs as the supervisor of a specific user team of application and/or system professionals. Utilizes current countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Functions as a supervisor over a group of professional and technical employees. Instructs, assigns, schedules, checks work, and appraises performance. Participates in decisions to hire, discipline, discharge, and award pay increases and/or promotions. ESSENTIAL JOB FUNCTIONS Performs and/or directs complex studies in County departments and/or local agencies to determine the feasibility and economic advisability of various software and computer technology approaches to a particular operation. Develops methodology for implementing new systems or improving existing ones. Confers with department heads and/or local administrators to determine specific problems and system requirements. Prepares and presents cost estimates and cost/benefits justifications for various new system designs for use in discussing their feasibility with the end user. Analyzes alternative means of deriving input data for use in a particular system to enable the selection of the most advantageous method. CLASS TITLE: CLEMIS IT SUPERVISOR I 2 Organizes information into accessible work files, prepares detailed program specifications, and performs other systems design functions necessary to implement new systems. Prepares system development, user and operational documentation detailing the requirements of new systems for users and IT personnel to ensure smooth implementation and effective utilization. Directs, monitors, and tracks progress of approved project plans including managing and directing resources as needed. Monitors consistency in adhering to system production schedules and the effectiveness with which they use the established processes to detect and correct problems as they occur. May be responsible for assisting management in determining the scope and objectives of standards, policies, and procedures, and preparing, developing, and maintaining a Standards, Policies and Procedures Manual for the IT Department. Participates in the process and supervises the implementation of information systems to ensure that the County IT Department is compliant with State and Federal regulatory standards, including, but not limited to HIPPA, CJIS, and PCI. Follows system development life cycle (SDLC) to facilitate process improvements with county customers/partners, suppliers/vendors, team members to provide improved functionality for county operations. Evaluates and communicates impact of application / system or infrastructure changes and mitigates risk to ensure minimal user interruption. Leads and directs efforts towards system implementation, integration and upgrades of applications / systems or infrastructure, projects, or programs. Directs and secures approval for Requests for Proposal as needed for projects. Facilitates various sessions involving operational department needs identification, analysis, and solutions. Assists in training user personnel in the operation of new or modified system procedures. May be responsible for planning, administering, and evaluating departmental training and educational programs to provide for the professional development of IT personnel. Functions as a supervisor over a group of professional and technical employees, including response to policy/procedure issues as needed and monitoring customer satisfaction. Oversees planning, scheduling, conducting, and evaluation of county-wide technical training classes. Supervise a team responsible for the implementation, operation, and maintenance of a wide variety of custom developed and commercially provided business applications, used by internal County staff, external governmental partners, and/or the public. Responsible for operation, maintenance, and support of complex county owned radio systems as well as CLASS TITLE: CLEMIS IT SUPERVISOR I 3 PSAP. CAD and 911 support. Maintains and supervises a radio shop that designs/supports/repairs radio systems including maintaining needed parts and supplies. Assures that systems comply with state and federal regulations. Utilizes current Countywide and/or department specific software to complete assignments. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a typical office or centralized computer facility environment. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. a. Possess a Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Business Administration, Engineering, or a related field of study. b. Have had at least three (3) years of full-time work experience in one or a combination of the following: System Analysis and Design, System Implementation, Programming – C#, ASP.Net, MVC, JavaScript, Visual Basic, Java, J2EE, MS SharePoint, HTML, CSS, XML, SQL Server, Oracle, PowerShell, Python, IIS, IBM WebSphere, Tomcat, ESRI technologies, MS Access, COBOL, CICS, JCL, VSAM, servicing mobile communications equipment, or related technologies; OR 2. a. Possess sixty (60) semester credit hours from an accredited college or university in Computer Science, Information Systems, Business Administration, Engineering, or a related field. b. Have had at least five (5) years of full-time work experience as specified in 1B above; OR 3. a. Be a high school graduate or have a certificate of successful completion of the General Education Development (GED) test. CLASS TITLE: CLEMIS IT SUPERVISOR I 4 b. Have had at least seven (7) years of full-time work experience as specified in 1B above. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable ability to interpret technical data and IT terminology to department representatives, agency officials, and other lay personnel. 2. Considerable ability to establish and maintain effective working relationships with other I T employees and with representatives of user departments and municipalities. 3. Considerable ability to exercise mature judgment and initiative in analyzing problems and recommending solutions. 4. Considerable ability to communicate effectively, both orally and written. 5. Considerable knowledge of the assigned operating department’s goals and objectives which impact their computer systems and technology needs. 6. Considerable knowledge of various computer system capabilities, operations, and applications. 7. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail, and Internet software. 8. Considerable knowledge of Project Management concepts, including risk assessment, issues management, and quality control. 9. Reasonable ability to work with a high degree of accuracy in reviewing and processing complex data. 10. Reasonable knowledge of local government programs and operations. 11. Reasonable knowledge of IT practices and procedures as utilized in governmental applications. 12. Reasonable knowledge of modern office and record keeping practices, procedures, and equipment. C. SPECIAL REQUIREMENTS 1. Must pass a background check performed by the County or other appropriate agencies as required. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS SYSTEMS ANALYST SENIOR Department: Information Technology Reports To: Supervisor I or II – IT or higher level staff FLSA Status: Exempt Salary Plan: UNI/129 GENERAL SUMMARY Develops and improves strategic processes and direction for projects as a technology expert. Utilizes considerable expertise of a specialized, complex area within the department to perform complex, system- wide duties and provide technology leadership. Renders expert technical advice and influence. Responsible for solving highly technical and complex problems for several simultaneous projects. Effectively influences enterprise approaches and methodologies. Performs effective system analysis for the most difficult projects and translates findings into specifications and program code for highly complex cooperative processing systems utilizing multiple platform technologies. Prepares and presents oral and written reports to officials within and outside the County. Duties may require 24 hour, 7 days per week on-call responsibility for application support. Utilizes current county-wide and/or department specific software to complete assignments. SUPERVISION EXERCISED Typically performs as a technical expert of a major application. May provide work leader responsibilities including assigning, assisting and checking the work of others. ESSENTIAL JOB FUNCTIONS Utilizes considerable expertise to perform complex, system-wide duties and provide technology leadership in various areas. As a technology expert, develops and improves strategic processes and direction for projects. Provides expert advice. Applies an advanced knowledge of systems development techniques to highly complex programming assignments and system design projects, to ensure proper interpretation and completion. Implements current software development security best practices and standards. Utilizes an advanced understanding of flat file and data base design considerations to prepare the most effective solutions to defined data processing needs. Prepares test data for multiple integrated systems. CLASS TITLE: CLEMIS SYSTEMS ANALYST SENIOR 2 Completes programming functions on highly complex programs, including the design and development of new automated systems from their inception to implementation. Prepares test data for both the individual program component as well as the fully integrated system. Prepares and presents oral or written reports to customers or department management in response to their requests and identified needs. Maintains effective customer communication during system development and operation. Confers with customers in order to define and develop requirements and cost benefits justifications for complex automation projects. Develops project plans with estimates and completion dates for large, highly complex automated systems. Follows established department standards during the systems development life cycle, involving design and documentation of specifications, cost/benefit analysis, and technical review. Participates in problem determination and program debugging in order to locate and correct errors in new and existing programs, including those of colleagues and staff. Responsible for reviewing complex systems and determining future requirements in order to maintain as well as improve system performance. Performs analysis on information requests for systems assistance on complex data base systems. Performs Commercial off-the-shelf (COTS) package selection analysis. Prepares financial analysis of automation projects including the identification of start-up costs, operational cost, tangible and intangible benefits, and return on investment. Prepare post-implementation audits and quality checks to ensure systems perform as intended. Utilizes current countywide and/or department specific software to complete assignments. ADDITIONAL DUTIES & RESPONSIBILITIES Maintains awareness of and evaluate new technical developments and advise management of the impact to the organization. Develops requests for proposals (RFP) and analyzes responses. ESSENTIAL PHYSICAL & MENTAL REQUIREMENTS Ability to communicate to accurately convey information. Ability to gather, interpret and analyze data of various sources. CLASS TITLE: CLEMIS SYSTEMS ANALYST SENIOR 3 WORKING CONDITIONS Work is performed in a typical office or centralized computer facility environment. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. A. Possess a Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Business Administration, Engineering, or a related field; AND B. Have had at least three (3) years of full-time work experience in one or a combination of the following: System Analysis and Design, Programming – C#, ASP.Net, MVC, JavaScript, Visual Basic, Java, J2EE, MS SharePoint, HTML, CSS, XML, SQL Server, Oracle, PowerShell, Python, IIS, IBM WebSphere, Tomcat, PeopleSoft, PeopleCode, ESRI technologies, MS Access, COBOL, CICS, JCL, VSAM, or related technologies; OR 2. A. Possess sixty (60) semester credit hours from an accredited college or university in Computer Science, Information Systems, Business Administration, Engineering, or a related field; AND B. Have had at least five (5) years of full-time work experience as specified in 1B above; OR 3. A. Be a high school graduate or have a certificate of successful completion of the General Education Development (GED) test; AND B. Have had at least seven (7) years of full-time work experience as specified in 1B above. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Expert knowledge of and ability in programming techniques, such as documentation, testing, debugging, and applications. 2. Considerable ability to devise new procedures and initiate improvements in existing programming practices and procedures. CLASS TITLE: CLEMIS SYSTEMS ANALYST SENIOR 4 3. Considerable ability and skill in interpreting programming techniques and procedures to agency personnel and related parties. CLASS TITLE: CLEMIS SYSTEMS ANALYST SENIOR 5 4. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail and Internet software. 5. Reasonable ability to logically analyze numerical and narrative data. 6. Reasonable ability to work with a high degree of accuracy in reviewing and processing complex data. 7. Reasonable ability to follow oral and written instructions. 8. Reasonable ability to prepare and present technical written and oral reports. C. SPECIAL REQUIREMENTS 1. None DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS SUPPORT SPECIALIST Department: Information Technology Reports to: Manager - CLEMIS FLSA Status: Non-Exempt Salary Plan: UNI/112 GENERAL SUMMARY Acts as a contact person for communications and/or training between project team, County departments, municipalities and other customers. Facilitates and assists with the instruction of county department personnel in all aspects of personal computer hardware and software usage. Prepares or assists in preparing and maintaining user manuals and other related documentation. Performs clerical and secretarial support functions for the project team. Resolves and/or assists higher level Information Technology personnel in the resolution of customer difficulties. Documents difficulties encountered by system users and makes recommendations for resolving future difficulties. Utilizes current countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Functions as a work leader over office support staff. Instructs, assigns and reviews work. ESSENTIAL JOB FUNCTIONS Assists with the instruction of county department personnel in all aspects of personal computer hardware and software usage. Prepares or assists in preparing and maintaining user manuals, training guides, detailed procedures, helpful hint guides, tip sheets, newsletters, etc. Receives user requests for printer ribbons, paper, hardware or other items and forwards to appropriate personnel for processing. Tapes dictation from meeting for later transcription. Uses personal computer software to type general correspondence, legal documents, and other items relating to project and departmental communication. Composes, types and proofreads general letters, memoranda and notices from rough drafts or general instructions. CLASS TITLE: CLEMIS SUPPORT SPECIALIST Uses network communications to message and schedule department staff. Operates a variety of personal computer software, including word processing, spreadsheet and graphics. Operates a variety of related equipment such as a scanner, fax, modem and laser printer. Assists customers in the resolution of difficulties encountered in the operation of their particular system and answers inquiries, within expertise, regarding the functioning of the data processing system. Maintains records of difficulties encountered by system users, reviews and collects related data, and provides recommended solutions to prevent further difficulties. Acts as liaison between the Information Technology Department and other County departments, municipalities, and local agencies served by Office Automation Support Services. Keeps user agencies or departments informed of modifications in procedures, input/output reports, system capabilities, and other related changes. Utilizes current countywide and/or department specific software to complete assignments. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGE, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Must be a high school graduate or have a certificate of successful completion of the General Educational Development Test; AND 2. Have had four (4) years of increasingly responsible clerical experience involving procedure, technical report writing, and/or direct assistance to operating departments. 3. Pass the complete examination, including the employment medical, established for the class of Project Support Specialist. 4. Satisfactorily complete the six month probationary period. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable knowledge of and experience in performing a wide variety of data processing and microcomputer support activities. 2. Considerable knowledge of specialized terminology utilized in the data processing field, as well as procedures relating to the operations of that area. 3. Considerable ability and skill to recognize and correct departures from routine departmental practices and procedures. 4. Considerable knowledge of and experience in modern office practices and procedures, as well as record keeping management systems and operations. 5. Considerable ability to communicate well orally and in writing. 6. Considerable ability to follow oral and written instructions. 7. Considerable knowledge of grammar, spelling, and punctuation. 8. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail and Internet software. 9. Reasonable ability and skill in initiating improvements in departmental practices and procedures. 10. Reasonable knowledge of current hardware and software technologies and uses. DRAFT 4-25-25 OAKLAND COUNTY MICHIGAN Class Title: CLEMIS USER SUPPORT SPECIALIST II Department: Information Technology Reports To: An assigned professional supervisor FLSA Status: Non-Exempt Salary Plan: UNI/121 GENERAL SUMMARY Acts as liaison between the Information Technology department and other County departments, municipalities, and local agencies involved in the implementation, maintenance and modification of particular software applications on an on-going basis as opposed to a project basis. Possesses and applies a broad knowledge of operating department application needs. Effectively serves as a liaison to communicate Information Technology policy and procedure. Identifies department needs and provides input to assist Information Technology team for software design and implementation. Experienced in implementing Information Technology determined process re-engineering needs in operating department(s). May provide reports and return on investment analysis. Effectively trains staff in proprietary software or County standard software used, and provides Service Center assistance. Utilizes current countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED May lead staff on a project basis. ESSENTIAL JOB FUNCTIONS Trains users in all aspects of the operation of their particular system. Responds to questions of application programmer staff working on software related requests of operating departments. Provides input from an operating department and a systems perspective. May assist in the application for federal and state grants for Information Technology department programs, and with subsequent grant provision compliance. Answers all manner of inquiry regarding the functioning of various hardware and software systems. Assists customers in the resolution of difficulties encountered in the operation of their particular system. Communicates with vendors to resolve hardware and software difficulties. CLASS TITLE: CLEMIS USER SUPPORT SPECIALIST II 2 Provides for the instruction of operating departments in the preparation of input data and the interpretation and use of subsequent output generated. Prepares or assists in preparing and maintaining user manuals, training guides, detailed procedures, helpful hint guides, newsletters, etc. Maintains records of difficulties encountered by users and provides recommended solutions to prevent further difficulties after collecting and reviewing related data. Reviews and forwards for approval invoices covering contracted and non-contracted services performed for various cities, villages, townships and other local governmental agencies. Monitors data flow between Information Technology and user departments or agencies to ensure input data is timely and correct and that users receive generated reports as scheduled. Visits users to ascertain the services desired and reviews specific problem areas relative to Information Technology services. Keeps user agencies or departments informed of modifications in procedures, input/output reports, system capabilities, and other related changes. Communicates and carries out Information Technology department policies and procedures. Coordinates computer moves, system upgrades and system maintenance with other Information Technology staff and the operating department or agency. Confirms software business requirements comply with local, state, or federal mandates. Utilizes current Countywide and/or department specific software to complete assignments. ADDITIONAL DUTIES & RESPONSIBILITIES Visits users to ascertain the services desired and reviews specific problem areas relative to Information Technology services. Assists with acceptance testing of new software installations, enhancements, and upgrades. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. Ability to operate a motor vehicle and/or be a passenger. WORKING CONDITIONS CLASS TITLE: CLEMIS USER SUPPORT SPECIALIST II 3 Work is performed in a typical office environment. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. a. Possess a Bachelor’s Degree from an accredited college or university with a major in Computer Science, Information Systems, Business Administration, Public Administration, Communications, Criminal Justice, Law Enforcement, Fire Science, and Emergency Management or a closely related field; AND b. Have had at least two (2) years of full-time professional work experience in system analysis and support; training users on systems and/or applications; OR system/software testing and implementation in one of the following subject areas: GIS, Data Warehousing Project Management, Finance, Human Resources, Public Safety, Law Enforcement, Fire Services, Emergency Management/ Disaster Control, Tax Appraisal/Equalization, Courts, Health and Human Services, Information Technology Support, or a closely related area; OR 2. a. Possess an Associate’s Degree from an accredited college or university with a major in Computer Science, Information Systems, Business Administration, Public Administration, Communications, Criminal Justice, Law Enforcement, Fire Science, and Emergency Management or a closely related field; AND b. Have had at least four (4) years of full-time professional work experience in system analysis and support; training users on systems and/or applications; OR system/software testing and implementation in one of the following subject areas: GIS, Data Warehousing Project Management, Finance, Human Resources, Public Safety, Law Enforcement, Fire Services, Emergency Management/ Disaster Control, Tax Appraisal/Equalization, Courts, Health and Human Services, Information Technology Support, or a closely related area; OR 3. a. Must be a high school graduate or have a certificate of successful completion of the General Education Development Test; AND b. Have had at least six (6) years of full-time professional work experience in system analysis and support; training users on systems and/or applications; OR system/software testing and implementation in one of the following subject areas: GIS, Data Warehousing Project Management, Finance, Human Resources, Public Safety, Law Enforcement, Fire Services, Emergency Management/ Disaster Control, Tax Appraisal/Equalization, Courts, Health and Human Services, Information Technology Support, or a closely related area. 4. Possess a valid United States motor vehicle operator’s or chauffeur’s license. CLASS TITLE: CLEMIS USER SUPPORT SPECIALIST II 4 B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable ability to interpret technical procedures to agency employees, public officials and other less technical personnel. 2. Considerable knowledge of data processing capabilities, operations, and applications. 3. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail and Internet software. 4. Reasonable ability to establish and maintain effective working relationships with other department employees and with representatives of user departments and municipalities. 5. Reasonable ability to follow complex oral and written instructions. 6. Reasonable knowledge of current hardware and software technologies and uses. 7. Reasonable oral presentation ability, writing proficiency, and visual graphics design. C. SPECIAL REQUIREMENTS 1. Must maintain a valid United States motor vehicle operator’s or chauffeur’s license. 2. Must pass a background check performed by the County or other appropriate agencies as required. Draft 4-29-25 OAKLAND COUNTY MICHIGAN Class Title: HUMAN RESOURCES BUSINESS PARTNER SENIOR Department: Human Resources Reports To: Director of Human Resources or Deputy Director of Human Resources FLSA Status: Exempt Salary Plan: UNI/127 GENERAL SUMMARY Serves as internal Human Resources Consultant, working closely with assigned cohort of departments’ leadership teams to implement Human Resources programs focused on attracting, retaining, and motivating staff to their greatest potential. Provides counsel and guidance on all HR matters for departments that have 300 or more employees and/or represented by multiple bargaining units, serving as a single point of contact for leaders. Promotes organizational effectiveness across all County departments by advancing leadership teams’ understanding of the HR business value to department operations. Advances departmental leadership effectiveness through coaching, advising, connection to training opportunities, and bringing best practices to light. Utilizes current Countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Serves in a leadership capacity, coordinating the workflow of staff in the delivery of Human Resources services to departments. Works closely with unit Managers to resolve issues. May directly supervise interns or support staff as assigned. ESSENTIAL JOB FUNCTIONS Serves as primary point of contact for assigned departments. Provides customer-centered Human Resources support, brokering HR solutions for internal customers, expediting HR processes, and ensuring exceptional service for individual employees, department leaders and department employee records coordinators. Assists in connecting internal customers to quick and customized solutions for the full range of Human Resources including classification, compensation, wellness and benefits, retirement, recruitment and staffing, training and professional development, complaint and grievance procedures, human resources records and reporting, and other areas as needed. Partners with departmental leadership to develop strategic plans for talent strategies that align with business priorities. Provides data, demographics, and forecasts to support departmental analysis of short and long-range staffing needs, training, and staff development priorities. Assists in identifying trends and monitoring performance metrics pertaining to human resources within assigned departments. CLASS TITLE: HUMAN RESOURCES BUSINESS PARTNER SENIOR 2 Serves as organizational mission advocate, translating how the broader mission, vision and goals tie to human resources strategy and departmental operations. Supports progressive talent management strategies for teams such as succession planning, talent reviews, and individual development planning. Communicates the business value of Human Resources within assigned departments. Promotes departmental understanding of Human Resources processes and compliance requirements, and how strong systems mitigate risk, improve operations, and deliver on organizational mission. Assists in building capacity among departmental employee records coordinators. Enhances leadership effectiveness through coaching, advising, connection to training opportunities, and bringing best practices to light. Supports organizational change management efforts and works in partnership with departments to identify and resolve people challenges and organizational culture issues. Supports and champions diversity, equity, and inclusion initiatives across County departments. Promotes positive, consistent, and compliant Labor and Employee Relations. Assists department supervisors and staff with uniformly applying rules and contract requirements, managing performance, and addressing related issues or concerns as they arise. Works closely with Employee/Labor Relations, legal, and leadership as appropriate. Supports and participates in the grievance process and other labor relations activities. Promotes and implements programs to advance employee engagement and retention. Advises department leaders and managers in developing action plans that achieve goals. Serves as liaison between department leaders and HR leadership to troubleshoot issues and identify opportunities for process improvement or policy change. Educates internal customers on process changes and implements new policies and procedures in the field. Utilizes current Countywide and/or department specific software to complete assignments. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a typical office environment and at the offices of assigned departments. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. CLASS TITLE: HUMAN RESOURCES BUSINESS PARTNER SENIOR 3 EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a Bachelor's degree from an accredited college or university with a major in Human Resources Development, Organizational Development, Business Administration, Psychology, or a closely related 2. Have had seven (7) years of full-time progressive Human Resources experience, including two (2) years of experience as a Human Resources Business Partner. NOTE: A Master's degree in one of the degree areas listed above may be substituted for two (2) years of the required experience. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Eight (8) years of full-time progressive Human Resources experience is preferred. 2. Demonstrated project management with the ability to partner with diverse stakeholders to meet timetables, milestones, and deliverables. 2. Considerable ability to work in a team environment, manage multiple projects, and provide strong consultative skills. 3. Considerable ability to establish and maintain effective working relationships and communicate effectively across all levels of stakeholders. 4. Proven success communicating key HR initiatives across multiple channels and to a diverse audience. 5. Reasonable ability to carry out written and oral instructions. 6. Reasonable ability to exercise mature judgement and initiative in analyzing problems and recommending solutions. 7. Reasonable ability to present ideas effectively, either orally or in writing. 8. Reasonable knowledge of principles of governmental organization and administration. DRAFT 4-29-25 OAKLAND COUNTY MICHIGAN Class Title: HUMAN RESOURCES BUSINESS PARTNER Department: Human Resources Reports To: Director of Human Resources or Deputy Director of Human Resources FLSA Status: Exempt Salary Plan: UNI/126 GENERAL SUMMARY Serves as internal Human Resources Consultant, working closely with assigned cohort of departments’ leadership teams to implement Human Resources programs focused on attracting, retaining, and motivating staff to their greatest potential. Provides counsel and guidance on all HR matters, serving as a single point of contact for leaders. Promotes organizational effectiveness across all County departments by advancing leadership teams’ understanding of the HR business value to department operations. Advances departmental leadership effectiveness through coaching, advising, connection to training opportunities, and bringing best practices to light. Utilizes current Countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Serves in a leadership capacity, coordinating the workflow of staff in the delivery of Human Resources services to departments. Works closely with unit Managers to resolve issues. May directly supervise interns or support staff as assigned. ESSENTIAL JOB FUNCTIONS Serves as primary point of contact for assigned departments. Provides customer-centered Human Resources support, brokering HR solutions for internal customers, expediting HR processes, and ensuring exceptional service for individual employees, department leaders and department employee records coordinators. Assists in connecting internal customers to quick and customized solutions for the full range of Human Resources including classification, compensation, wellness and benefits, retirement, recruitment and staffing, training and professional development, complaint and grievance procedures, human resources records and reporting, and other areas as needed. Partners with departmental leadership to develop strategic plans for talent strategies that align with business priorities. Provides data, demographics, and forecasts to support departmental analysis of short and long-range staffing needs, training, and staff development priorities. Assists in identifying trends and monitoring performance metrics pertaining to human resources within assigned departments. CLASS TITLE: HUMAN RESOURCES BUSINESS PARTNER 2 Serves as organizational mission advocate, translating how the broader mission, vision and goals tie to human resources strategy and departmental operations. Supports progressive talent management strategies for teams such as succession planning, talent reviews, and individual development planning. Communicates the business value of Human Resources within assigned departments. Promotes departmental understanding of Human Resources processes and compliance requirements, and how strong systems mitigate risk, improve operations, and deliver on organizational mission. Assists in building capacity among departmental employee records coordinators. Enhances leadership effectiveness through coaching, advising, connection to training opportunities, and bringing best practices to light. Supports organizational change management efforts and works in partnership with departments to identify and resolve people challenges and organizational culture issues. Supports and champions diversity, equity, and inclusion initiatives across County departments. Promotes positive, consistent, and compliant Labor and Employee Relations. Assists department supervisors and staff with uniformly applying rules and contract requirements, managing performance, and addressing related issues or concerns as they arise. Works closely with Employee/Labor Relations, legal, and leadership as appropriate. Supports and participates in the grievance process and other labor relations activities. Promotes and implements programs to advance employee engagement and retention. Advises department leaders and managers in developing action plans that achieve goals. Serves as liaison between department leaders and HR leadership to troubleshoot issues and identify opportunities for process improvement or policy change. Educates internal customers on process changes and implements new policies and procedures in the field. Utilizes current Countywide and/or department specific software to complete assignments. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a typical office environment and at the offices of assigned departments. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. CLASS TITLE: HUMAN RESOURCES BUSINESS PARTNER 3 EXPERIENCE, TRAINING, KNOWLEDGES, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Possess a Bachelor's degree from an accredited college or university with a major in Human Resources Development, Organizational Development, Business Administration, Psychology, or a closely related 2. Have had five (5) years of full-time progressive Human Resources experience, including two (2) years of employee or labor relations. NOTE: A Master's degree in one of the degree areas listed above may be substituted for two (2) years of the required experience. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Demonstrated project management with the ability to partner with diverse stakeholders to meet timetables, milestones, and deliverables. 2. Considerable ability to work in a team environment, manage multiple projects, and provide strong consultative skills. 3. Considerable ability to establish and maintain effective working relationships and communicate effectively across all levels of stakeholders. 4. Proven success communicating key HR initiatives across multiple channels and to a diverse audience. 5. Reasonable ability to carry out written and oral instructions. 6. Reasonable ability to exercise mature judgement and initiative in analyzing problems and recommending solutions. 7. Reasonable ability to present ideas effectively, either orally or in writing. 8. Reasonable knowledge of principles of governmental organization and administration. 4.18.2025 LJ DRAFT OAKLAND COUNTY MICHIGAN Class Title: PARKS ADMINISTRATIVE SPECIALIST Department: Parks and Recreation Reports To: Supervisor Parks Engineering FLSA Status: Non-Exempt Salary Plan: UNI/114 GENERAL SUMMARY Functions as a subject matter expert in utilizing County standard and department specific software applications, third-party applications, database systems and technology to complete assignments. Maintains and updates large, mission critical database systems utilized for immediate information needs of upper-level staff, in addition to specialized divisional reports. Researches, compiles, and analyzes information and data. Develops/edits reports, orders, policies, and formats as requested by management. Works with Information Technology to resolve technical software and hardware problems. Utilizes current countywide and/or department specific software to complete assignments. SUPERVISION EXERCISED Functions as a lead worker over lower-level clerical staff, students, summer employees, and college interns by instructing, training, and distributing work. ESSENTIAL JOB FUNCTIONS Utilizes software applications prepared by Information Technology, along with database, spreadsheet, other software programs, updates information and generates regular and ad hoc reports. Conducts research for various reports assigned by professional staff. Gathers information from computer systems & web sites containing public records, reports, divisional files, etc. Performs calculations and prepares detailed spreadsheets and reports. Coordinates the fiscal tracking and purchasing components of design, engineering and construction/maintenance projects for Oakland County Parks. Communicate with regulatory agencies and local officials for project related tasks with local communities. Maintain accurate records for project/contract management processes in workday for the engineering /design department for efficient workflow and financial reporting. Processes invoices including requisition processing, purchase orders, and P-Card Verifications. CLASS TITLE: PARKS ADMINISTRATIVE SPECIALIST 2 Utilizes current countywide and/or department specific software to complete assignments. ADDITIONAL DUTIES & RESPONSIBILITIES May work with Information Technology to resolve technical problems and request special assistance. Resolves moderately complex problems such as troubleshooting computer system errors, making recommendations to enhance systems and improve reports. Assists departmental personnel in the resolution of difficulties in the operation of their particular system. Assists administration with special projects and/or events. May order and maintain office supplies. ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS Ability to communicate to accurately convey information. WORKING CONDITIONS Work is performed in a typical office environment. May participate in activities that require driving or being a passenger in an automobile or bus. IMPORTANT NOTE: The primary purpose of this job description is to set a fair and equitable salary range for this job classification. Generally, only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties and responsibilities will be assigned by the supervisor. EXPERIENCE, TRAINING, KNOWLEDGE, SKILLS & ABILITIES A. REQUIRED MINIMUM QUALIFICATIONS 1. Must be a high school graduate or have a certificate of successful completion of the General Education Development (GED) Test. 2. Have had four (4) years of increasingly responsible experience assisting professional level staff in the compilation and preparation of divisional reports or performing data input and maintenance; at least one (1) year of which included the use of specialized departmental software applications. NOTE: Course work at an accredited college, university, business, or commercial school in a related CLASS TITLE: PARKS ADMINISTRATIVE SPECIALIST 3 area may be substituted for up to three (3) years of the experience on a year-for-year basis. B. ADDITIONAL DESIRABLE QUALIFICATIONS 1. Considerable ability and skill in compiling and abstracting divisional data in preparing special and annual reports. 2. Considerable knowledge of and ability to utilize current word processing, spreadsheet, database, e-mail, and Internet software. 3. Reasonable knowledge of the methods of conducting research and evaluating collected data. 4. Reasonable ability to prepare and present effective written reports, graphs, and charts. 5. Reasonable ability to make and carry out administrative directives in accordance with divisional policies and procedures.