Senior Data Analytics Engineer (Snowflake/DBT) (1043) - Controller's Office - (168332)
Core
Design, build, and manage a unified Snowflake-based Business Intelligence platform to migrate PeopleSoft data, enabling secure, streamlined access for city departments.
Role type
Senior Data Analytics Engineer (Snowflake/DBT)
Builds
A modern, unified BI platform replacing outdated reporting solutions for citywide data sharing.
Domain
Public sector / Government Finance & Accounting
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL, dbt for data transformation, Snowflake data warehouse administration, Python (pandas, PySpark), GitHub, CI/CD, PeopleSoft (FSCM/HCM), OBIA 11g, data modeling, ETL principles
Preferred skills
Real-time data streaming (Snowpipe, GoldenGate), API development, Agile methodology, AI agent development
Technologies
Snowflake, dbt, SQL, Python, pandas, PySpark, GitHub, PeopleSoft, OBIA 11g, Oracle ODI
Responsibilities
Design and implement application configuration settings; analyze interrelationships of business processes and financial data; write functional and technical specifications; develop and execute system and user acceptance test plans; provide user training and support; write business and system process documentation; identify and manage issues and risks throughout the software development life cycle.
Seniority
Senior, hands-on IC
