City and County of San Francisco’s DataSF team is hiring a hands-on Data Engineer to bring department data onto the Unified Data Platform.

Build and maintain production data pipelines that move department data onto the platform, including tests and documentation for ongoing maintainability by others.
Develop data models in dbt on Snowflake to transform raw department data into clean, well-documented tables used by City analysts.
Create financial and budget data products using the City’s financial and workforce systems to support migration off legacy reporting and deliver accurate budgeting and planning numbers.
Support platform cost and usage reporting so the team and partner departments can understand platform expenses and resource usage.
Assist with transitioning publishing workflows from legacy systems onto the Unified Data Platform, including public-facing open data feeds.
Investigate and resolve data quality issues by tracing errors to source, fixing problems, and adding tests to prevent recurrence.
Support department onboarding by helping analysts understand and use the models you build.
Participate in code review and grow into reviewing others’ code as experience increases.

Associate degree in computer science, computer engineering, information systems, or a closely related field from an accredited college or university, or equivalent in total course credits/units (at least 60 semester or 90 quarter credits/units), with a minimum of 20 semester or 30 quarter credits/units in one of the listed fields.
1 year of experience analyzing, installing, configuring, enhancing, and/or maintaining components of a system or platform.
Additional 1 year of experience as described above may substitute for the required degree.
Completion of the 1010 Information Systems Trainee Program may substitute for the required degree.

Experience building real data-moving or data-transforming projects (job, internship, or personal), including ability to explain design and challenges encountered.
Ability to write SQL and familiarity with at least one programming language, ideally Python.
Strong attention to numerical accuracy and instinct for recognizing when data doesn’t look right.
Plus: experience with financial, budget, or ERP data and familiarity with dbt, Snowflake, or Terraform.
Strong potential and intuition working with data, with ability to learn new tools and the platform stack on the job.

Application opening: Wednesday, September 23, 2026.
Application deadline: Wednesday, September 30, 2026 at 11:59pm PST.
Required supplemental questionnaire: due at time of application: https://forms.cloud.microsoft/g/r5AP7vN0qM.
Permanent Exempt (PEX): Full Time role excluded by the Charter from competitive civil service examination; serves at the discretion of the appointment officer.
Project duration: anticipated thirty-six (36) months; project-based positions cannot be ongoing or exceed 36 months, and will not create an eligible list or lead to permanent civil service hiring.
Minimum qualifications are evaluated by the final filing date; applications are reviewed to confirm you meet the minimum qualifications listed in the job ad.
One-year full-time employment is treated as 2000 hours (based on a 40 hour work week); overtime beyond 40 hours per week is not included in the calculation.
Qualified applicants are required to complete subsequent steps to advance, including the supplemental questionnaire at the time of application.
Applicants may be asked to provide verification of qualifying education and experience at any point in the application or selection process.

Data Engineer (1042) - Data Enablement

Job Description