Job Description

The 1042 Analytics Engineer is responsible for maintaining, developing, and coordinating engineering services to support City data sharing via the City’s data platform as well as assisting our data science work.  You will:

Improve the data services DataSF offers to departments

• Help implement new automation patterns that leverage cloud analytics platforms (including Snowflake and dbt) to publish new datasets to the open data portal more efficiently and reliably
• Update and improve documentation to support both our own internal operations as well as self-service data automation for other departments
• Continuously assess and help improve our suite of data automation services by evaluating new and emerging technologies, streamlining existing business processes, and identifying opportunities for automation and self-service tooling
• Support the building and deployment of new data services for departments

Build analytics pipelines to support data-driven work

• Work with the team to develop extract, transform, load (ETL) requirements for individual datasets and consult with departments on the best way to automate and publish datasets
• Apply an ethical lens to the appropriate use of data
• Create new analytics pipelines using ETL/ELT approaches according to standards and patterns you help develop and refine
• Implement analytics pipelines and/or data models to support data science and data analytics work as needed

Maintain existing data pipelines

• Monitor existing data automations developed on our legacy infrastructure (Safe Feature Manipulation Engine (FME) Server), respond to incidents, and manage updates
• Migrate existing data automations to leverage cloud analytics tools (dbt, Snowflake, etc.)
• Analyze pipeline throughput, issues, and other metrics to inform improvements to the automation platform

Qualifications

1.  Possession of 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

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

Personal Skills

• Excellent oral and written communication skills
• Investigative ability and intellectual curiosity
• Ability to learn and embrace new technologies
• Familiar with the principles and concepts of open data
• Comfort with risk and trying new things
• Ability to work independently and as part of a small team
• Enjoys collaborative processes and developing shared understanding
• Strong organization skills

Technical/Knowledge Skills

• Experience in data manipulation and analytical thinking
• Experience writing and maintaining ETL/ELT code, especially creating and deploying through a framework
• Programming proficiency in Python and SQL

BONUS POINTS IF YOU HAVE:

• Experience with Snowflake/dbt. 
• Familiarity with Microsoft’s Azure Cloud Tools and/or PowerBI. 
• Experience configuring, loading data into, and extracting data and insights from customer relationship management (CRM) tools (e.g. Salesforce). 
• Experience training non-technical users to use technology to support their work
• Strong quantitative analysis skills
• Strong familiarity with geospatial data and best practices
• Experience translating business needs into technical implementations, including mapping out business processes and data models
• Experience working with a variety of databases, APIs, and formats to extract and transform data

IMPORTANT: Submission of a resume and a cover letter describing why you are applying for this position is REQUIRED at the time of filing.  To upload these items, please attach using the “additional attachments” function. 

DataSF encourages applications regardless of whether you think you meet 100% of the desirable skills listed above. VERIFICATION: Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement. Written verification must be submitted on employer’s official letterhead, specifying name of employee, dates of employment, types of employment (part-time/full-time), job title(s), description of duties performed, and the verification must be signed by the employer. City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules. Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations and total earnings must be submitted. 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. 

Additional Information

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

COMPENSATION:  $125,918 - $158,392 annually

APPLICANTS ARE ENCOURAGED TO APPLY IMMEDIATELY AS THIS RECRUITMENT MAY CLOSE AT ANY TIME, BUT NOT BEFORE SEPTEMBER 23, 2022. LATE OR INCOMPLETE SUBMISSIONS WILL NOT BE CONSIDERED. MAILED, HAND DELIVERED OR FAXED DOCUMENTS/APPLICATIONS WILL NOT BE ACCEPTED. Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine candidates’ qualifications. Only those applicants who most closely meet the needs of the Agency will be invited to participate in the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview. Qualified applicants with disabilities requiring reasonable accommodation in the selection process must contact the Agency by phone at (415) 554-6000 or, if hearing impaired at (415) 554-6015 (TTY).

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.