IS Business Analyst - Assistant (1051) - City and County of San Francisco

This is a Position Based Test conducted in accordance with Civil Service Rule 111A.

• Application Opening - October 21, 2024
• Deadline to Apply:  November 4, 2024, 11:59 PM PST
• Recruitment ID:  REF45374R
• Exam Analyst:  Zoey Feng

The Department

The San Francisco Planning Department (CPC) plays a central role in guiding the growth and development in our City. The Department works with other City agencies and the community to help achieve great planning for a great city.   

Our Mission

San Francisco Planning shapes how land is used to meet community needs and guide our city’s future, creating inclusive, sustainable, and prosperous neighborhoods.

Our Racial and Social Equity Vision 

The Department’s racial and social equity vision is:  

We envision inclusive neighborhoods that provide all with the opportunity to lead fulfilling, meaningful, and healthy lives. We envision a city where public life and public spaces reflect the past, present, and future of San Franciscans. We envision a city where a person’s race does not determine their lives’ prospects and success. 

We envision an inclusive Planning Department and Commissions that represent and engage the communities we serve. We envision a department that proactively infuses racial and social equity in both internal operations and external Planning work. Together, we are reimagining what the Planning field is and can be – inclusive, diverse and one that centers racial and social equity both as a practice and as an indicator of success. 

To achieve this broader city vision, we must do our part and address racial and social equity within the Planning Department’s policies and practices.

The San Francisco Planning Department is seeking applications for an Assistant Graphic Design and Geographic Information System Analyst position.

Under general direction, the IS Business Analyst - Assistant is responsible for assisting with creating visually effective designs for a variety of print and digital media, including websites, social media, presentations, reports, and other design projects as it relates to the needs for the Planning Department. 

The IS Business Analyst - Assistant will also be responsible for supporting the maintenance of various GIS datasets, creating high-quality cartography, and support the building and maintaining GIS web maps and tools. This position may also perform functional tasks such as website design, developing documentation, testing, and user support.

The essential functions of this position include but are not limited to: 

• Assist with preparing a wide variety of graphics, such as logos, icons, infographics, presentations, and reports for internal and external stakeholders;
• Assist with designing websites, social media posts, and public informational materials;
• Support the maintenance and development of various Geographic Information System (GIS) datasets, using GIS software to assist with the development of geospatial data, and analyze spatial and non-spatial data to assist with the development of reports;
• Assist with maintaining GIS web maps and tools to support internal and external stakeholders;
• Assist in the design of new and/or revise GIS systems and programs, and in the coordination of integration into existing systems and procedures;
• May perform testing necessary to debug new and revise GIS desktop tools;
• Designs print and digital materials with a lens of cultural competency, nuances, and digital accessibility for the Department’s diverse stakeholders.

Education:

An associate degree in business administration, public administration, information systems, economics, finance, computer science or a 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 one of the fields above or a closely-related field].

Substitution:

Experience in the information systems field, including technical support, content management, administration of network applications or system analysis 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 / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.

Desirable Qualifications
Technical skills

• Experience with graphics design for broadcast, including setup and troubleshooting of character generator, non-linear editing and bulletin board systems using web design and graphic tools such as PhotoShop, After Effects, Page Maker, and Illustrator.
• Completion of Geographic Information System (GIS) courses using ESRI products (Arcview, ArcInfo, ArcGIS, MapObjects, ArcIMS).
• Experience with Design software (like Adobe Creative Cloud, Sketch)
• Experience with Content Management Systems (like Drupal or WordPress), HTML, and CSS.

Applicants must meet the minimum qualifications requirement by the final filing date unless otherwise noted.

Verification
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456

Note
Falsifying one's education training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Selection Procedures

After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

1. Minimum Qualification Supplemental Questionnaire (MQSQ) - Qualifying
Candidates will be sent an MQSQ via email as part of the employment application. Applicants will be required to respond to the MQSQ in the time frame indicated and submit their answers as directed. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQs) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

2. Supplemental Questionnaire Exam (SQ) - Weight 100%
Candidates who meet the minimum qualification for this position will be sent a Supplemental Questionnaire (SQ) via email to complete and return. Applicants will be required to respond to the SQ in the time frame indicated and submit their answers as directed.

The Supplemental Questionnaire is designed to determine relative knowledge, skills and ability levels in job related areas which may include, but not be limited to:  Problem solving ability; Ability to analyze and categorize data and information and use desktop publishing, illustration, photo retouching, web design and other graphic design software; Project management ability; Oral communication skills; and Written communication ability.

The SQ will account for 100% of the total weight of the final score.

A passing score must be achieved on all components of the selection procedures in order to be placed/ranked on the score report. The department may administer additional position-specific selection procedures to make final hiring decisions.

Eligible List/Score Report:
A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.

Certification: The certification rule for the eligible list resulting from this examination will be Rule of Seven (7). Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

The duration of the eligible list resulting from this examination process will be six (6) months, and may be extended with the approval of the Human Resources Director.

Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see:  https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2023-24.pdf.

Additional Information Regarding Employment with the City and County of San Francisco:

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

Terms of Announcement:

This is a Position Based Test conducted in accordance with Civil Service Rule 111A. Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations.  Clerical errors may be corrected and, if so, an amended note will be posted on this official job announcement.

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule.  Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director.  Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date

How to Apply:

To be considered, please submit a SmartRecruiters application and attach to your application:

• Resume

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

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.

Questions:  If you have any questions regarding this recruitment or application process, please contact the exam analyst, Zoey Feng, by telephone at 628-652-7628, or by email at yajian.feng@sfgov.org.

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.