Enterprise Data Architect & Quality Assurance Engineer

City of Philadelphia; Philadelphia (Philadelphia County); Presencial; USD 94.500 - 115.500; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Comprehensive health coverage

Public transit benefits

Retirement options

Descripción de la vacante

City of Philadelphia is seeking a Data Architect / Quality Assurance Engineer to define and improve enterprise data models, standards, validation rules, and QA practices across departments and systems. This role focuses on data contracts, metadata, and quality checks to ensure data is trustworthy, reusable, and scalable.

The position collaborates with data engineers to implement automated validation, supports governance documentation, and helps drive modernization efforts across CityOpen data

Formación

• Bachelor’s or advanced degree in Computer Science, Information Systems, GIS, Engineering, or related field.
• Five or more years of progressively responsible experience in data architecture, data engineering, or data governance.
• Strong SQL and relational database experience (Postgres is preferred).
• Experience with data quality, validation, and QA workflows.
• Familiarity with API design and data contracts (OpenAPI, JSON schemas).

Responsabilidades

• Lead data discovery sessions with departments and technical teams to understand data quality concerns.
• Design data models (conceptual to physical) for enterprise integrations and APIs.
• Define data standards, contracts, and data quality checks.
• Develop QA workflows and automated validation with SQL, Python, or DBT tests.
• Document data lineage, dictionaries, and governance artifacts.

Conocimientos

Strong SQL skills

PostgreSQL/PostGIS

Data modeling

Data governance

API design

Educación

Bachelor’s or advanced degree in CS/IS/GIS/Engineering

5+ years data architecture/engineering experience

Herramientas

Airflow

DBT

Git/GitHub

Open data tooling

Descripción del empleo

City of Philadelphia is seeking a Data Architect / Quality Assurance Engineer to define and improve enterprise data models, standards, validation rules, and QA practices across departments and systems. This role focuses on data contracts, metadata, and quality checks to ensure data is trustworthy, reusable, and scalable.

The position collaborates with data engineers to implement automated validation, supports governance documentation, and helps drive modernization efforts across CityOpen data