ANALYST PROGRAMMER - STEP 1

ALCOSAN is committed to providing wastewater treatment services 24 hours a day, seven days a week. From our Board of Directors to our Executive Director, leadership and staff; we work to enhance the community’s quality of life and safety by protecting our rivers and streams. After 60 years of continued design, construction and operations of the sewer system and treatment plant, we now have 400 plus employees serving residential, commercial and industrial customers in 83 communities throughout Allegheny County.

Position Summary

The Analyst Programmer is responsible for developing, maintaining, and supporting the Authority’s business applications and databases. This position analyzes user requirements, designs technical solutions, writes, tests, and maintains programs to improve operational efficiency and data integrity. The incumbent collaborates closely with departments to automate business processes, integrate systems, and provide analytical support for decision-making.

Job Duties

•    Analyzes business and operational requirements to design, develop, and implement new applications or enhance existing systems. Utilizes state-of-the-art techniques when implementing office automation solutions.
•    Assists in database design, data integrations, maintenance, and optimization to support application functionality between core systems and third-party applications and reporting needs by developing queries, views, and reports to extract and present business data from relational databases. 
•    Participate in the development and enforcement of programming standards, documentation, and version control practices in conjunction with the Authority’s policy guidelines, as well as recommend new and improved guidelines to ensure compatibility and better service to the end user.
•    Maintains current technical expertise in rapidly changing information technology.  Maintains current knowledge of software development trends, programming languages, and enterprise technologies.
•    Collaborates with users, vendors, and other technical staff members on the identification, isolation, and correction of problems and/or enhancements. 
•    May also serve in the additional capacity of Personal Computer Specialist and is responsible for the overall coordination, control, and maintenance of Personal Computers.

Job Duties (cont.)

Performs other job-related duties as requested.

Knowledge / Abilities

Extensive / Considerable knowledge of:
•    One or more programming languages (e.g., Python, C#, SQL, Java, PowerShell)
•    Relational databases, APIs, and modern software development practices.
•    Software development trends, programming languages, and enterprise technologies

Working knowledge of:
•    Researching and evaluating new applications and network technologies.

Ability to: 
•    Work within a team under deadline(s) while providing high-level customer service.  
•    Manage and prioritize time and projects to meet demand from departments and personnel.
•    Analyze complex data and business processes to develop automated solutions.
•    Strong problem-solving and communication skills with the ability to collaborate across departments.
•    Manage multiple projects and meet deadlines in a team-oriented environment.
•    Establishes and maintains effective working relationships with all levels of personnel both internally and externally, e.g. leadership, executives.

Minimum Education Level Required

Bachelor’s Degree in Information Technology or a closely related field of study.

Minimum Experience Required

Minimum of Three (3) years’ job-related experience 

Required Certifications / Licenses

None Required

The Allegheny County Sanitary Authority is an Equal Opportunity Employer. It is the policy of the Authority to comply with all federal, state, and local statutes governing equal employment opportunity.


Nearest Major Market: Pittsburgh