Enterprise Data Architect & Quality Assurance Engineer

City of Philadelphia; Philadelphia (Philadelphia County); On-site; USD 94,500 - 115,500; Full time

Benefits offered by this job

Comprehensive health coverage

Public transit benefits

Retirement options

Job summary

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

Qualifications

• 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).

Responsibilities

• 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.

Skills

Strong SQL skills

PostgreSQL/PostGIS

Data modeling

Data governance

API design

Education

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

5+ years data architecture/engineering experience

Tools

Airflow

DBT

Git/GitHub

Open data tooling

Job description

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