Lead Enterprise Apps Engineer

Columbus Water Works; Columbus (GA); On-site; USD 77,000 - 97,000; Full time

Job summary

Columbus Water Works in Columbus, GA is seeking a Senior Programmer Analyst to lead the design, development, and integration of enterprise applications supporting operations and strategic goals.

The role develops SQL Server databases, Power BI dashboards, REST API integrations, and Microsoft 365 solutions while supporting Lawson ERP, ADP, AUS Infinity CIS, Cityworks, and other platforms. Mentoring and collaboration with stakeholders are essential.

Qualifications

• Bachelor's degree in Computer Science or related field.
• Five (5) years of enterprise application development or systems integration experience.
• Experience leading projects and mentoring team members.
• Proficiency with Microsoft SQL Server and T-SQL.
• Hands-on REST APIs, GitHub, Power BI, and Crystal Reports.
• Ability to gather requirements and communicate across departments.

Responsibilities

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

Skills

SQL Server

T-SQL

REST APIs

Power BI

GitHub

Crystal Reports

Microsoft 365

Data Analytics

Education

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

Tools

GitHub

Cityworks

Power Automate

Job description

Columbus Water Works in Columbus, GA is seeking a Senior Programmer Analyst to lead the design, development, and integration of enterprise applications supporting operations and strategic goals.

The role develops SQL Server databases, Power BI dashboards, REST API integrations, and Microsoft 365 solutions while supporting Lawson ERP, ADP, AUS Infinity CIS, Cityworks, and other platforms. Mentoring and collaboration with stakeholders are essential.