Data Engineer (1042) - Data Enablement - DataSF, Office of City Administrator
About The Position
The Data Engineer will be part of DataSF's data enablement practice, which assists City departments in integrating their data onto the platform and utilizing it effectively. This role involves building and maintaining production data pipelines, developing and testing data models using dbt on Snowflake, and migrating publishing workflows from older systems to the current platform. The position offers mentorship from senior engineers and collaboration with department analysts to understand data sources. It is a hands-on engineering role that values practical experience in building projects, a strong commitment to data accuracy, and the ability to learn quickly, rather than requiring extensive years of experience.
Requirements
- An associate degree in computer science, computer engineering, information systems, 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 one of the fields above or a closely-related field].
- One (1) year of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of a system or platform.
- Ability to write SQL and familiarity with at least one programming language, ideally Python; strong attention to numerical accuracy and instinct for identifying when data doesn’t look right.
Nice To Haves
- Experience building real data-moving or data-transforming projects—whether from a job, internship, or personal work—and the ability to explain how they were designed and what challenges arose.
- Experience with financial, budget, or ERP data is a plus, as is familiarity with dbt, Snowflake, or Terraform.
- Strong potential and intuition working with data, with the ability to learn new tools and the platform stack on the job.
Responsibilities
- Build and maintain production data pipelines that bring department data onto the platform, complete with tests and documentation so they can be run and maintained by others.
- Develop data models in dbt that transform raw department data into clean, well-documented tables relied on by analysts across the City.
- Create financial and budget data products—models built on the City’s financial and workforce systems that support migration off legacy reporting and provide departments with accurate numbers for budgeting and planning.
- Support platform cost and usage reporting so the team and partner departments can understand platform expenses and how resources are used.
- Help transition publishing workflows from legacy systems onto the platform, including public-facing open data feeds.
- Investigate and resolve data quality issues by tracing errors to their source, fixing problems, and adding tests to prevent future occurrences.
- Support department onboarding by helping analysts understand and use the models you build.
- Participate in code review and grow into reviewing others’ code as your experience increases.
Benefits
- Employee Benefits Overview
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Education Level
Associate degree
