Data Architect / Quality Assurance Engineer
Core
Define, document, and improve data models, standards, validation frameworks, and quality assurance practices for the City's enterprise data integration ecosystem.
Role type
Senior Data Architect / Quality Assurance Engineer
Builds
Enterprise data models, data contracts, validation rules, metadata, quality checks, and architectural guardrails for City data products.
Domain
Municipal government / Data Architecture & Quality Assurance
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Data modeling, database design, SQL, data quality rule definition, API design, data governance, metadata management, stakeholder analysis
Preferred skills
Python, DBT, Airflow, spatial datasets, public-sector experience
Technologies
SQL, Postgres, PostGIS, Python, DBT, Airflow, Git, GitHub, OpenAPI
Responsibilities
Lead data discovery and requirements-gathering sessions; Design conceptual, logical, and physical data models; Define reusable data architecture patterns and naming conventions; Develop data contracts and validation rules; Establish systematic data quality checks; Work with data engineers to implement automated validation workflows; Review integration designs and pipeline logic; Identify and document data quality issues; Develop quality assurance processes for releases; Support metadata management and data lineage; Partner with data stewards and security teams; Produce clear documentation and quality reports.
Seniority
Senior, hands-on IC with strategy & mentorship