1053 IS Business Analyst-Senior (Senior Analytics Engineer)

Recruitment #PBT-1053-108053

Introduction

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

Introduction

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.

Position Information

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.

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.

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. 


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.

  • 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.
Note

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

How To Apply

In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice.  As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.

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

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

Selection Plan

  • Minimum Qualifications Supplemental Questionnaire (Qualifying)
  • Supplemental Questionnaire (Weight: 100%)

Selection Procedures

Minimum Qualifications Supplemental Questionnaire (Qualifying)
Applicants are required to complete a Minimum Qualifications Supplemental Questionnaire (MQSQ) as part of the online application process. The purpose of the MQSQ is to obtain specific information regarding an applicant’s education, experience and training in relation to the Minimum Qualifications for this position. It is essential that an applicant provide complete information in identifying their education, experience and training. The MQSQ will be used to evaluate if an applicant meets the minimum qualifications.

Supplemental Questionnaire (Weight: 100%)
Qualifying candidates will be required to respond to essay type questions on a supplemental questionnaire, which will be provided to applicants via e-mail after the closing of the application filing period. The essay questions are designed to measure the knowledge, skills and/or abilities in job-related areas required for the position which may include but are not limited to: knowledge of the principles and practices of geographic information systems (GIS); ability to analyze, interpret, summarize, and present technical data; problem solving ability; knowledge of methods and techniques of database analysis and design and development of relational databases; and written communication ability. 

Candidates will be ranked on the eligible list based on their supplemental questionnaire score.

A passing score must be achieved on the Supplemental Questionnaire 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-Count-by-Job-Codes.pdf.

Verification: Applicants may be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental selection process. Failure to provide the required verification when requested may result in rejection of application and/or removal from eligibility for referral and appointment in this class. Verification may be waived if impossible to obtain. The applicant must submit a signed statement explaining why verification cannot be obtained. Waiver requests will be considered on a case-by-case basis.

If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements. 

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.

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.

Conclusion

Terms of Announcement:

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 by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.

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.

Seniority Credit in Promotional Exams:

Information regarding seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit

Requests:

Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:

http://sfdhr.org/information-about-hiring-process#applicantswithdisabilities

Information regarding requests for Veterans Preference can be found at:

http://sfdhr.org/information-about-hiring-process#veteranspreference

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.

 

Exam Type: CPE

Issued: December 21, 2020

Carol Isen, Acting Human Resources Director

Department of Human Resources

Recruitment ID Number: PBT-1053-108053

CPC/ME 628-652-7522

Benefits

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