Career Opportunity

1064 IS Programmer Analyst - Principal (01156987)

Recruitment: REF45591L

Published: November 04, 2024

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

About:

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.

Role description

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.

How to qualify

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.

What else should I know?

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Seniority Credit in Promotional Exams
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

How to Apply

All applicants must submit a resume and completed job application (all sections, including Experience and Education, must be completed) in order to be considered. Resumes will not be taken as a substitute for completing the application. 

Applications for City and County of San Francisco jobs are only accepted through an online process.

Visit careers.sf.gov and begin the application process.

• Select the “I’m Interested” button and follow instructions on the screen

Applicants may be contacted by email about this recruitment and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

Selection Procedures:

Supplemental Questionnaire (Weight: 100%)

All applicants must complete a Supplemental Questionnaire, which serves as the sole examination component for this classification. Information provided by qualified candidates on the supplemental questionnaire will be used to evaluate candidates and measure knowledge, skills and/or abilities in job-related areas for job class 1064 IS Programmer Analyst - Principal. The Supplemental Questionnaire will be sent to qualified candidates after the filing deadline.

If you have any questions regarding this recruitment or application process, please contact the recruitment analyst, James Galileo, at james.galileo@sfgov.org 

All your information will be kept confidential according to EEO guidelines.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.