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

City and County of San Francisco•San Francisco, CA

4d•Onsite

About The Position

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.

Requirements

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].
One (1) year of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of a system or platform.
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.
One-year full-time employment is considered equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40-hour work week).
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 models using 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.
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
Commitment to equity, transparency, and ethical data use
Passion for public service using data to improve government services

Responsibilities

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.