Data Engineer — Open Data Platform (Hybrid)

City and County of San Francisco; San Francisco (CA); Hybrid; USD 140,000 - 190,000; Full time

Job summary

City and County of San Francisco is hiring a Data Engineer to join DataSF. You will build and maintain production data pipelines, develop data models in dbt on Snowflake, and help migrate publishing workflows to the unified platform. The role requires hands-on coding, data accuracy, and collaboration with analysts and senior engineers.

The team emphasizes a hybrid work schedule and improving city data infrastructure to power data-driven city services and transparency.

Qualifications

• Associate degree or equivalent in CS/IS/Engineering or related field.
• At least 1 year of experience analyzing, configuring, or maintaining data systems.
• Completion of the 1010 Information Systems Trainee Program may substitute for the degree.
• Overtime hours are not counted toward full-time employment calculation.
• Familiarity with SQL and at least one programming language (e.g., Python).

Responsibilities

• Build and maintain production data pipelines with tests and docs.
• Develop dbt models transforming raw data into clean tables for analysts.
• Create financial and workforce data models to support budgeting and planning.
• Support platform cost and usage reporting for departments.
• Help transition publishing workflows to the platform, including open data feeds.
• Investigate data quality issues and add tests to prevent recurrences.
• Assist analysts onboarding by explaining the models and usage.
• Participate in code reviews and grow as a reviewer.

Skills

SQL

Python

Data pipelines

Education

Associate degree in CS/CE/IS

Tools

dbt

Snowflake

Terraform

Job description

City and County of San Francisco is hiring a Data Engineer to join DataSF. You will build and maintain production data pipelines, develop data models in dbt on Snowflake, and help migrate publishing workflows to the unified platform. The role requires hands-on coding, data accuracy, and collaboration with analysts and senior engineers.

The team emphasizes a hybrid work schedule and improving city data infrastructure to power data-driven city services and transparency.