What are the responsibilities and job description for the Application Support Analyst I (Utility Billing) position at City of Sunrise?
Description
NATURE OF WORK
This position provides technical and administrative expertise for the City’s utility billing operations within the Enterprise Resource Planning (ERP) system. Responsibilities include coordinating with the utility billing software vendor to resolve technical issues related to billing and collections, applying system fixes, and troubleshooting billing calculation, processing, and posting errors. The role ensures scheduled processing jobs run and complete successfully, assists with creating and generating reports to support utility billing and accounting/audit functions, and manages the accurate and timely implementation of rate changes while maintaining appropriate internal controls. Creates, modifies, and runs SQL reports, including simple queries and data extractions, to assist with troubleshooting, user support, and routine reporting needs. This position also evaluates and enhances technical, billing, and accounting procedures, working closely with Finance staff to reconcile accounts and resolve complex issues. Additionally, it supports the rollout of new utility-related software and collaborates with City staff to maintain accurate, efficient, and reliable billing processes.
This position also gathers/surveys information about business processes; aligns systems to support those processes; and ensures that required reports are completed timely, leveraging modern technologies to optimize systems performance and enhance organizational efficiencies. Also collaborates with the cybersecurity team to maintain, troubleshoot, and enhance application and technology systems, with a specific focus on implementing and maintaining cybersecurity measures. This position requires specialized cybersecurity training to support the IT department and the organization. The specific courses needed may vary based on your role within the IT department, the organization's needs, and the technologies in use.
Examples of Duties
Essential Job Functions
EDUCATION
Work Environment:
Knowledge, Skills, And Abilities
SUPERVISORY/PROFESSIONAL
HIRED ON OR AFTER 10/1/18
The description of benefits for which, an employee may be eligible have been generally summarized in this information sheet for your convenience; however, you must refer to all applicable City ordinances, collective bargaining agreements and/or plan documents for specific terms and conditions. These benefits may be affected by future changes in policy, collective bargaining, City ordinances and/or legislative actions. The City reserves the right to increase, modify, decrease or eliminate benefits at any time. No benefit is created or maintained simply based on this document, and its contents do not give rise to any contractual rights related to continuing employment or receipt of benefits between the City of Sunrise and its employees. The information contained herein supersedes any prior benefit sheet(s).
The City of Sunrise is an economic powerhouse in western Broward County encompassing more than 18 square miles. As the host of Sawgrass International Corporate Park – the largest business park in South Florida – Sunrise has its own flourishing job market and currently employs approximately 1,100 employees and numbers continue to rise.
The City takes a very active role in business development, recruitment and prides itself on creating job opportunities for its residents. There are very few communities of similar size that welcome the tens of millions of visitors that we do here in Sunrise, or that can boast the magnitude of regional assets found in our City.
Our City shines and we understand in order to shine brighter; we must continue to recognize our employees as one of our most valuable assets. The City of Sunrise takes great pride in recruiting future employees and developing and retaining current ones by offering our comprehensive compensation and benefits package throughout an employee's career.
5% Supplemental Pay:
Supervisory/Professional employees shall receive a five percent (5%) supplemental pay calculated on the employee’s base rate of pay.
City-Paid Medical Benefits
Based on successful completion of full-time, continuous service with the City, employee shall receive the following:
Years of Creditable Service Longevity Benefit*
10 Years 2.5%
15 Years 2.5%
20 Years 5.0%
Employees receive the following City-paid holidays:
Annual leave may be taken as earned. Maximum accumulation each fiscal year is 360 hours. At time of resignation or retirement, employee is paid for all annual leave accrued at their current rate of pay. Annual leave is accrued based on continuous, full-time service with the City, as follows:
Completed Months of Service Total Hours/Days Accrued Annually
Up to and including first 60 months 128 hours/16 Days
Greater than 60 months through 120 months 168 hours/21 Days
Greater than 120 months through 204 months 208 hours/26 Days
Greater than 204 months 248 hours/31 Days
Annual Leave Cash Out
Employee can opt to receive a non-pensionable cash payment twice per year for up to forty (40) hours of annual leave, provided accrued annual leave bank does not fall below eighty (80) hours.
Floating Holidays
Upon completion of (26) weeks of full-time employment with the City, employee shall be entitled to utilize up to five (5) floating holidays per fiscal year. Floating holidays shall not carry over to the next fiscal year.
Perfect Attendance
For every six (6) months period (April 1 - September 30) and (October 1 - March 31) in which, no sick or unpaid leave is utilized, an employee shall receive ten (10) hours of annual leave credited. Employees who qualify for a consecutive Perfect Attendance benefit shall receive (14) hours of annual leave credited for each consecutive earning period.
Sick Leave
Each employee earns (96) hours (12 days) of sick leave annually with no waiting period for use and maximum accrual of 1,440 hours. Upon separation of City employment due to resignation, employee shall receive payment of all accrued sick leave at a rate of twenty- five percent (25%) of the employee’s current rate of pay at time of resignation. Upon separation of employment due to retirement, employee shall receive payment of all accrued sick leave at a rate of fifty percent (50%) of the employee’s current rate of pay at the time of retirement.
Sick Leave Conversion
After completion of one (1) year of continuous, full-time employment with the City, an employee may convert their unused portion of their first six (6) days (maximum of forty- eight (48) hours) of accrued sick leave into annual leave. Conversions are subject to the following: A minimum of 96 unused sick leave hours accrued prior to hours being converted, total eligible sick leave hours to be converted shall be reduced hour-for-hour by any sick leave hours utilized during the eligible benefit period, and conversion subject to annual leave accrual cap.
Bereavement Leave
Qualifying City-paid Bereavement Leave as follows:
After (2) two years of continuous full-time employment:
We Florida Financial Bank & Credit Union – 8890 NW 44th Street, Sunrise, FL 33351
Optional Voluntary Benefits (paid By The Employee)
Please describe your highest level of education completed. PROOF OF THE HIGHEST LEVEL OF COMPLETED EDUCATION MUST BE SUBMITTED AS AN ATTACHMENT WITH APPLICATION. (Applications without attached proof of education will not be processed for consideration.)
Please describe how many years of experience you possess in the development, implementation, training, and support of an Enterprise Resource Planning (ERP) system and mission-critical applications.
Do you have a valid Driver's License?
If yes, please provide Driver's License number and Date of Issue:
05
Please list any certifications you possess that are relevant to the Application Support Analyst I role you are applying to.
NATURE OF WORK
This position provides technical and administrative expertise for the City’s utility billing operations within the Enterprise Resource Planning (ERP) system. Responsibilities include coordinating with the utility billing software vendor to resolve technical issues related to billing and collections, applying system fixes, and troubleshooting billing calculation, processing, and posting errors. The role ensures scheduled processing jobs run and complete successfully, assists with creating and generating reports to support utility billing and accounting/audit functions, and manages the accurate and timely implementation of rate changes while maintaining appropriate internal controls. Creates, modifies, and runs SQL reports, including simple queries and data extractions, to assist with troubleshooting, user support, and routine reporting needs. This position also evaluates and enhances technical, billing, and accounting procedures, working closely with Finance staff to reconcile accounts and resolve complex issues. Additionally, it supports the rollout of new utility-related software and collaborates with City staff to maintain accurate, efficient, and reliable billing processes.
This position also gathers/surveys information about business processes; aligns systems to support those processes; and ensures that required reports are completed timely, leveraging modern technologies to optimize systems performance and enhance organizational efficiencies. Also collaborates with the cybersecurity team to maintain, troubleshoot, and enhance application and technology systems, with a specific focus on implementing and maintaining cybersecurity measures. This position requires specialized cybersecurity training to support the IT department and the organization. The specific courses needed may vary based on your role within the IT department, the organization's needs, and the technologies in use.
Examples of Duties
Essential Job Functions
- Communicates directly with utility billing software vendor to resolve technical problems, implement system changes and programming, coordinate program and data conversions.
- Manages and maintains third-party software integrations, ensuring seamless interoperability with City ERP and mission-critical applications.
- Analyzes billing and bill calculation problems; identifies causes; resolve issues; and reviews adequacy of controls and solutions to complex administrative, accounting, or technical problems.
- Reviews and assesses departmental systems/application project needs, requests and requirements; determines scope of project and suitability; reviews and analyzes user needs; responds to application requests and schedules implementations as needed; and translates user requirements into effective program designs and configurations.
- Develops and manages complex reports and serves as reporting subject matter expert for City-wide end users.
- Leads new ERP and application system implementations; gathers comprehensive surveys information and business processes; prioritizes tasks; troubleshoots, analyzes, and implements solutions to problems with mission-critical applications and related systems, both hardware and software related; offers recommendations for improvements where indicated.
- Creates/enhances/optimizes workflows and sets up configurations to better align with each business unit’s processes.
- Assists in the strategic planning, implementation, and installation of hardware and software systems as required.
- Maintains and facilitates communication between the Information Technology (IT) Department and user departments.
- Coordinates and conducts training in system applications.
- Maintains meticulous documentation of projects, manuals, and training records used throughout the life cycle of the project.
- Applies knowledge of computer systems to develop applications as technology advances and changes.
- Reviews, analyzes, and tests software packages and provides recommendations.
- Develops backup and archival procedures, power-on/power-off procedures, system security administration, computer device assignment and management.
- Monitor city-wide systems for cybersecurity threats and vulnerabilities, taking proactive measures to address them.
- Assist in the implementation of cybersecurity policies and procedures, ensuring compliance and adherence.
- Performs additional duties as required to support IT operations and organizational objectives.
EDUCATION
- Graduation from an accredited college or university with a Bachelor’s degree in computer information systems or a closely related field OR
- Extensive qualifying professional experience as described, may be substituted for the required college education.
- PROOF OF HIGHEST LEVEL OF COMPLETED EDUCATION MUST BE SUBMITTED AS AN ATTACHMENT WITH APPLICATION. (Applications without attached proof of education will not be processed for consideration.)
- Considerable years of qualifying professional experience troubleshooting and operation of computerized utility billing systems and experience with various computer applications and software, including reporting functions, and support of an Enterprise Resource Planning (ERP) system and mission-critical applications.
- Certifications in the areas of SharePoint, database management, reporting, and Cybersecurity, or equivalent certifications depending on the specific job description, are preferred.
- Proven experience with Tyler Munis a plus
- Possession of a valid Driver’s License with an acceptable driving record.
- Must obtain a valid Florida driver’s license prior to hire.
- Cybersecurity certifications must be obtained within the first eighteen (18) months from appointment.
Work Environment:
- Work is performed primarily in a standard office environment and data center rooms and closets with some travel to different sites; incumbents may be required to work extended hours including but not limited to evenings, weekends and holidays.
- Must have the use of sensory skills in order to effectively communicate and interact with other employees and the public through personal contact, the use of the telephone and/or other City-issued technology devices.
- Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach and twist under desks and around furniture; to lift, carry, push, and/or pull moderate to heavy amounts of weight up to 50 lbs.; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information. Occasional climbing on ladder or stool to reach or mount equipment.
Knowledge, Skills, And Abilities
- Knowledge of ERP components, connectivity, security, and diverse operating systems with a deep understanding of technology trends.
- Knowledge and proficiency in reporting technologies such as SQL Reporting Services and/or Crystal Reports with a solid foundation in SQL databases.
- Knowledge of system development methodologies and MS SharePoint platform.
- Knowledge of multiple programming languages, including Net Framework.
- Skill in the use of the keyboard, printers, personal computers, and related equipment.
- Skill in the installation and operation of personal computers, related peripherals used in support of various City-wide software applications.
- Ability to strategize, plan, organize, and assist in the development of training programs in computer systems technologies.
- Ability to communicate complex technical concepts to technical and non-technical staff effectively and persuasively, both verbally and in writing.
- Ability to effectively manage and supervise projects and oversee other employees.
- Ability to manage competing priorities and varied responsibilities in a fast-paced environment.
- Ability to work efficiently and effectively to develop win-win solutions.
- Ability to evaluate the impact of alternative courses of action and navigate new or unprecedented circumstances effectively.
- Ability to establish and maintain professional working relationships with City officials, stakeholders, management, team members, general employees, vendors, and the general public.
- Knowledge of cybersecurity principles and best practices, with the ability to apply them to system support activities.
- Familiarity with cybersecurity tools and technologies, such as antivirus software and intrusion detection systems.
SUPERVISORY/PROFESSIONAL
HIRED ON OR AFTER 10/1/18
The description of benefits for which, an employee may be eligible have been generally summarized in this information sheet for your convenience; however, you must refer to all applicable City ordinances, collective bargaining agreements and/or plan documents for specific terms and conditions. These benefits may be affected by future changes in policy, collective bargaining, City ordinances and/or legislative actions. The City reserves the right to increase, modify, decrease or eliminate benefits at any time. No benefit is created or maintained simply based on this document, and its contents do not give rise to any contractual rights related to continuing employment or receipt of benefits between the City of Sunrise and its employees. The information contained herein supersedes any prior benefit sheet(s).
The City of Sunrise is an economic powerhouse in western Broward County encompassing more than 18 square miles. As the host of Sawgrass International Corporate Park – the largest business park in South Florida – Sunrise has its own flourishing job market and currently employs approximately 1,100 employees and numbers continue to rise.
The City takes a very active role in business development, recruitment and prides itself on creating job opportunities for its residents. There are very few communities of similar size that welcome the tens of millions of visitors that we do here in Sunrise, or that can boast the magnitude of regional assets found in our City.
Our City shines and we understand in order to shine brighter; we must continue to recognize our employees as one of our most valuable assets. The City of Sunrise takes great pride in recruiting future employees and developing and retaining current ones by offering our comprehensive compensation and benefits package throughout an employee's career.
5% Supplemental Pay:
Supervisory/Professional employees shall receive a five percent (5%) supplemental pay calculated on the employee’s base rate of pay.
City-Paid Medical Benefits
- Group Health Insurance: The City pays for 100% of the cost for single coverage for full-time employees and 66.66% of cost for Dependent/Family Coverage. Upon retirement and separation from City employment, employee receives a monthly stipend of $350 per month, applicable toward retiree health coverage.
- Life Insurance: $50,000
- Accidental Death & Dismemberment (AD&D): $50,000
- Eye Care Reimbursement – Up to $250 every two (2) fiscal years (Employee only)
- EKG/Stress Test – Up to $150 reimbursement per fiscal year (Employee only)
- Physical Examination – Up to $250 reimbursement per fiscal year (Employee only)
- Employee Assistance Program (EAP) through Cigna Behavioral
- Employee Contribution = 8%
- Vesting = 10 Years
- Average Final Compensation (AFC) = 2.5% of pensionable earnings for each year of creditable service
- Maximum Benefit = 80% of AFC, not to exceed $80,000.
- Normal Retirement = Age 62 and ten (10) years of creditable service.
- Early Retirement = Age 57 and ten (10) years of creditable service, 3% annual reduction for each year prior to normal retirement age.
- 13th check based on monthly retirement, payable if the pension plan funding status is equal to or greater than 100%. Paid in December each year following retirement.
- Deferred Retirement Option Plan (DROP) = 4 years/48 months maximum.
- DROP Interest Rate = 4%, compounded annually.
Based on successful completion of full-time, continuous service with the City, employee shall receive the following:
Years of Creditable Service Longevity Benefit*
10 Years 2.5%
15 Years 2.5%
20 Years 5.0%
- Longevity Benefit calculated on employee’s base rate of pay
Employees receive the following City-paid holidays:
- New Year’s Day
- Martin Luther King Day
- Memorial Day
- Juneteenth
- 4th of July, Independence Day
- Labor Day
- Veterans’ Day
- Thanksgiving Day
- Friday after Thanksgiving
- Christmas Day
Annual leave may be taken as earned. Maximum accumulation each fiscal year is 360 hours. At time of resignation or retirement, employee is paid for all annual leave accrued at their current rate of pay. Annual leave is accrued based on continuous, full-time service with the City, as follows:
Completed Months of Service Total Hours/Days Accrued Annually
Up to and including first 60 months 128 hours/16 Days
Greater than 60 months through 120 months 168 hours/21 Days
Greater than 120 months through 204 months 208 hours/26 Days
Greater than 204 months 248 hours/31 Days
Annual Leave Cash Out
Employee can opt to receive a non-pensionable cash payment twice per year for up to forty (40) hours of annual leave, provided accrued annual leave bank does not fall below eighty (80) hours.
Floating Holidays
Upon completion of (26) weeks of full-time employment with the City, employee shall be entitled to utilize up to five (5) floating holidays per fiscal year. Floating holidays shall not carry over to the next fiscal year.
Perfect Attendance
For every six (6) months period (April 1 - September 30) and (October 1 - March 31) in which, no sick or unpaid leave is utilized, an employee shall receive ten (10) hours of annual leave credited. Employees who qualify for a consecutive Perfect Attendance benefit shall receive (14) hours of annual leave credited for each consecutive earning period.
Sick Leave
Each employee earns (96) hours (12 days) of sick leave annually with no waiting period for use and maximum accrual of 1,440 hours. Upon separation of City employment due to resignation, employee shall receive payment of all accrued sick leave at a rate of twenty- five percent (25%) of the employee’s current rate of pay at time of resignation. Upon separation of employment due to retirement, employee shall receive payment of all accrued sick leave at a rate of fifty percent (50%) of the employee’s current rate of pay at the time of retirement.
Sick Leave Conversion
After completion of one (1) year of continuous, full-time employment with the City, an employee may convert their unused portion of their first six (6) days (maximum of forty- eight (48) hours) of accrued sick leave into annual leave. Conversions are subject to the following: A minimum of 96 unused sick leave hours accrued prior to hours being converted, total eligible sick leave hours to be converted shall be reduced hour-for-hour by any sick leave hours utilized during the eligible benefit period, and conversion subject to annual leave accrual cap.
Bereavement Leave
Qualifying City-paid Bereavement Leave as follows:
- In State = Up to 3 Days
- Out of State = Up to 5 Days
After (2) two years of continuous full-time employment:
- 100% reimbursement for a grade of A or B
- 50% reimbursement for a grade of C
- $500 books/lab reimbursement per semester
We Florida Financial Bank & Credit Union – 8890 NW 44th Street, Sunrise, FL 33351
Optional Voluntary Benefits (paid By The Employee)
- Single or Family Dental Insurance
- Single or Family Vision Insurance
- Accident Advantage
- Life Insurance
- Accidental Death & Dismemberment Insurance
- Long Term Disability Insurance
- Long Term Care Insurance
- Short Term Disability Insurance
- Critical Care Protection
- Cancer Protection Assurance
- Mission Square Retirement Programs
- 457 Deferred Compensation Plan
- 401(a) Governmental Purchase Plan: Newly hired
Please describe your highest level of education completed. PROOF OF THE HIGHEST LEVEL OF COMPLETED EDUCATION MUST BE SUBMITTED AS AN ATTACHMENT WITH APPLICATION. (Applications without attached proof of education will not be processed for consideration.)
- No High School/GED
- High School/GED
- Some College
- Associate's Degree
- Bachelor's Degree
- Master's Degree
- Doctoral Degree
Please describe how many years of experience you possess in the development, implementation, training, and support of an Enterprise Resource Planning (ERP) system and mission-critical applications.
- No Experience
- Inexperienced (Less than 6 months)
- Basic (6 months – 1 year)
- Reasonable (1 – 3 years)
- Considerable (4 – 6 years)
- Extensive (7 – 9 years)
- Broad (10 years)
Do you have a valid Driver's License?
- Yes
- No
If yes, please provide Driver's License number and Date of Issue:
05
Please list any certifications you possess that are relevant to the Application Support Analyst I role you are applying to.
- Required Question
Salary : $350