Data Analytics Engineer (Snowflake/DBT) (1042) - Controller's Office - (168329)
Core
IS Engineer supporting a multi-year migration of the Controller's Office reporting solution to a unified Snowflake-based platform, replacing Oracle BI and PeopleSoft data sources.
Role type
Senior IC Data Analytics Engineer (BI Platform Migration)
Builds
Unified Snowflake data warehouse, dbt data models, and OBIEE/OAS dashboards for citywide financial and HR reporting.
Domain
Public sector finance, government data governance, and cloud data warehousing.
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL, Snowflake, dbt, Oracle BI (OBIEE/OAS), ODI, PeopleSoft (FSCM/HCM), data modeling, ETL, performance tuning, GitHub
Preferred skills
Agile methodology, data pipeline orchestration, Jinja templating, data governance principles
Responsibilities
Analyze interrelationships of complex financial and HR data to develop reporting requirements; Perform fit/gap analysis for data needs; Design and enhance RPDs and metadata models; Develop ETL solutions and optimize query performance; Write technical and business process documentation; Collaborate with DBAs, security teams, and functional groups to improve data quality.
Seniority
Mid-level, hands-on IC