Data Engineer - Administrative Special Services Staff III - Exempt (ARPA)

$110,000 - $120,000/Yr

City Of Detroit - Detroit, MI

Full-time - Mid Level

Remote - Detroit, MI

Executive, Legislative, and Other General Government Support

About the position

The City of Detroit's Housing and Revitalization Department is seeking a Data Engineer to design and build a CRM for the public sector. This role involves managing data pipelines, integrating diverse datasets, and facilitating data-led decision-making within a collaborative team environment.

Responsibilities

• Build, design, and maintain database and CRM.
• Contribute directly to pipeline development and database modelling.
• Develop scripts to clean and integrate data.
• Design data schemas and database architecture.
• Develop work issues and delegate to other team members as needed.
• Meet with team members to ensure alignment and technical feasibility.
• Identify and implement ways to track and manage data quality.
• Develop new data sources and associated reporting with team members.

Requirements

• Bachelor's degree in computer science, data science, information management, or database administration.
• 3-4 years of experience in systems analysis, computer science engineering, programming, information security management, data analysis, information science, or geographical information systems analysis is preferred but not required.
• 5+ years of experience with Data Warehousing: proven relational database design & build, preferably in a social services agency context.
• 1-2 years of experience with human services type data.
• Skills in both Python and SQL (ideally PostgreSQL).
• Experience with a pipeline/job scheduling/orchestration framework (Airflow, Prefect).
• Experience integrating large disparate data sources in a variety of formats.
• Experience working with REST APIs as a data source.
• Experience with a cloud data warehouse such as Snowflake or BigQuery in a large organization.