Data and Analytics Manager (#1054)

  • 49 S Van Ness Ave, San Francisco, CA 94103, USA
  • Full-time
  • Exam Type: Position Based Test
  • Eligible List Type: Combined Promotive and Entrance
  • Certification Rule: Rule of 7
  • Fill Type: Permanent Civil Service
  • Work Hours: Regular
  • Job Code and Title: 1054-IS Business Analyst-Principal

Company Description

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

  • Application Opening - August 15, 2022
  • Deadline to Apply:  August 29, 2022, 11:59 PM PST
  • Recruitment ID:  RTF0125054-01094826
  • Exam Type: Combined, Promotive and Entrance
  • Exam AnalystMichael Eng
  • Annual Salary:  $136,162 - $171,288/Yearly

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
The mission of the San Francisco Planning Department, under the direction of the Planning Commission, shapes the future of San Francisco and the region by: generating an extraordinary vision for the General Plan and in neighborhood plans; fostering exemplary design through planning controls; improving our surroundings through environmental analysis; preserving our unique heritage; encouraging a broad range of housing and a diverse job base; and enforcing the Planning Code. 

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. 

Job Description

The Data and Analytics Manager (IS Business Analyst-Principal) will lead the effort on behalf of the Planning Department to improve data access and analytical capacity for Department staff, the public, decision-makers, and other agencies, including modernization and integration of various key data products, tools and workflows into a seamless and efficient Land Use Information System. This position is essential to support the City’s goals for sustainability, equity, resiliency, and prosperity.

The ideal candidate will have: an understanding of contemporary tools available for geospatial, urban systems, and government analytics; strong analytical skills; project and time management experience within a complex governance system; and the ability to incorporate problem solving, critical thinking and tactical execution into their daily work.

Essential duties include, but are not limited to:

  • Directing the development and execution of data analytics, reporting and research activities to provide planners, senior leadership, decision-makers and the public with information and tools for policy analysis, strategic decision making, trends and forecasting, and data and informatics needs.
  • Supervising and directing a team of multi-disciplinary team of data analysts, planners, GIS specialists, and programmers, including developing work programs and budgets, prioritizing assignments, fostering collaboration and innovation, providing professional development, evaluating staff performance, and providing strategic direction for the team for ongoing modernization and improvement of tools and techniques in GIS work with the objective of creating new information and/or investigation geo-spatial patterns and trends, and maximizing integration of GIS tools with other data analytics and planning practices.
  • Collaborating and building strong partnerships with external stakeholders, City departments, Commissions and Board of Supervisors, and other governmental agencies on developing and carrying out data reporting and analytics strategies.
  • Developing and implementing data collection and reporting systems and other strategies that optimize efficiency and data quality which integrate with other activities.
  • Modernizing data use in planning that aligns with the long-range policy goals of the City.
  • Managing the design and production of data products and data systems that provide information, and data analysis and reporting tools, based on informatics needs for Planning Department programs and divisions
  • Acting as the subject matter expert for data analytics and data reporting initiatives.
  • Performing other data analytics related duties and activities as required: project management, presentation creation and strategic planning.



  • An associate degree in 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 computer science or a closely related field].


  • Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management

  • Two (2) years experience in Geological Information System (GIS) using ESRI products to perform analysis, design, development, implementation, and production support for GIS applications.

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 / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

The above minimum qualifications reflect special conditions associated with the position to be filled. They may differ from the standard minimum qualifications associated with this classification.


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

Verification of Education and Experience:  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

Additional Information

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) - Candidates will be required to complete MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

2. Supplemental Questionnaire Exam (weighted 100%) - Candidates will be required to complete the Supplemental Questionnaire Exam (SQ) as a part of the selection process. The Supplemental Questionnaire is designed to measure the knowledge, skills and abilities required for the position. 

The SQ Exam will be emailed to the email address listed on the candidate's online job application approximately 3 – 4 weeks after the close of the exam announcement.  Candidates will be required to respond to the SQ in the time frame indicated and must submit the completed questionnaire as directed in order to have it evaluated.  Responses cannot be changed once submitted.  Candidates will be evaluated based on their SQ responses.

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:  Position-Counts-by-Job-Codes-and-Department-FY-2021-22.pdf (

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.

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

Questions:  If you have any questions regarding this recruitment or application process, please contact the exam analyst, Michael Eng, by telephone at 628-652-7522, or by email at [email protected].

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.