Senior Data Analytics Engineer | Snowflake/DBT Expert

City and County of San Francisco; California (MO); On-site; USD 159,000 - 200,000; Full time

Job summary

The City and County of San Francisco's Controller’s Office seeks a Senior Technology Engineer to support the BI Platform Change project, migrating Reports and Analytics to a Snowflake-based platform. You will collaborate with SF Reports & Analytics Team, functional teams, and city staff to design, build, and support the new BI ecosystem.

The role emphasizes data extraction/transform, governance, security, testing, and user training, using tools like dbt, SQL, and Snowflake to deliver scalable

Qualifications

• Associate degree or equivalent in CS/CE/IS or a closely related field.
• Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining system components.
• One or more substitution options described in the job ad may apply.

Responsibilities

• Exercise judgement and design large, complex systems or data integrations.
• Analyze business processes and financial data to inform reporting requirements.
• Develop and test security roles and permissions; design and build solutions per specs.
• Write functional and technical specifications and documentation.
• Provide user training and create system/process documentation.

Skills

Analytical thinking

Problem solving

Communication

Collaboration

Public service mindset

Education

Associate degree in computer science, computer engineering, information systems, or closely related field

Tools

Snowflake

dbt

SQL

Python

GitHub

Oracle databases

Job description

The City and County of San Francisco's Controller’s Office seeks a Senior Technology Engineer to support the BI Platform Change project, migrating Reports and Analytics to a Snowflake-based platform. You will collaborate with SF Reports & Analytics Team, functional teams, and city staff to design, build, and support the new BI ecosystem.

The role emphasizes data extraction/transform, governance, security, testing, and user training, using tools like dbt, SQL, and Snowflake to deliver scalable