Senior Data Engineer, Public Safety Analytics Platform

City of Seattle

Seattle (WA)

Hybrid

USD 85,000 - 128,000

Full time

7 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work schedule

Public transportation

Competitive benefits

Job summary

The City of Seattle Information Technology (IT) Department 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 projects across AWS-based analytics, ensuring secure, scalable solutions for high-visibility public safety reporting and analytics.

You will collaborate with data scientists, architects, and stakeholders to deliver reliable data products, oversee pipeline observability and

Qualifications

Bachelor's degree in computer science, business information systems, database management or a related degree (or an equivalent combination of experience).
5+ years with database technologies, SQL, scripting, performance optimization, scheduling, and integration tools such as Oracle, SQL Server, PostgreSQL, scripting, ETL/ELT tools, scheduling, and integration frameworks.
4+ years delivering data solutions that support business and operational needs, including data warehouses, operational data stores, and analytics models.
3+ years designing reliable, observable, and testable data pipelines with automation, CI/CD and workflow orchestration.
3+ years designing architectures for large-scale analytics on AWS (CloudFormation, S3, Glue, Python, Spark, Lambda, Athena); building cloud-based data warehouses and data migrations.
Experience with Agile tools: Jira, Confluence, SharePoint, Teams.

Responsibilities

Build and maintain scalable, secure, high-performance 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, on-premises data stores, and analytical models.
Provision, manage, and optimize AWS data resources.
Collaborate with data scientists, architects, developers, and other technical teams to deliver well-engineered data products.
Develop clear documentation for pipelines, architecture, and data models.
Review code, mentor teammates, and support skill development.
Define and enforce standards for schema evolution, versioning, and data quality.
Monitor and remediate security vulnerabilities identified by AWS Inspector.
Research and recommend future-state analytics solutions, evaluating feasibility, cost, business value, and resource impacts for leadership.