Senior Programmer Analyst

Cwwga; Columbus (GA); Hybrid; USD 77,000 - 97,000; Full time

Job summary

Columbus Water Works seeks a Senior Programmer Analyst to provide technical leadership in enterprise application design, development, and integration. You will lead complex projects, optimize databases, and deliver robust data solutions across on-premises and SaaS platforms.

The role develops software solutions, dashboards, and APIs while mentoring team members, collaborating with stakeholders, and driving adoption of technology across IS. Strong focus on security and reliable operations.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, MIS, Software Engineering, or related field.
• Five (5) years of enterprise application development, database programming, reporting, or systems integration.
• Proficiency with Microsoft SQL Server and T-SQL, including database design and troubleshooting.
• Hands-on experience with REST APIs, GitHub, Power BI, Microsoft 365, SQL reporting, and Crystal Reports.

Responsibilities

• Lead the analysis, design, development, testing, deployment, and maintenance of complex enterprise applications; evaluate options and design sustainable solutions.
• Design, optimize, and maintain SQL Server databases, including stored procedures and data processing; resolve performance issues.
• Develop REST API integrations and data exchanges between on-premises and SaaS applications with proper validation and monitoring.
• Develop Power BI dashboards and SQL/Crystal Reports; validate definitions with stakeholders.
• Create Microsoft 365, SharePoint Online, and Power Automate solutions to improve workflows and reduce manual effort.
• Conduct code, SQL, design, and documentation reviews; maintain source code in GitHub and ensure secure coding practices.

Skills

SQL Server

T-SQL

REST APIs

Power BI

GitHub

Microsoft 365

Crystal Reports

Python

C#/.NET

Power Automate

Education

Bachelor's degree in Computer Science, Information Technology, MIS, Software Engineering, or related field

Tools

GitHub

SQL Server

Crystal Reports

Power BI

SharePoint Online

Power Automate

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Professional Columbus, GA, US

Salary Range: $77,241.82 To $96,553.20 Annually

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.

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.