Senior Data Engineer - Public Safety Analytics (AWS)

City-of-Seattle; Seattle (WA); Hybrid; USD 178,399,000 - 267,658,000; Full time

Benefits offered by this job

Hybrid work model

Public transit benefits

Job summary

The City of Seattle is seeking a Senior Data Engineer to support the Seattle Police Department’s Data Analytics Platform (DAP) and related data systems. This role leads data engineering and data science collaboration to ensure scalable, secure analytics for public safety operations in an AWS analytics environment.

Responsibilities include building scalable data pipelines, improving observability, and guiding migration and architecture decisions across cloud and on-premises stores.

Qualifications

• 5+ years of experience with database technologies, SQL, scripting, and ETL/ELT/tools.
• 4+ years delivering data solutions: data warehouses, ODS, analytics models.
• 3+ years building reliable, observable data pipelines and CI/CD workflows.
• 3+ years designing large-scale analytics architectures with AWS cloud services.

Responsibilities

• Build and maintain scalable, secure data pipelines and ETL/ELT processes.
• Ensure pipeline observability, testability, reliability, and workflow automation via CI/CD and monitoring.
• Plan and implement improvements across AWS-based analytics systems and on-premises stores.
• Provide—AWS data resource provisioning, optimization, and cost management guidance.
• Collaborate with data scientists, architects, developers, and other teams to deliver data products.

Skills

Database proficiency

SQL & ETL

Data warehouse design

AWS cloud services

Agile tools (Jira/Confluence)

Education

Bachelor's degree in CS/IS

Tools

Oracle

SQL Server

PostgreSQL

AWS CloudFormation

S3

Glue

Python

Spark

Lambda

Athena

Job description

The City of Seattle is seeking a Senior Data Engineer to support the Seattle Police Department’s Data Analytics Platform (DAP) and related data systems. This role leads data engineering and data science collaboration to ensure scalable, secure analytics for public safety operations in an AWS analytics environment.

Responsibilities include building scalable data pipelines, improving observability, and guiding migration and architecture decisions across cloud and on-premises stores.