1054 IS Business Analyst-Principal

Planning Data and Analytics Manager

Recruitment #TEX-1054-097900


*8/2/2019:  Announcement amended to extend filing deadline to 8/9/19
**8/9/2019:  Announcement amended to extend filing deadline to 8/16/19

Appointment Type

Temporary Exempt (TEX).  TEX position is excluded by the Charter from the competitive civil service examination pursuant to San Francisco Charter Section 10.104 and shall serve at the discretion of the Appointing Officer.  Appointee must participate and be successful in a Civil Service Examination process for this classification and be selected through an open competitive process in order to be considered for a permanent appointment.


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

Our mission, under the direction of the Planning Commission, shapes the future of San Francisco and region by: articulating the vision in the General Plan and Planning code to guide both public action and private investments; fostering exemplary design; improving our surroundings through environmental analysis; increasing understanding of our past; encouraging a broad range of housing and a diverse job base; and enforcing the Planning Code.

The Division.  The Citywide Division of the Planning Department develops policy, maintains and oversees compliance with the City's General Plan, prepares and implements community plans, acts as the urban design resource for the city, and gathers and analyzes data in support of land use policy.  The Division works on a wide range of topics, including housing, transportation, urban design, land use, community development, resiliency, and sustainability. 

This is an opportunity to work in a dynamic, inter-disciplinary, and innovative department and share in our vision to enhance San Francisco's livability - environmentally, economically, socially and culturally.  For more information about the Planning Department, visit http://sfplanning.org.

Why San Francisco Planning?

The San Francisco Planning Department leads the nation in many areas of forward-thinking urban development policies.  Ongoing and recent highlights of these include ambitious zoning plans for new housing, creating new models of public open space, encouraging sustainable transport through eliminating automobile parking requirements and planning for high-speed rail, and creating new standards for sustainability.  Many of today's challenges demand even more from local government.  Be a part of the solution and ensure that policy is grounded in knowledge.

Position Description

The San Francisco Planning Department (CPC) is seeking a demonstrated leader for our Data and Analytics Group (“DAG”), within the Citywide Division.  The manager of DAG will have a proven track record of success in modern land use and urban analytics, team leadership, and the ability to manage relationships and instill the importance of data-driven decision-making with community, partner city agencies, state and federal organizations.  

The DAG Group, part of the Department’s Citywide (Long Range) Planning Division, is responsible for producing, refining and analyzing cornerstone reports, data and visualization products that inform public policy initiatives, serve as key inputs to long-range growth planning by many public agencies, and meet local, regional and state reporting obligations.

The Data and Analytics Group Manager will lead the effort on behalf of the Planning Department to dramatically 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. Responsibilities include the following


     Developing data and analytics strategy

        Modernizes our data work to Bay Area professional standards from a deep base of understanding of data governance, standards and analytics.

        Increases the capacity of the DAG to match San Francisco’s long-range planning challenges, including housing, climate change, transportation and equity.

        Increases the ease and speed of information product delivery for staff, decision-makers, and the public.

        Assesses and upgrades tools for relational database management, GIS, land use modeling, statistical analysis and open source databases.  Current DAG tools include: MS Access, SQL, ESRI, python, Rstudio, Stata, PostgreSQL, and Leaflet.

        Manages the assembly, refinement and optimization of integrity of unique datasets.

     Leading Data and Analytics Group

        Creates a mentoring environment for staff learning paired with excellent communication skills, transparent decision-making, and timely, tailored interventions.

        Presents data and analysis to key stakeholders and officials including the Planning Commission, and the Board of Supervisors.

        Represents the DAG within the Citywide Managers and shares responsibilities in the leadership of the Citywide division including budget, work program and personnel development.

        Prepares and monitors project schedules, scopes, and budgets.

     Collaborating with partners

        Functions as lead contact for the City’s housing data production with multiple agencies including US Census, CA Department of finance, and Bay Area Metro.

        Coordinates with the Mayor’s Office, Building Department, Controller’s Office, and department staff on housing production reports.

        Provide guidance to the Planning Director on the establishment of new internal and external procedures and technology for improved coordination of data.

        Manages response to regular and ad-hoc data requests from other Departments, elected officials, Commissioners, internal staff and the public.

     Informing land use and planning policy

        Management of numerous planning, analytical, and monitoring studies that inform policy initiatives and inquires.

        Collaborates on policy project design with planning managers through an iterative process, informed by data products.

        Oversees production and promotion of approximately two dozen data products including the Housing Pipeline, the Land Use Allocation, the Housing Inventory and the Commerce and Industry Report.

      Our ideal candidate is someone who is

        A visionary systems thinker, who can see how transforming and merging geo-spatial tools with data management platforms can address multiple overlapping ongoing reporting and long-range planning challenges

        A problem solver. who can identify technical and procedural improvements, both incremental and transformative, within a complex organization like city government

        Driven by improving San Francisco to realize its highest ideals for current and future generations through better access to data and tools for analysis to inform long-range decision making.


Minimum Qualifications

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification.  Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.

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.

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.

Desirable Qualifications:

While the specific combination of experience may vary, the ideal candidate would have substantial experience of 10-15 years of work experience in some combination of data science, GIS, urban planning, and/or government.  This experience may include:

  • 5 years or more of verifiable and recent experience in Geographic Information System (GIS) using ESRI products to perform analysis, design, development, testing, implementation, and production support for GIS applications.
  • Experience and familiarity with urban planning and public policy.
  • Substantial experience in team management, including leading and mentoring staff.
  • Experience in conceiving and directing transformative change or modernization in data management, analysis, delivery, and visualization.
  • Ability to interpret data and present the analysis to community members, decision-makers, and staff from a variety of agencies.
  • Experience in strategic planning, critical thinking and problem-solving skills in an urban and public policy context.
  • Experience in working effectively with engineers, planners, lawyers, administrators, elected and appointed officials and other staff across multiple agencies or organizations.

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

How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement 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).

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.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the analyst, Susan Chu, by telephone at 415-575-9149, or by email at Susan.Chu@sfgov.org.


Selection Procedures

Minimum Qualification Supplemental Questionnaire (MQSQ): Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application.  This Minimum Qualification Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position.  Applicants must also complete the official application.  It is essential that applicants provide complete information in identifying their education, experience and training.  The Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.

In addition to completing the MQSQ, please also attach a resume/curriculum vitae to your application.

Conviction History

As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

  • Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
  • Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


General Information concerning City and County of San Francisco Employment Policies and Procedures:
Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.

Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.


Issued:   July 12, 2019

Amended:  August 2, 2019 - to extend filing deadline 

                    August 12, 2019 - to extend filing deadline

Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number:  TEX-1054-097900



All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.


Powered by JobAps