Programmer/Business Analyst

Must submit resume and cover letter with salary requirements

Purpose/Customer Impact:  Key responsibilities of the Programmer/Business Analyst encompass a range of tasks that bridge programming and data analysis. This position focuses on programming duties, involving the development and maintenance of software applications using diverse programming languages and frameworks and will play a crucial role in Portland Water Districts’ (PWD) Application Programming Interface (API) management, facilitating seamless communication between various software systems. Additionally, they will manage SharePoint configurations, workflows and updates, overseeing the collaborative platform to enhance organizational efficiency. This multifaceted role demands a skill set that includes programming expertise, analytical capabilities, and a comprehensive understanding of software integrations and SharePoint technologies.  The Programmer/Business Analyst will define, develop, test, analyze and maintains new and existing software applications.  This is achieved through writing, coding, testing, analyzing, researching, designing, documenting and modifying software to increase efficiencies through programming new applications for better integration.   

Reporting Relationships:      Reports to:    Information Services Manager                 Indirect Reports:     None

Interrelationships: Position has daily contact with Information Services (IS) colleagues, works closely with groups across PWD, frequent contact with other employees, vendors and consultants. Participation, supporting and/or leading project teams across PWD.

Independent Action: Demonstrate the ability to independently analyze complex issues, identifying root causes, and implementing effective software solutions. Proactively troubleshoot and resolve technical challenges to ensure the continuous and smooth operation of software applications and API integrations.

Job Duties:

Strategy and Planning

  • Collaborate in conceptualizing and development of new software programs and applications
  • Analyze, assess, design and implement software solutions to address complex business challenges, and find efficiencies.
  • Build and manage information that is fed to websites from PWD’s system
  • Documentation of all software coding.
  • Develop, optimize and troubleshoot API integrations, including improving business processes, and developing software programs, mostly programming information to flow between existing systems.
  • API Integration documentation maintenance.
  • Develop, optimize and troubleshoot SharePoint workflows with Power Automate and integrations.
  • Support PWD website data feeds.
  • Assist in software upgrades and updates.
  • Other programming related duties as required.
  • Work with Information Services Manager to prioritize project requests.
  • Recommend, schedule, and perform software improvements and upgrades

Operation Management

  • Work within the department and with other departments to assist in resolving problems with software products or company systems.
  • Consistently write, translate, and code software programs and applications according to specifications.
  • Write programming to enhance functionality and performance of company applications as needed.
  • Design, run and monitor software performance tests on new and existing programs for the purpose of correcting errors, isolating areas for improvement and debugging.
  • Train and assist users to operate new or modified programs.
  • Install software products for end users as required. 

Physical Requirements: Sitting, standing, walking, bending, twisting, reaching, telephone usage, visual accuracy, extended keyboard usage, clear verbal and written communications, lifting (maximum 25 lbs.), driving

Minimum Requirements:  An individual must be able to perform Essential Job Duties satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

  • Four (4) year college degree in Computer Science and two (2) to three (3) years of directly related work experience or at least four (4) to five (5) years directly related work experience including:
  • Programming:
  • Proficient in languages such as .Net, Python, Java, C#, or others depending on the technology stack
  • Experience with RESTful API design and implementation.
  • Ability to design, implement, and troubleshoot API calls.
  • Strong understanding of API concepts and protocols.
  • Experience with third-party API integration.
  • Familiarity with web development frameworks (e.g., WordPress, Drupal etc.).
  • SharePoint:
  • Expertise in SharePoint administration and configuration.
  • Experience with SharePoint migration tools and strategies.
  • Knowledge of SharePoint security models and best practices.
  • SQL:
  • Strong SQL skillset for database design, querying, and optimization.
  • Experience with stored procedures, triggers, and functions.
  • Knowledge of database management systems (e.g., Microsoft SQL Server, MySQL).
  • Software Testing:
  • Proficient in software testing methodologies and tools.
  • Experience in developing and executing test cases for web and mobile applications.
  • Knowledge of automated testing frameworks.
  • Demonstrated ability to manage multiple tasks and meet deadlines.
  • Proven oral and written communication skills across a wide range of internal and external customers.
  • Ability to comprehend complex problems and use knowledge, judgment and tact to work towards successful solution.
  • Demonstrated ability to function in a team environment and contribute to success of project goals.
  • Demonstrated ability to manage multiple tasks and meet deadlines.
Apply for this position