Senior Data Analytics Engineer (Snowflake/dbt)

Office of the Controller, San Francisco; San Francisco (CA); On-site; USD 150,000 - 190,000; Full time

Job summary

City and County of San Francisco, Controller's Office, is hiring a Senior Data Analytics Engineer to drive the BI Platform Change project. You will design and implement data models, dashboards, and data pipelines on Snowflake using dbt and SQL.

Lead collaboration with SF Reports & Analytics and other City staff, ensuring secure, scalable data access, governance and reliable analytics across departments.

Qualifications

• Three+ years in information systems, business processes, or IT project management.
• Hands-on Snowflake administration and development experience.
• Proficient in writing advanced SQL and using dbt for data transformation.
• Experience with layered data architecture for analytics and reporting.

Responsibilities

• Design, build, and manage the new BI platform post-migration.
• Develop reports, queries, dashboards, and data extracts.
• Model metadata and tune performance across Snowflake environments.
• Collaborate with cross‑functional teams and document specifications.

Skills

SQL

dbt

Snowflake

Python

Data modeling

ETL/ELT design

GitHub

Data governance

Tools

dbt

Snowflake

Job description

Read Full Job Posting Here: Senior Data Analytics Engineer (Snowflake/DBT) (1043) - Controller's Office - (168332) | City and County of San Francisco

• Application Opening: 9/25/2026
• Application Deadline: May close anytime but no sooner than Friday, 10/16/2026 at 5:00PM (PDT).

WHO WE ARE:

The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence. These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems. Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications. The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers). Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and FreshWorks. The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes. Users are fully supported to ensure adoption of these interconnected systems.

Business Intelligence Platform Change Project

The Controller’s Office is working in a multi-year project to migrate the Reports and Analytics solution into a unified Snowflake-based platform. The BI Platform Change will provide departments with secure, streamlined access to PeopleSoft data, improving efficiency, governance, and standardizing data sharing citywide. By replacing outdated processes, this modern framework supports transparency, accountability, collaboration, better service delivery, strategic growth, and public trust.

Job Description:

This Senior Data Analytics Engineer position will be part of the BI Platform Change project and will work with members of the SF Reports & Analytics Team, Functional Teams and other City and County staff to support the project. The analyst will perform both functional (business process and systems analysis) and technical (report, query and dashboard development, data extract, load and transformation, metadata modeling, tuning, and troubleshooting) tasks.

This position will be instrumental in designing, building, and managing the new business intelligence platform using tools such as dbt, SQL, and other tools with a Snowflake database source and target.

Essential duties include but are not limited to:

• Exercise judgement, decisiveness and creativity in designing, planning, troubleshooting and integration of large complex systems or networks based on the potential benefits and/or consequences.
• Analyze the interrelationships of business processes, complex financial data and systems to develop reporting requirements and data structures.
• Perform fit/gap analysis to evaluate reporting and data needs.
• Define and implement application configuration settings.
• Collaborate with the project team on transition plans for re-engineered business processes.
• Analyze and test security roles and permissions.
• Write functional and technical specifications.
• Design and build solutions based on detailed specifications.
• Develop and execute system and user acceptance test plans and evaluating test results.
• Develop and provide support and training for users in person, on the phone and in workshops.
• Write business and system process and technical documentation.
• Identify, manage and elevate issues and risks throughout software development life cycle.
• Perform other duties as assigned.

DESIRABLE QUALIFICATIONS:

Technical Knowledge

• Three (3) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.
• Two (2) years of hands‑on experience administering and developing on Snowflake managed cloud data platform and with Oracle databases
• Two (2) years of Demonstrated expertise in writing advanced, performant SQL, and using dbt for SQL-based data transformation and modeling
• Experience with layered data architecture (staging, intermediate, marts) using dbt best practices to support analytics and reporting use cases including parameterized and dynamic dbt modelsusing Jinja templating to support reusable transformations across multiple datasets and environments
• Hands‑on experience in GitHub for code change management and collaboration with other team members
• Hands on experience with Snowflake data warehouse functionality including Snowflake masking native features, Snowpipe, SnowSQL, Snowpark and Snowflake optimization configuration
• Strong skills in Python (with libraries like pandas, PySpark) for data processing and automation
• Experience in building and deploying data pipelines using orchestration tools
• Hands‑on experience in real‑time data streaming technologies (Snowpipe, GoldenGate)
• Experience building and deploying data pipelines using orchestration tools
• Experience with CI/CD & DevOps a plus
• Experience in development of APIs to interface PeopleSoft data with other enterprise applications
• Deep understanding of data warehouse concepts, data modeling, and modern ETL principles
• Understanding of data governance, data security, and data privacy principles
• Understanding of PeopleSoft applications such as PeopleSoft Financials and Supply Chain Management (FSCM) or PeopleSoft Capital Human Resources (HCM) experience performing data analysis, design and testing.
• Understanding of OBIA 11g (with ODI 11g), including the following:
• Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Human Resources, Position Management, Time and Labor, Payroll)
• Working with DBAs, BI Dev, PeopleSoft, and Security teams to improve performance and data quality using Agile sessions
• Working knowledge of business process flows used to support a complex accounting system, and experience in developing and executing application test plans.
• Desirable experience of building AI agents

Collaboration and Communication Skills

• Strong problem-solving skills with ability to design practical and effective data solutions
• Excellent verbal and written communication skills, including the ability to explain technical concepts to non-technical stakeholders
• A collaborative mindset with enthusiasm to work across diverse, cross-functional teams

Mission alignment

• Commitment to equity, transparency, and ethical data use
• Passion for public service using data to improve government services