IT Enterprise Application Specialist

City of Lawrenceburg • Lawrenceburg, IN

6h

About The Position

Application deadline is 4:00pm Friday, March 13, 2026. 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. 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

• A minimum of 5 years hands-on experience in database administration, data analytics, or systems/application with a strong focus on SQL
• Expert knowledge of Structured Query Language (SQL) is fundamental for querying, manipulating, and managing databases.
• 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.
• Knowledge of relational database design principles, data modeling, normalization, and indexing.
• Expertise in implementing and managing database backup and recovery strategies to ensure data integrity and availability.
• Ability to identify and resolve performance bottlenecks, optimize queries, and configure database settings for optimal performance.
• Understanding of database security best practices, access control, and data encryption.
• Familiarity with operating systems commonly used for database servers (e.g., Windows Server, Linux).
• Knowledge of scripting languages like PowerShell or Python for automation and administrative tasks.
• Proven experience with HTML, CSS and Javascript
• Ability to effectively blend strong writing, technical knowledge, and interpersonal skills to translate complex, technical information into clear, concise, and user-friendly content.
• Must have excellent communication, documentation and collaboration skills.
• 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.

Nice To Haves

• 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.

Responsibilities

• 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.
• Manage and maintain the municipal utility databases (primarily SQL), ensuring optimal performance, integrity, and security.
• Serve as the technical liaison between utility users and external vendors
• Design, implement, and manage digital systems essential for developing and deploying new workflow automation solutions.
• Integrate, innovate, improve and support new and existing systems for managing data/information from all functions within the utility.
• 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
• Obtain expertise on various systems utilized (current/and future) by the utility for process control.

Benefits

• 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
• paid time off

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed