Description

The San Francisco Planning Department 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, under the direction of the Planning Commission, shapes the future of San Francisco and 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. 

The Department serves a broad range of constituents, including the citizens of San Francisco, community organizations, elected and appointed policymakers, builders, architects, property owners, tenants, and advocacy groups. All rely on the City's General Plan and the Planning Code to achieve the City's development goals. 

This is an opportunity to work in a dynamic, inter-disciplinary, and innovative department and share in our vision to make San Francisco the world’s most livable urban place – environmentally, economically, socially and culturally. 

For more information about the San Francisco Planning Department, visit http://sf-planning.org.

We are seeking a Senior Analytics Engineer who will be a critical member of the core data analytics team, serving as the technical lead by providing prompt, professional data engineering expertise.

The successful candidate will possess strong values that align with the City's values, which include being welcoming, having integrity, showing accountability, and demonstrating a commitment to service.  Additionally, the ideal candidate is a highly organized individual with strong analytical, written and oral communication skills who can thrive in a fast-paced, high-pressure, deadline-driven work environment.

Under the direction of the Data & Analytics Manager, the Senior Analytics Engineer will serve as the technical lead to support the development of a Smart Cities Program for the San Francisco Planning Department.  This role will leverage data architecture and data engineering expertise to design and implement modern data systems, business intelligence and data analytics solutions that will produce actionable, timely and accurate data including the expansion of the Department’s 3D geospatial analysis capabilities, systems integration that support dashboard development, web maps and reporting, and designing solutions that will move staff from manual to more streamlined data tracking solutions. Success in this role means staying up-to-date and applying the best tools and techniques to process both structured and highly unstructured data to perform complex computations in a scalable, reproducible and automated manner. As a systems thinker and innovator, this role’s highest pursuits are continuous integration, clean data and continuous delivery to add features quickly while maintaining solution stability and scalability.  This position will work cross-functionally with data analysts, GIS analysts, engineers, urban designers, planners, policymakers and other stakeholders to translate business requirements into efficient technical solutions. This role has a demonstrated aptitude for successfully working with stakeholders across a highly matrixed organization, navigating competing interests and priorities and building solutions that clearly communicate critical issues and opportunities and drive data-informed decision making. Through the design of elegant integrated data systems, this role will make significant contributions to expanding the Department’s data and analytics capabilities in key areas such as housing production, racial and social equity, COVID-19 recovery, growth projections, urban design, land use, scenario planning, climate and resilience planning, operations and business process improvements.

Skills and responsibilities

Essential duties include, but are not limited to:
  • Modernize the Department’s data infrastructure and data management methods including analyzing business requirements to meet evolving data needs, conducting feasibility studies, evaluating technology and data services solutions, optimizing existing queries and integrating external and third party data sources.
  • Design, build, launch and maintain efficient data extraction, transformation and loading processes to ensure data integrity and validate data to ensure accurate data results.
  • Work closely with Planning IT, the Department of Technology, Digital Services and other partner agencies to ensure upstream technology and business process changes as well as new technology deployments integrate seamlessly with the Department’s data models and systems. 
  • Design and support new and existing data models and pipelines and establish data governance procedures and clear documentation.
  • Develop and maintain databases and data models that support Power BI dashboards, ArcGIS maps and other data products.
  • Develop procedures and solutions that eliminate data discrepancies among various information systems and reports.
  • Serve as a technical mentor and provide training to peers and junior staff on best data management practices.

Details

  • Location:
    San Francisco
    ,
    CA
  • Salary:
    $104,286.00
    -
    $131,196.00
    yearly
  • Deadline:
    2021-01-19

Qualifications

Minimum qualifications

  1. Education:
    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]. 
  2. Experience:
     Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.
     
     Special Conditions
  3. Two (2) years of experience in Geological Information System (GIS) using ESRI products to perform analysis, design, development, implementation, and production support for GIS applications.
     
     And
  4. Two (2) years of verifiable and recent experience in enterprise relational database modeling and design of  SQL Server, and other relational databases.

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.

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

Preferred 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.
  • BS/BA in Computer Science, Information Systems, Mathematics, Engineering or related technical field.
  • 3+ years of experience in data/information architecture, data warehousing, data engineering, system development or a related field.
  • 3+ years of experience in ETL design, implementation and maintenance.
  • Strong experience with data architecture, design and implementation.
  • Strong experience in Python, SQL, ArcGIS Desktop/ArcGIS Pro, ArcGIS Server, ESRI geoprocessing models, ArcPy, ArcGIS Online, ArcGIS Server Javascript API, AWS and Rest APIs.
  • Strong experience with geodatabase design and management especially ESRI enterprise geodatabases with PostgreSQL and Oracle, as well as implementing best data management practices.
  • Experience translating business needs into technical implementations, including mapping out business processes and data models.
  • Entrepreneurial, with a proven ability to execute on multiple tasks simultaneously.
  • Flexible as the needs and demands of the team evolve.
  • Experience communicating results, pros and cons of technical solutions with non-technical stakeholders.
  • Strong aptitude for forensic data analysis to identify and solve root-cause data issues.
  • Experience training non-technical users to use technology to support their work.
  • Strong quantitative and statistical analysis skills.