Enterprise Application Specialist

Ready to lead innovation in local government? The City of Batavia is looking for our first Enterprise Application Specialist to transform how we deliver services to the community You will manage and optimize key municipal systems and work with teams across the city to streamline processes and boost efficiency.

Position Summary

The City of Batavia, IL is seeking a knowledgeable and service-oriented Enterprise Application Specialist to support the delivery of essential services through robust and efficient enterprise systems. This role plays a key part in improving the quality of life for residents by ensuring our software applications operate reliably and evolve with our growing municipal needs. The Enterprise Application Specialist will be responsible for the administration, support, and continuous improvement of municipal enterprise applications, such as financial, asset management, land management, utilities, and customer service platforms.

This role will work closely with departmental stakeholders to align business needs with technology solutions that drive operational excellence and transparency in government services. This may include but is not limited to working with software application vendors and city staff on deployments, system updates, creating interfaces and reports, database management, assisting with application support, maintaining documentation, and providing user training. This position will need to analyze existing software systems to assess alignment with business requirements.

This position is a full-time on-site position reporting to the City of Batavia's City Hall building. A typical work schedule for this position is Monday to Friday 8:00AM-5:00PM. Position includes on-call availability as needed, nights and weekends on occasion.

Hiring Salary Range: $82,673 - $97,078 DOQ

Full salary range: $82,673 - $113,992

This position is classified as Pay Grade 14 under the City of Batavia's Wage and Salary Ordinance and is non-exempt, with excellent benefits.

The City of Batavia offers a competitive benefit package that includes:

• Paid Time Off (PTO): Generous vacation days, sick leave, and personal day.
• Comprehensive Health Insurance: BCBSIL PPO & HMO Medical, dental, and vision coverage.
• Life Insurance equal to your annual salary paid by the City.
• IMRF pension with an employer contribution.
• Tuition Reimbursement: Support for further education.
• Milestone Reward Program
• Annual Employee Awards and Appreciation Event.
• Annual Employee Picnic
• Annual Holiday Party
• Wellness Events
• Inclusive and Diverse Workplace: Commitment to diversity, equity, and inclusion.
• And much more

For more information check out the City of Batavia Human Resources site under the Employee Benefits Summary tab.

Essential Duties & Responsibilities

Provide application support, administration, and ensure application functionality aligns with business processes.

Engage with decision-makers, system owners, and end-users to define business, financial, and operational requirements, set system goals, and troubleshoot issues.

Analyze existing software systems to assess performance, scalability, and alignment with business requirements. Prepare and present recommendations and alternatives to address current and potential issues in application systems.

Collaborate in the planning, design, development, and deployment of new applications, as well as enhancements to existing systems. Gather and document functional and technical requirements and develop detailed specifications for the design and implementation of software applications such as ERP or other department-specific products.

Work closely with software vendors and City staff for application installation, configuration, and upgrades. Coordinate and conduct thorough testing, including end-user reviews, for new and modified systems, providing post-implementation support.

Apply programming skills to assist with implementation, data analysis, system integration/interfaces, maintenance, and reporting within the City's application portfolio.

Manage application user account administration to maintain system security and compliance with organizational policies and standards.

Deliver training and orientation to end-users on all new and updated systems.

Perform additional duties as assigned.

Minimum Qualifications - Education & Experience

Bachelor's degree in computer science or a closely related field. Coursework in business administration, management and finance is not required but preferred. Minimum of 5 years related work experience. An equivalent combination of education and experience may be accepted.

Minimum Qualifications - Knowledge, Skills & Abilities
Knowledge of:

Strong knowledge of relational database operation and data architecture using Microsoft SQL Server, including the ability to create multi-level SQL queries for data analysis and reporting, design and create relational database schemas, and creation of database objects including tables, indexes, views, and stored procedures.

Proficient in using the principles, procedures, and standards for application integrations and for data extraction, transformation, and load (ETL). Experience developing integrations between business applications using API's, standalone programs, and/or scripts for both real-time and scheduled jobs.

Well-versed in principles of application security, Web site security, mobile application security, certificate management, and application vulnerability mitigation.

Strong knowledge of Windows-based software including Microsoft 365, SQL Server Management Studio, and Visual Studio. Experience with Microsoft Copilot Studio a plus.

Skills in:

Excellent written documentation skills (MS-Word, Excel, PowerPoint, and Visio) producing detailed requirements, architecture, and maintenance documents.

Excellent written and oral communication skills, including strong attention to detail, while communicating ideas clearly and effectively in business-friendly and user-friendly language across all organizational levels.

Excellent interpersonal skills including working in a team-oriented, collaborative environment.

Excellent project management and organizational skills.

Highly self-motivated and self-directed.

Strong analytical skills with a proactive approach to troubleshooting and resolving issues.

Exceptional customer service orientation.

Strong desire for continued educational opportunities.

Technical experience with programming tools:

• Microsoft SQL Server T-SQL
• Scripting languages such as Python, VBScript, and DOS batch files
• Application programming using Visual Studio and .NET Framework
• Development experience using Microsoft SharePoint

Ability to:

Demonstrated ability to evaluate projects or goals, considering available resources and technologies, time constraints, usability for City staff or the public, and long-term maintainability. This may include conducting and directing research into IT issues and products, as required.

Plan and coordinate testing changes, upgrades, and new services, ensuring systems will operate correctly in current and future environments.

Perform general mathematical calculations for tasks such as developing numerical reports from systems or creating business cases involving cost analysis.

Proven analytical, evaluative, and creative problem-solving abilities.

Effectively organize, prioritize, manage, and execute competing tasks/priorities in a fast-paced environment.

Special Requirements/Qualifications

Possession of a valid Illinois driver's license.

Position includes on-call availability as needed, nights and weekends on occasion.

Physical Demands/Working Conditions

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Work is performed mostly in office settings. Hand-eye coordination is necessary to operate computers and various pieces of office equipment. Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, the ability to adjust focus, and prolonged visual concentration.

While performing the duties of this job, the employee is frequently required to talk or hear; sit; use hands and fingers to handle, feel, or operate objects, tools, or controls; and reach with hands and arms. The employee is occasionally required to stand, walk, climb, balance, stoop, kneel, bend, and crouch while working in various City Buildings. The employee must frequently lift and/or move up to 25 pounds.

While performing the duties of this job, the employee is exposed to moderate noise levels. The position may also require you to temporarily work underneath desks and workstations. Occasional outdoor trips are necessary. The position has the potential to occasionally be exposed to dust.

The City of Batavia is committed to compliance with the American Disabilities Act and is an Equal Opportunity Employer. Diversity and inclusion are critical to our success.

---