Technical Functional Analyst

APPLY ONLINE AT LONGMONTCOLORADO.GOV/JOBS

20250126 Technical Functional Analyst - Strategic Integration

CLOSING DATE: April 18, 2025

Department: Strategic Integration

Division: Technology

Hiring Range: $9,108- $10,120/month

Monday – Friday, 8:00am – 5:00pm Remote and schedule flexibility with supervisor approval.

Regular Full-time with Benefits

Benefits include: Medical, Dental, Vision, Flex Spending, Defined Benefit Pension Plan, 401(a) Money Purchase Plan, Life & Survivor, Term Life & AD&D, Long Term Disability, Bereavement, Jury & Witness Duty, FMLA, Military Leave, Parental and Caregiver Leave, Sick, Vacation at start of employment, Holiday pay, EAP, Tuition Assistance.

Other benefits: Optional, employee elected, voluntary benefits are available.

Definition:

Provide technical and business expertise for the development, enhancement, configuration and support of the Utility systems. Implements and supports asset management system, integrations and mobile data programs, including installation, configuration, testing, monitoring and troubleshooting. Assist in the implementation and management of new systems, including a Meter Data Management System, a Customer Information System and a Customer Self-Serve Portal. Assist in integrating new systems to the existing Automated Metering Infrastructure and asset management systems. The position is responsible for the application security process, user set-up, role and privilege definition, security permissions and overseeing installation and upgrades of software packages. Must be able to analyze complex processes, work in cooperation with subject matter experts, identify areas for improvement and recommend solutions. Software coding skills are vital to the success of this position.

In addition, perform a wide variety of technical work in the analysis, design, programming, testing, installation, integration, and maintenance of existing legacy applications as well as ad hoc programming requests to meet organizational needs.

Principal Duties:

• Provide hands-on support (applying patches. routine maintenance. and upgrades) and troubleshooting (error tracking and resolution) of a variety of business applications to preserve and continuously improve the stability and availability of these systems. This requires the understanding of information technology infrastructure components like databases, networks, workstations, servers, firewalls, cloud computing and data centers in order to be able to collaborate with IT system administrators to keep normal levels of operations for these programs.

• Coordinate with software vendors on upgrades, troubleshooting and system diagnostics.

• Install applications and firmware. Perform basic system configuration changes. Manage user set-up, roles and privileges.

• Prepare program and procedural documentation, training notes, and help text. Conduct training of users on systems.

• Assist mapping staff with GIS/CMMS integration issues and installs.

• Provide department staff with data analysis products using SQL Server Data Tools, SQL Server Management Studio and Excel validation and analysis tools. Also manage email subscriptions for user data needs.

• Works with users at all levels to analyze work processes and design requirements necessary to program new systems or update systems including systems analysis, design, testing and implementation.

• Develop reports, and queries in a variety of formats using SQL Server Reporting Services and other report/query generation. Publish reports and integrate with department applications using existing user's groups and permissions structures. Develop and maintain report subscriptions for automated report delivery to users.

• Assist staff in the development of key performance indicators for dashboards, workflows, and workspace configuration for systems.

• Learns a variety of new software and enhancements and maintains current knowledge of trends, developments and products in the software field for the purpose of providing technical support to users, developing City applications, and informing department staff and management of trends to assist in decision making on hardware and software purchases and software development.

Working Environment:

Problem-solving skills, frequent reading, reasoning, customer contact, multiple concurrent tasks, and constant interruptions. Requires the ability to communicate effectively in English both orally and in writing. Work must be done while working closely with others including both co-workers and users. Frequent light lifting and carrying (up to 30 pounds.), pulling, pushing, reaching, walking, standing, and bending/stooping. Occasional sitting, climbing, twisting, kneeling, squatting, and driving. Periodic travel to other City departments.

Qualifications:

Any combination of education and experience equivalent to the completion of a bachelor’s degree from an accredited college or university with major coursework in computer science or a closely related field and three or more years of experience with SQL databases and programming. Preference will be given to experience with ESRI Geographic Information Systems and electric utility systems. Special Qualifications: Possession of a valid Colorado Driver’s License.

We’re committed to building a team that reflects the diversity of the communities we serve. The City may consider an equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications, and encourages all candidates to apply and help us achieve our goal of creating an inclusive and equitable workplace.

Selection

The selection process will include complete job description review, personal interview, computer testing, background investigation, criminal background check, and substance screening.

DEADLINE: 11:59 P.M. ON April 18, 2025

Online application (required) must be successfully submitted by 11:59 p.m. on April 18, 2025. The online application process is available for this position on our website at www.longmontcolorado.gov/jobs. Resumes will be accepted in lieu of the full City Application; however, they must be submitted via the City application site for consideration. For more information, call (303) 651-8609.

The City of Longmont is an equal opportunity employer. The City affirms its commitment to diversity and to complying with all applicable federal, state, and local laws regarding nondiscrimination in employment. The City will not discriminate against any person in recruiting, examining, appointing, hiring, training, placement, termination, layoffs, recall, transfer, leave of absence, promoting, compensating, retaining, disciplining, or any other personnel action on the basis of age, race, color, creed, religion, sex, sexual orientation, gender identity or expression, national origin, ancestry, genetic information, marital status, veteran status, status with regard to public assistance, physical or mental disability, or any other characteristic protected by federal, state, or local law, except when any of these categories constitutes a bona fide occupational qualification (i.e., an actual qualification for performing a job). If you need special assistance in the selection process, please contact the Human Resources Department in advance to make arrangements.

AN EQUAL OPPORTUNITY EMPLOYER

ALL CITY OF LONGMONT FACILITIES ARE SMOKE FREE

Job Type: Full-time

Pay: $9,108.00 - $10,120.00 per month

Benefits:

• AD&D insurance
• Caregiver leave
• Dental insurance
• Family leave
• Health insurance
• Life insurance
• Paid holidays
• Paid sick time
• Paid time off
• Parental leave
• Retirement plan
• Vision insurance

Schedule:

• 8 hour shift

Work Location: In person

Salary : $9,108 - $10,120