Data Engineer
Core
Design, develop, and maintain database management systems, data integration solutions, and custom applications to support the Department of Sanitation's Operations Management Division.
Role type
Data Engineer
Builds
Enterprise data pipelines, data models, and analytical solutions for municipal operations
Domain
Municipal government / Data Engineering
Required skills
SQL, Python, Data Modeling, ETL Development, Database Design, Data Analysis, Data Profiling, Source-to-Target Mapping
Preferred skills
PySpark, Microsoft .NET, Java, Data Warehousing, Cloud Platforms
Technologies
Databricks, Informatica PowerCenter, Pentaho Data Integration, Oracle Business Intelligence Enterprise Edition, Power BI, Tableau
Responsibilities
Develop and maintain SQL-based data solutions including complex queries and stored procedures; Collaborate with stakeholders to design and support complex data integration pipelines; Analyze legacy systems to assess data quality and recommend corrective actions; Develop and maintain technical documentation including data dictionaries and ETL specifications; Support business intelligence initiatives through development of reports and dashboards; Participate in the design of innovative data architecture strategies.
Seniority
Mid-Senior level