1064 IS Programmer Analyst - Principal

Who We Are

The San Francisco Employees' Retirement System (SFERS) is dedicated to securing, protecting, and prudently investing the pension trust assets, administering mandated benefits programs, and providing promised benefits to the active and retired members of the City and County of San Francisco.

Established in 1889 as a fund for families and orphans of firefighters and police officers, today the San Francisco Employees' Retirement System serves more than 75,000 active, vested, and retired employees of the City and County of San Francisco and their survivors.

What We Do

The Information Systems Division provides department-wide training and support to users of the department's LAN and applications; coordinates City-provided technical services and support with the Department of Technology; manages the functional and technical teams assigned to develop and maintain the department's Pension Administration system and Enterprise Content Management (ECM) project; oversees the department's cybersecurity protocols; and leads the department's disaster recovery and business resumption planning and policy efforts.

• Application Opening: November 4, 2024

• Application Deadline: On or after Tuesday, November 12, 2024

• Salary: $138,476 to $174,200 annually

• Recruitment ID: REF45591L

• Location: 1145 Market Street

This job announcement will not close before Tuesday, November 12, 2024. Interested applicants are encouraged to apply as soon as possible.

Appointment Type

This is a Permanent Civil Service position with a Certification Rule on the resulting eligible list: Rule of 3.

Under general direction, the Principal IS Programmer Analyst plays a critical role in the development and enhancement of member self-service applications hosted on the SFERS portal. This position involves collaborating with vendors, developing and testing APIs between self-service applications and Pension Administration Systems, and taking a lead role in planning, analyzing, designing, and implementing various new systems. The Principal IS Programmer Analyst is responsible for ensuring internal and external controls, adherence to standards, and meeting user requirements. This role also includes reviewing workflows, consulting with departmental personnel, and providing technical assistance to others.

• Collaborate with vendors to develop member self-service applications hosted on the SFERS portal.

• Develop and test APIs between self-service applications and Pension Administration Systems.

• Plan, analyze, design, and implement new systems with a focus on establishing internal and external controls.

• Develop procedures for access, update, and retrieval of information.

• Ensure program designs meet user requirements and adhere to standards.

• Review departmental workflows, functions, and procedures.

• Consult with departmental personnel to obtain information on existing systems procedures.

• Develop proposals and plans for installing new or revised complex systems.

• Design, code, test, and debug programs for special projects and interfaces.

• Prepare final systems design and documentation necessary for programming.

• Review the work of others and provide technical assistance.

• Analyze and logically design database systems to support online self-service functions.

• Write, modify, and/or run programs to provide reports and extraction of database information.

• Download information to personal computers as necessary.

• Coordinate and/or attend project team meetings, user meetings, and similar gatherings as needed.

• Prepare user and technical manuals and instructions in MSWord, PDF, and HTML formats.

• Instruct users on new capabilities as needed; provide technical support for complex systems.

• Monitor system performance to ensure proper functioning, interaction with other subsystems, and timely and accurate report production.

• Provide website data interfaces to/from the Pension Administration System.

• Assist staff in the analysis and determination of appropriate action to respond to service requests and problem reports.

• Evaluate user service requests to determine and recommend the most appropriate solution meeting user business and application system requirements.

• Coordinate scheduling between technical support staff and departments.

• Prepare project plans, time and cost estimates for new projects, enhancements, or changes to existing systems/applications.

Education:

An associate degree in computer science or closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i. e. , at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

Experience:

Five (5) years of experience in applications or software programming or development.

Substitution:

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

How to stand out

Desired Qualifications:

• Frontend Programming: WordPress, HTML, CSS, JavaScript (React. js, Angular. js, Vue. js)

• Backend Programming: Python, JavaScript (Node. js), Ruby, Java, PHP, C# (Django, Express. js, Ruby on Rails, Spring, Laravel, ASP. NET)

• Knowledge of UI/UX design principles and tools for creating visually appealing and user-friendly interfaces.

• Experience using Git for code collaboration and management.

• Knowledge of MySQL, PostgreSQL, MongoDB, etc.

• Proficiency in database design, querying, and management.

• Experience in creating and consuming APIs for web application communication.

• Familiarity with web servers (e. g. , Apache, Nginx) and deployment environments (e. g. , AWS, Heroku, Google Cloud Platform).

• Understanding of web security best practices, including data encryption, secure authentication, and protection against common vulnerabilities.

• Ability to create responsive web applications adaptable to various screen sizes and devices; Experience in optimizing web application performance, including minimizing page load times and image optimization; Ability to develop web applications ensuring consistent performance across different browsers.

• Proficiency in testing methodologies, unit testing, integration testing, and debugging techniques.

• Information About The Hiring Process (/sfdhr. org/information-about-hiring-process)

• Conviction History

• Employee Benefits Overview (/sfdhr. org/b.