Data Engineer (1042) - Data Enablement - DataSF, Office of City Administrator
Core
Build and maintain production data pipelines, develop data models in dbt on Snowflake, and transition publishing workflows from legacy systems to the platform for City departments.
Role type
Data Engineer
Builds
Production data pipelines, data models, financial and budget data products, open data feeds
Domain
Public sector / Municipal government / Data engineering
Deliverable
production ML models | product features
Required skills
SQL, Python, dbt, Snowflake, data pipeline development, data modeling, data quality testing, legacy system migration
Preferred skills
Financial/budget/ERP data experience, Terraform, data product design
Responsibilities
Build and maintain production data pipelines with tests and documentation; Develop data models in dbt to transform raw department data; Create financial and budget data products; Support platform cost and usage reporting; Transition publishing workflows from legacy systems; Investigate and resolve data quality issues; Support department onboarding by helping analysts use models
Seniority
Junior to Mid-level, hands-on IC
