Data Analytics Engineer (Snowflake/DBT) (1042) - Controller's Office - (168329)

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 IS 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 escalate issues and risks throughout software development life cycle.

• Performing other duties as assigned.