Senior Programmer Analyst
Software Engineering, IT
Columbus, GA, USA
Position Summary
The Senior Programmer Analyst provides technical leadership in the design, development, implementation, integration, support, and continuous improvement of enterprise applications that support Columbus Water Works operations and strategic objectives. The position independently leads complex assignments, improves the reliability and quality of business systems, and serves as a senior technical resource within Information Services.
The position develops software solutions, SQL Server databases, reports, Power BI dashboards, REST API integrations, and Microsoft 365 solutions while supporting Lawson ERP, ADP, AUS Infinity CIS, Cityworks, and other enterprise platforms. The role mentors team members, coaches business stakeholders, and works with departments to improve processes, train users, and support successful adoption of technology.
Essential Functions
Application Development and Technical Leadership
- Lead the analysis, design, development, testing, deployment, and maintenance of complex enterprise applications and integrations; evaluate solution options and recommend sustainable designs.
- Design, optimize, and maintain SQL Server databases, T-SQL queries, stored procedures, views, and data processing solutions; resolve performance and data integrity issues.
- Develop and maintain REST API integrations and data exchanges between on-premises and SaaS applications, including validation, error handling, monitoring, and recovery procedures.
- Develop Power BI dashboards, SQL reports, Crystal Reports, and operational analytics; validate business definitions and results with stakeholders.
- Develop Microsoft 365, SharePoint Online, and Power Automate solutions that improve workflows and reduce manual effort.
- Conduct code, SQL, design, and documentation reviews; maintain source code in GitHub and establish consistent development, testing, and secure coding practices in coordination with IS leadership.
Mentoring and Knowledge Transfer
- Mentor Programmer Analysts and other IS team members through coaching, paired problem solving, technical reviews, and structured knowledge transfer in application development, SQL, reporting, integrations, and troubleshooting.
- Help team members identify skill gaps, establish development goals, and apply feedback; support onboarding and cross-training to build depth of support for critical systems.
- Coach business stakeholders and department champions on requirements definition, data interpretation, process improvement, and effective use of enterprise applications.
- Create and maintain technical documentation, support runbooks, data definitions, and training materials that enable others to operate and support solutions.
Business Collaboration and Department Training
- Work directly with department leaders, subject matter experts, and end users to understand operations, document requirements, map workflows, and identify practical technology improvements.
- Facilitate requirements sessions, solution demonstrations, and user acceptance testing; clarify priorities, document decisions, and communicate technical concepts to nontechnical audiences.
- Plan and deliver training for team members and other departments, including individual coaching, group instruction, demonstrations, and job aids tailored to user responsibilities.
- Coordinate with Application Specialists and department champions to support system changes, reinforce effective use, gather feedback, and evaluate whether training and solutions meet business needs.
Project Delivery and Enterprise Support
- Lead assigned application, reporting, integration, and modernization projects; define scope, tasks, estimates, dependencies, and risks, and provide timely status updates to IS leadership and stakeholders.
- Support Lawson ERP, ADP, AUS Infinity CIS, Cityworks, and other enterprise applications; provide Tier III support and lead root cause analysis and corrective action for recurring issues.
- Troubleshoot across applications, APIs, databases, Windows and Linux servers, and networks in collaboration with Network Administrators, Application Specialists, and vendors.
- Coordinate testing, approved change implementation, rollback planning, and post-deployment validation; contribute to disaster recovery planning and testing for supported applications and data.
- Protect sensitive information through appropriate access controls, secure development, and adherence to CWW policies; perform other duties as assigned in support of Information Services.
Minimum Qualifications
- Bachelor's degree in Computer Science, Information Technology, Management Information Systems, Software Engineering, or a related field; or an equivalent combination of education and relevant experience.
- Five (5) years of progressively responsible experience in enterprise application development, database programming, reporting, or systems integration, including independent delivery of complex solutions.
- Demonstrated experience providing technical leadership on projects and mentoring or training team members, business stakeholders, or end users.
- Proficiency with Microsoft SQL Server and T-SQL, including database design, stored procedures, query optimization, data manipulation, and troubleshooting.
- Hands-on experience with REST APIs, GitHub or comparable Git-based source control, Power BI, Microsoft 365, SQL reporting, and Crystal Reports.
- Demonstrated ability to gather business requirements, work across departments, manage assigned projects, and communicate technical information clearly to technical and nontechnical audiences.
Preferred Qualifications
- Experience with Python, C#/.NET, PowerShell, SharePoint Online, and Power Automate.
- Experience supporting Lawson ERP, ADP, AUS Infinity CIS, Cityworks, and other enterprise SaaS applications in a utility or comparable operational environment.
- Working knowledge of Windows Server, Linux, cloud services, TCP/IP networking, DNS, DHCP, SSL certificates, and application security.
- Experience with project management, ITIL change management, data governance, disaster recovery, and development standards.
- Experience developing training programs, facilitating workshops, and building sustainable cross-training and knowledge transfer practices.
Core Competencies
Customer Focus; Analytical Thinking; Technical Leadership; Mentoring and Coaching; Collaboration; Adaptability; Initiative; Continuous Learning; Technical Communication; Project Ownership; Quality and Accountability.
Technical Competencies
Enterprise Applications; SQL Server and T-SQL; Reporting and Data Analytics; Power BI; REST APIs; GitHub and Source Control; Microsoft 365; Systems Integration; SaaS Platforms; Business Process Automation; Secure Coding; Solution Design and Troubleshooting.
Physical Demands
Work is primarily performed in an office environment with occasional work in server rooms and utility facilities. Must occasionally lift up to 20 pounds and travel between facilities.
Working Conditions
Primarily indoor office environment with occasional exposure to industrial utility environments. Participation in after-hours maintenance, system upgrades, and emergency support is required.
Acknowledgement
This job description describes the general nature and level of work performed. It is not intended to be an exhaustive list of all responsibilities, duties, or qualifications.
JOB ANNOUNCEMENT: 26-90
PAY GRADE: 15