Cityofphiladelphia

Data Architect / Quality Assurance Engineer

Philadelphia, PA, United States · Part-time

Sponsorship not specifiedDetected 9 days ago

PythonGitSQLPostgreSQLCI/CDAPI DevelopmentOpenAPIAirflowdbtData AnalysisData EngineeringData ScienceAI OrchestrationGISProblem Solving

About the role

With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else.
If you're interested in working with a passionate team of people who care about the future of Philadelphia, start here.

The position will support priority departmental and enterprise modernization efforts, while also contributing to broader enterprise data architecture and data quality work across CityGeo's portfolio.
Lead data discovery and requirements-gathering sessions with departments, programs, vendors, and
Develop data contracts, schema standards, field definitions, validation rules, and acceptance criteria for

Ability to understand business processes and translate them into data models, rules, and technical
Ability to work across multiple domains, departments, systems, and stakeholder groups.
Ability to balance governance, quality, delivery, and operational practicality.
Ability to identify patterns, inconsistencies, risks, and opportunities for standardization.

Five or more years of progressively responsible experience in data architecture, data engineering,
or a related role.
Demonstrated experience designing data models, documenting data definitions, analyzing source
systems, or creating validation frameworks.

Strong SQL skills and experience working with relational databases, preferably Postgres and PostGIS.
Experience defining data quality rules, validation checks, test cases, acceptance criteria, and QA workflows.
Experience working with Python, DBT, SQL-based testing, automated QA frameworks, or data validation tools is preferred.
Familiarity with ETL/ELT pipelines, data warehouses, data lakes, integration platforms, and workflow orchestration tools such as Airflow.
Experience with Git/GitHub, CI/CD practices, and modern data engineering workflows
Experience working in a public-sector, civic technology, or large enterprise environment is a plus.
To communicate data architecture and quality concepts in understandable terms.
To work effectively with technical and non-technical staff across departments.
To promote consistency, trust, and accountability in the City's enterprise data ecosystem.
Bachelor's degree or advanced degree in Computer Science, Information Systems, Data Science,
Data Analytics, GIS, Public Policy, Engineering, or a related field.
Equivalent work experience may be

We are looking for a candidate who can bridge business process analysis, data architecture, quality assurance, and practical implementation.

This listing is sourced directly from Cityofphiladelphia's careers page and normalized into a canonical job model.