Data Analytics Engineer: Snowflake/dbt, Onsite in SF

DataJobs; San Francisco (CA); On-site; USD 144,000 - 181,000; Full time

Job summary

DataJobs seeks an analytics professional to join the City and County of San Francisco's BI Platform Change project, delivering dashboards, reports, ETL, and data models on an onsite basis. You will collaborate across teams to improve performance and data quality, supporting OBIEE/OAS, Snowflake, and dbt implementations.

The role emphasizes data governance, documentation, and ongoing production support, with a focus on accurate reporting for complex financial and HR datasets within a unified

Qualifications

• Associate degree in computer science, computer engineering, information systems, or closely related field with at least 60 credits in one of the listed areas.
• One year of experience analyzing, installing, configuring, enhancing, and/or maintaining system components.
• Additional experience may substitute for the degree, or completion of the 1010 Information Systems Trainee Program may substitute for the required degree.

Responsibilities

• Analyze interrelationships across business processes, complex financial data, human resources data, and systems to define reporting requirements and data structures.
• Conduct fit/gap analysis to evaluate reporting and data needs.
• Develop and maintain OBIEE/OAS dashboards, analyses, and BI Publisher reports.
• Design and enhance RPDs, including the Physical, BMM & Presentation Layers.
• Build ETL solutions using ODI, including query optimization, cache management, and performance tuning, plus production support, enhancements, and troubleshooting.

Skills

Analytical thinking

Verbal & written communication

Collaboration

Public service/data ethics

Education

Associate degree in CS/CE/IS or related

60/90 credits with field study

1010 Information Systems Trainee Program alternative

Tools

Snowflake

dbt

SQL

OBIEE

OAS

BI Publisher

RPDs (Physical, BMM & Presentation)

LTS & Subject Areas

ODI

Oracle databases

Jinja templating

GitHub

PeopleSoft (HCM, FSCM, ELM)

Oracle BI/Interaction Hub/Identify & Access

Control-M/FreshWorks/Sh...

Job description

DataJobs seeks an analytics professional to join the City and County of San Francisco's BI Platform Change project, delivering dashboards, reports, ETL, and data models on an onsite basis. You will collaborate across teams to improve performance and data quality, supporting OBIEE/OAS, Snowflake, and dbt implementations.

The role emphasizes data governance, documentation, and ongoing production support, with a focus on accurate reporting for complex financial and HR datasets within a unified