Programmer/Analyst

Programmer/ Analyst:

The Housing Opportunities Commission of Montgomery County (HOC) was established in 1974 to better respond to the County's need for affordable housing. HOC is authorized to acquire, own, lease, and operate housing; to provide for the construction or renovation of housing; obtain financial assistance from any public or private source to assist its housing activities; and arrange for social services, resident services, and daycare.

Job Description:

The Programmer/Analyst is responsible for analyzing business requirements and computer systems, designing and developing computer programs and providing computer automated solutions for the entire agency. This position performs all aspects of analysis, design, development, testing, implementation, and maintenance of new systems, applications programs, and enhancements. The Programmer/Analyst also monitors the performance of each program after upgrade, identifies programming needs and resolves programming problems. They also design and codes screen layouts, graphical user interfaces, printer outputs, and

interfaces with other systems. Other duties include training technical support staff to use programs, providing technical assistance regarding issues with any HOC application programs, writing and maintaining functional and technical specifications for in-house applications, and creating documentation to describe the installation and operation procedures, program development, logic, coding, testing, changes, corrections and user references for in-house developed applications.

The position requires a person with systems analyst, programming and database experience as well as good interpersonal skills to operate in a complex, rapidly changing environment. The Programmer/Analyst will be responsible for operational support of all HOC applications systems, implementation of application upgrades, analysis and resolution of user identified problems, database analysis, and maintenance and development of all HOC application programs.

The individual in this position must have a high degree of communication skills because of the need to interact with all users in regard to problems and bugs and the need to develop reports. The individual serves as the coordinator of upgrades. The Programmer/Analyst must be able to present ideas/information and negotiate to reach agreement on the course of action.

Responsibilities:

System Analysis and Design:

• Analyze user requirements and business needs to design software solutions, databases, and system specifications.
• Analyze, define and document requirements for data, workflow, logical processes, system interfaces, user input and output options and controls.
• Analyze codes to find causes of errors and debug/revise new and existing applications as well as programs.
• Analyze and estimate feasibility, cost, time, and compatibility with other programs.
• Research and evaluate software to use or assist in programming.
• Debug and Resolve issues independently by analyzing existing code with minimal or
• No Documentation or other types of support

Software Development:

• Write, test, and maintain technical specifications.
• Design and code screen layouts, graphical user interfaces, printer outputs, and interfaces with other systems.
• Create test transactions and run tests to find errors and confirm programs meet specifications.
• Convert designs and specifications into computer code.
• Create, maintain, and optimize stored procedures, database and ETL processes.

Implementation and maintenance:

• Develop and maintain plans outlining steps and time tables for developing, testing and installing applications.
• Monitor performance of programs after implementation/upgrades.
• Work with all levels of development from analysis through implementation and support.

Troubleshooting and support:

• Provide technical assistance by responding to inquiries regarding errors, problems, or questions about programs in a timely manner assigned by the supervisor.
• Resolve end user problems through collaboration with IT and Operations.

Documentation:

• Write and maintain documentation to describe program development, logic, coding, testing, changes and corrections and save the documentation within the shared space assigned by the supervisor.
• Write or review documentation written by others that describes installation and operation procedures, and provide feedback on improving processes where appropriate.

Collaboration:

• Collaborate with team members, users and stakeholders to gather information about program needs, objectives, functions, features, and input and output requirements.
• Collaborate with team members, users and stakeholders to prototype, refine, test and debug programs to meet needs.
• Train end users or technical support staff to use programs.
• Interact with the business and report owners to establish/clarify requirements.
• Perform other duties as assigned.

Minimum Qualifications

Experience:

• At least five (5) years of experience in system analysis, database analysis and programming of information systems, including programming using MS SQL Server 2005, 2008 and 2016.
• Solid knowledge of SQL and scripting.
• Experience with stored procedures, reading queries.
• Five (5) plus years of extensive experience with all phases of software development life

cycle (SDLC), involved in designing, developing, integrating and implementing, software applications

• Five (5) plus years of experience with Adobe pdf and Microsoft fill docs design and implementation.

Education:

• Graduation from an accredited college or university with Bachelor's degree in Computer Science or related field
• An equivalent combination of education and experience may be substituted.

Knowledge, Skills & Abilities:

• Knowledge of the principles and practices of the computer science field.
• Knowledge of relevant system and database software, programming languages and system administration.
• Knowledge of the Cloud-based, Web-based and Database system experience in Microsoft SQL.
• Knowledge of software development, debugging, testing, and database management
• Ability to analyze and interpret requirements to design effective solutions for resolving business problems with limited information.
• Knowledge of Microsoft Access and Excel.
• Basic knowledge in languages such as VB and C#.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• Ability to perform other related duties as assigned.

* Grade 22- Min: $65,642/ Mid: $86,890/ Max: $108,138 | Salary determined by departmental budget- Offer commensurate with experience

HOC is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to sex, race, color, age, national origin, religion, disability, genetic information, marital status, sexual orientation, gender identity, gender reassignment, citizenship, immigration status, protected veteran status, or any other basis prohibited under applicable federal, state or local law. HOC promotes a drug-free workplace.

HOC conducts criminal background checks, employment reference checks, and where applicable, reviews driving records in determining suitability for employment. Selected applicants will be required to submit to pre-employment drug and alcohol screening. Employment is contingent upon drug and alcohol test results.