Senior Data Analytics Engineer (Snowflake/DBT) (1043) - Controller's Office - (168332)

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

• Perform other duties as assigned.