IT Enterprise Application Specialist

This role supports municipal utility operations by managing and securing  the enterprise solutions application and related systems, integrating applications, and developing automated, data-driven workflows.

Essential Duties and Responsibilities Include the Following:

Key Responsibilities

Data Analytics: Manage the secure transport of application and system data. Design and implement robust methods for data collection, organization, and analysis, specifically for the purpose of preparing clean, structured data to drive process automation and workflow development.

Database Administration (DBA): Manage and maintain the municipal utility databases (primarily SQL), ensuring optimal performance, integrity, and security. This role encompasses all technical and operational duties necessary to guarantee data accuracy, system availability, and functionality, including data moving between applications.

Outside Application Support (Provided Service): Serve as the technical liaison between utility users and external vendors, ensuring a comprehensive understanding of the functional use of each software and its purpose, the data-retention, data-collection, and data-usage related to each third-party software, systems, and service. A special focus will be placed on key systems such as GIS, metering data collections and billing platforms.

Inside Application Support: Design, implement, and manage digital systems essential for developing and deploying new workflow automation solutions. Success in this role requires expertise in process mapping, effective collaboration with stakeholders, platform proficiency (e.g., Flowfinity), and strong communication to deliver highly efficient, data-driven workflows.

Industrial IoT: Basic competency in the full lifecycle of connected devices and systems, from smart sensors to industrial controls. Logic to reading \ understanding programming language (Python, C++), security best practices, and ensuring systems communicate securely and efficiently.

Configuration & Customization: Making approved changes, configuring business rules, and creating scripts (e.g., UI policies, client scripts).

Integration: Designing and implementing solutions to connect different enterprise systems.

Performance Monitoring: Tracking system health, generating reports, and optimizing performance.

Security & Compliance: Managing user access, implementing security protocols, and ensuring data governance.

Automation: Developing process automation to improve efficiency.

Workflow development: Analyze new and existing processes to identify inefficiencies; collaborate with departments to understand their needs; and develop, document, and implement new or improved workflows to enhance operational efficiency and consistency.

Workflow maintenance: Regularly monitor and update workflows to ensure they continue to function correctly and to adapt them to changing business needs.

Information Resource: Obtain expertise on various systems utilized (current/and future) by the utility for process control.

General Stewardship: Integrate, innovate, improve and support new and existing systems for managing data/information from all functions within the utility.

The position receives guidance and direction from two key leaders: the LMU Utility Director, who oversees work scope, operational priorities and workflow, and the IT Manager, who provides technical supervision and system integrity, both of whom report to the Mayor.

Perform other related duties as assigned

Requirements, Skills, and Qualifications: To perform this job successfully, an individual must be able to perform each essential responsibility satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

A minimum of 5 years hands-on experience in database administration, data analytics, or systems/application with a strong focus on SQL Proficiency: Expert knowledge of Structured Query Language (SQL) is fundamental for querying, manipulating, and managing databases.

Database Management Systems (DBMS): A minimum of 3 years’ experience with popular SQL DBMS like Microsoft SQL Server, Oracle, MySQL, PostgreSQL, or other relevant platforms. This includes understanding their architecture, administration tools, and features.

Database Design and Theory: Knowledge of relational database design principles, data modeling, normalization, and indexing.

Backup and Recovery: Expertise in implementing and managing database backup and recovery strategies to ensure data integrity and availability.

Performance Tuning and Optimization: Ability to identify and resolve performance bottlenecks, optimize queries, and configure database settings for optimal performance.

Security: Understanding of database security best practices, access control, and data encryption.

Operating Systems: Familiarity with operating systems commonly used for database servers (e.g., Windows Server, Linux).

Scripting Languages: Knowledge of scripting languages like PowerShell or Python for automation and administrative tasks.

Web Design: proven experience with HTML, CSS and Javascript

Technical Communication: Ability to effectively blend strong writing, technical knowledge, and interpersonal skills to translate complex, technical information into clear, concise, and user-friendly content. This content is vital for documentation, training materials, and audit requirements

Must have excellent communication, documentation and collaboration skills. 

Previous experience working in regulated or public-sector environments (municipal utilities, government, or infrastructure) is high preferred due to data governance, security, and compliance requirements.

Physical Requirements: 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.

Ability to sit for extended periods while working at a computer workstations.

Stand, walk, bend, stoop, crouch and reach in an office or utility environment.

Frequent use of hands and fingers for typing, data entry, and operating standard office equipment.

Ability to communicate effectively, including speaking, hearing, and visual acuity sufficient to read screens, reports, and technical documentation.

Ability to lift and carry equipment up to 25 pounds unassisted and occasionally lift/or move up to 50 pounds with assistance.

This is a Full Time position with an Employment Contract which includes a full benefit package including employer paid Medical, Vision, Dental, Employee Life, Short Term Disability; participation in the Indiana Public Employee Retirement Fund Pension; 457(b) plan; 13 paid Holidays; and paid time off. 

The City of Lawrenceburg is an Equal Opportunity Employer and ADA Compliant Employer.  The City of Lawrenceburg does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, skills, ability and merit.