Data Analytics Engineer (Snowflake/dbt)

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

Job summary

The City and County of San Francisco, Controller’s Office, Systems Division seeks a Data Analytics Engineer to support the BI Platform Change project. You will develop reports, dashboards, data models, and ETL solutions for Oracle BI, with Snowflake as the target data warehouse.

You will collaborate with SF Reports & Analytics, functional teams and other City staff to analyze business processes and data needs, implement dbt-based transformations, and ensure data governance and security

Qualifications

• Associate degree or equivalent in computer science, information systems, or related field.
• 1 year of experience analyzing, installing, configuring, enhancing, or maintaining systems.
• Substitution options available for degree requirement with experience or trainee program.
• Extensive knowledge of OBIEE/OAS, ODI, BI Publisher, SQL, and data warehousing.
• Experience in RPD development, dashboards, performance tuning, and security implementation.
• Experience with Snowflake and cloud data platforms, dbt, and data pipelines.
• Strong SQL skills, data modeling, and ability to explain technical concepts to non-technical stakeholders.
• Familiarity with data governance, security, and privacy principles.

Responsibilities

• Analyze interrelationships of business processes and data to define reporting needs.
• Perform fit/gap analyses for reporting and data requirements.
• Develop and maintain OBIEE/OAS dashboards and BI Publisher reports.
• Design and enhance RPDs (Physical, BMM, Presentation).
• Support subject areas and metadata models; develop ETL solutions with ODI.
• Write technical documentation and manage risks across the SDLC.

Skills

Strong problem-solving

Verbal/written communication

Collaborative mindset

Equity and data ethics

Education

Associate degree in CS/IS/Engineering or related

Tools

OBIEE

OAS

ODI

BI Publisher

SQL

Data Warehousing

RPD development

Snowflake

dbt

GitHub

Orchestration tools

Oracle databases

PeopleSoft

Job description

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 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 supporting the current Oracle BI platform, but it will also collaborate in the building of the new business intelligence platform using tools such as dbt, SQL, and other tools with a Snowflake data warehouse source and target.

Essential duties include but are not limited to:

• Analyze the interrelationships of business processes, complex financial data, human resources data, and systems to develop reporting requirements and data structures.
• Perform fit/gap analysis to evaluate reporting and data needs.
• Develop and maintain OBIEE/OAS dashboards, analyses, and BI Publisher reports.
• Design and enhance RPDs (Physical, BMM & Presentation Layers).
• Support Subject Areas, Logical Table Sources (LTS), and metadata models.
• Develop ETL solutions using ODI, perform query optimization, cache management, and performance tuning, support production issues, enhancements, and troubleshooting activities
• Write business and system process and technical documentation.
• Identify, manage and upscale issues and risks throughout software development life cycle.
• Performing other duties as assigned.

MINIMUM QUALIFICATIONS

Education

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].

Experience

One (1) year of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of a system or platform.

Substitution

One year of additional experience as described above may be substituted for the required degree; or Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

DESIRABLE QUALIFICATIONS

Technical Knowledge

• Working expertise in OBIEE, OAS, ODI, BI Publisher, SQL, and Data Warehousing.
• Hands-on experience in RPD development, dashboard creation, performance tuning, security implementation
• One (1) 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.
• One (1) year of hands-on experience administering and developing on Oracle databases and experience with Snowflake managed cloud data platform
• One (1) years of Demonstrated expertise in writing advanced, performant SQL, using 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
• Experience in building and deploying data pipelines using orchestration tools
• Understanding the process to build and deploy data pipelines using orchestration tools
• 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), PeopleSoft Capital Human Resources (HCM) experience performing data analysis, design and testing.
• Working with DBAs, BI Development team, 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.

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