Data Engineer: Platform & Open Data (Snowflake/dbt)

City-and-County-of-SAN-Francisc; San Francisco (CA); On-site; USD 140,000 - 180,000; Full time

Job summary

City and County of San Francisco is seeking a Data Engineer to join DataSF's Data Enablement team. You will build and maintain production data pipelines, transform raw data using dbt on Snowflake, and help transition publishing workflows to the platform.

The role emphasizes data accuracy and hands-on execution with mentorship from senior engineers. The position requires technical capabilities, the ability to learn quickly, and a commitment to delivering reliable data for city services and open

Qualifications

• Associate degree in computer science, computer engineering, information systems, or closely related field or equivalent (60+ credits with relevant coursework).
• 1 year of experience analyzing, installing, configuring, enhancing, and/or maintaining system components.
• One year of additional experience may substitute for the degree; 1010 IS Trainee Program may substitute for degree.

Responsibilities

• Build and maintain production data pipelines with tests and documentation.
• Develop dbt data models transforming raw data into clean tables used by analysts.
• Create financial and budget data products to support budgeting and planning.
• Support platform cost and usage reporting for departments.

Skills

SQL

Data modeling

Data pipelines

Education

Associate degree in CS/IS or related

Tools

dbt

Snowflake

Terraform

Python

Job description

City and County of San Francisco is seeking a Data Engineer to join DataSF's Data Enablement team. You will build and maintain production data pipelines, transform raw data using dbt on Snowflake, and help transition publishing workflows to the platform.

The role emphasizes data accuracy and hands-on execution with mentorship from senior engineers. The position requires technical capabilities, the ability to learn quickly, and a commitment to delivering reliable data for city services and open