Programmer/Analyst

Company name: Philadelphia Corporation for Aging

Title of position: PROGRAMMER/ANALYST

Position type: Full Time

Pay range: $65,761.38 – $76,124.02 varies based on experience.

Location: PCA Main Building

THE ORGANIZATION

A private nonprofit organization founded in 1973, Philadelphia Corporation for Aging (PCA) is a large agency that is part of the Area Agency on Aging (AAA) nationwide network. Founded as a result of the federal Older Americans Act, the AAAs are mandated to “facilitate the area-wide development and implementation of a comprehensive, coordinated system for providing long-term care in home and community-based settings, in a manner responsive to the needs and preferences of older individuals and their family caregivers.” PCA carries out this mission through advocacy, stewardship of public funding, planning, development and administration of programs, and service coordination.

The mission of PCA is to improve the quality of life for older Philadelphians and those with disabilities and assist them in achieving the greatest possible levels of health, independence, and productivity.

Benefits:

• Medical, prescription drug, vision, and dental coverage
• Flexible spending plan (health and dependent care)
• EAP, life insurance, short- and long-term disability insurance
• Pre-tax commuting, and parking benefits
• 403(b) retirement plans with employer contributions and optional employee pre-tax contributions.
• Annual paid time off includes 13 holidays, 10 sick days, 2 personal days, and 4 weeks of vacation. (Note: vacation and personal days are front loaded and are pro-rated if date of hire is not January 1st; sick days are accrued based on hours worked).

Description of Role:

The Programmer/Analyst’s role is to define, develop, test, analyze, and maintain new software applications in support of the achievement of business requirements supporting Oracle and SQL Server based systems from database to front-end using DBA tools, relevant programming languages, and other technical skills. This includes writing, coding, testing, and analyzing software programs and applications. The Programmer/Analyst will also research, design, document, and modify software specifications throughout the production life cycle.

Required Education and Experience:

• Bachelor’s degree preferred in the field of computer science, information systems, or software engineering and 2 years related experience
• Associate degree and 4 years’ related experience
• 6 years’ related experience.
• Excellent understanding of coding methods and best practices.
• Experience in C#, ASP.net, JavaScript, JQuery, Visual Basic, Crystal Reports, Windows .NET Framework and ASP.Net.
• Database design/administration experience (Design, implementation, modification)
• Experience with Oracle and SQL Server Databases including development of database functions, stored procedures, and database triggers.
• Proficient in writing fine-tuned SQL queries, stored procedures (e.g. PL/SQL and TRANSACT-SQL code) and working with data in relational databases like Oracle, SQL Server, MySQL etc.
• Ability to: Recognize and resolve system related problems; work independently and make necessary decisions throughout the systems process within department guidelines.

Job Responsibilities:

a. Collaborate with developers, programmers, and designers in conceptualizing and developing new software programs and applications

b. Analyze and assess existing business systems and procedures.

c. Assist in the definition, development, and documentation of software’s business requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments.

d. Assist in defining software development project plans, including scoping, scheduling, and implementation.

e. Research, identify, analyze, and fulfill requirements of all internal and external program users.

f. Design, develop, document, analyze, create, test and modify computer systems, programs and integrations.

g. Apply system-analyst techniques and procedures, including consulting with users to determine hardware, software, or systems functional specifications

h. Arrange project requirements in programming sequence by analyzing requirements, preparing a workflow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.

i. Program the computer by encoding project requirements in computer language; entering coded information into the computer.

j. Document the functionality and requirements.

k. Research, evaluate and recommend solutions and appropriate technology to meet user's needs.

l. Maintains computer systems and programming guidelines by writing and updating policies and procedures.

m. Develops and maintains applications and databases by evaluating client needs; analyzing requirements; developing software systems.

Professional Characteristics:

• Must possess a valid driver’s license
• Able to communicate effectively with non-technical staff and with members of interdisciplinary teams.
• Proven analytical and problem-solving abilities.
• Ability to work both independently and in a team-oriented, collaborative environment.
• Good organizational and people skills.

Additional requirements:

1. Pre-employment physical

2. Drug testing

3. Criminal history clearance

For information on Philadelphia Corporation for Aging, including more information on our company culture, visit our website at https://www.pcacares.org/

All applicants will receive an acknowledgement that their application has been. Those candidates selected for further consideration will be contacted.

Philadelphia Corporation for Aging is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.