Data Scientist/Data Engineer (1042)

Career Opportunity

Data Scientist/Data Engineer (1042)

Recruitment: RTF0125379-01152485

Published: September 16, 2022

Contact:

Michael Eng - Michael.Eng@sfgov.org

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

Department: City Planning
Job class: 1042-IS Engineer-Journey
Salary range: $131,976.00 - $165,984.00
Role type: Temporary Exempt What does this mean?
Hours: Full-time

About:

This job announcement has been amended to extend the filing period of this recruitment.

The San Francisco Planning Department is recruiting for one (1) Temporary Exempt (TEX) Data Scientist/Data Engineer position in our Data Analytics Group within the Administration Division.

Specific information regarding this recruitment process are listed below:

Application Opening: September 6, 2022
Application Deadline: September 28, 11:59 PM PST
Recruitment ID: RTF0125379-01152485
Analyst: Michael Eng
Compensation Rage - $125,918 - $158,392 / Annual

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.

Role description

Under the direction of the Data & Analytics Manager, the Data Scientist/Engineer will develop predictive models, scenario planning analyses, data visualizations and their required data pipelines to provide decision support for key areas including public policy development, implementation, monitoring, operations, community engagement, and business process improvements that together inform the design and future growth of San Francisco’s built environment.

This role will play a key role in Data Analytics Group’s effort for modernizing data and analytics systems, workflows, products, and tools that support long-range land-use planning. This effort includes developing an integrated City Information Model that improves access to and quality of data on housing production and pipeline, land use, commercial and industrial activity, socio-demographic characteristic, and other information that support planning analytics.

The Data Scientist/Engineer will apply novel geospatial, statistical and machine learning methods to derive insights from a wide range of data sources including digitized records, permit systems, geospatial databases, the City’s Open Data Portal, surveys, and third-party data services. This role will develop a wide range of analytics tools for a variety of planning applications including differential policy diagnostics, recovery strategy assessments, and operational efficiency modelling. As a systems thinker and innovator, this position will work cross-functionally with data analysts, GIS analysts, data engineers, planners, urban designers, architects, and interagency stakeholders to create a tighter integration between policy and operational goals and evidence-based outcomes.

RESPONSIBILITIES
Under the direction of the Data and Analytics Manager, the Data Scientist/Engineer will support planning/policy development, implementation, and monitoring, and operations, and business process improvements in the Planning Department, and will be responsible for the following:

Collaborate with other divisions/teams in the Department to identify and understand key questions and challenges in plan and policy development, implementation, and monitoring, as well as in the Departments’ operations, and business processes.
Formulate analytical solutions and products that can answer and/or provide insight about key questions and challenges and communicate those analytical methods with respective divisions/teams.
Implement and maintain analytical solutions and products:
- Build data pipelines, identify data gaps and collaborate across the Department and other agencies to create/improve data systems
- Build interactive maps, data visualization and dashboards that convey key insights to business audiences and help them improve the performance of policies, processes and workflows
- Develop performance measurement frameworks and monitoring key metrics during policy implementation
- Implement and use machine learning models and perform statistical analysis to derive data-driven actionable recommendations that can improve the performance of policies, processes, and workflows
- Clearly convey analysis and modeling results to relevant stakeholders through reports and presentations
- Identify new data sources and methods to enhance the Department’s core data products, analytical tools and reports

How to qualify

Minimum Qualifications

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].

AND
One (1) year of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.

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

Desirable Qualifications
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

Solid knowledge of statistical techniques, including hypothesis testing, statistical sampling, and design experiment, among others
Solid knowledge of supervised and unsupervised machine learning algorithms and their implementations, and related concepts including regularization, optimizing hyperparameters, cross-validation, and accuracy measurement among others
Fluent in programming in Python or R, including data and analytics related libraries like NumPy, Pandas, SciPy, matplotlib
Demonstrated expertise in building data tools for ETL and data analysis, extracting data from SQL and NoSQL databases
Experience designing data schemas
Advanced degree in a quantitative field (such as Computer Science, Statistics, or Urban Analytics)
Research experience, particularly in urban planning and urban systems
Experience with GIS systems, and APIs such ArcGIS JS API, and geospatial libraries in Python or R
Familiarity with Git and tools for reproducibility (e.g., virtual environments, Docker)
Experience in implementing Natural Language Processing feature engineering and modeling
Experience in building meaningful data visualizations using at least one scripting-based visualization tool such as matplotlib or d3.js
Experience with BI tools such as Power BI or Tableau

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.

What else should I know?

Appointment Type: Temporary-Exempt (TEX). Pursuant to the City & County of San Francisco Charter, Section 10.104.6. Any person occupying a position under exempt appointment shall not be subject to civil service selection, appointment, and removal procedures. Exempt employees shall serve at the pleasure of the appointing officer.

This position is currently being filled as TEX, but the intent of the Planning Department to fill this position as Permanent in the near future. The candidate selected for this TEX position 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.

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

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

How to Apply:

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

An updated resume
A cover letter (optional)

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, Michael Eng, by telephone at 628-652-7522, or by email at Michael.Eng@sfgov.org

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.