Profile cover
S

AI County Data Format Normalization Engineer

Samuel Pham

Part-time · Job · Chicago

About the role

Our mission is to make civic data reliable enough that the public officials and journalists who use it can actually trust it. Right now our open data pipelines ingest budget, procurement, and permitting records from dozens of counties, each publishing in a different spreadsheet layout, date format, or field naming convention. This role focuses on building the normalization layer that maps every county's quirks onto one consistent internal schema before the data reaches our public-facing tools. It's part-time, flexible, and ideal for someone who cares about civic tech but doesn't need a full-time commitment right now.

Responsibilities

  • Map inconsistent county-level formats onto a shared internal schema
  • Build normalization rules for dates, identifiers, and field naming
  • Document known format quirks for each county source
  • Work with ETL pipelines to standardize incoming public records data
  • Flag county sources whose format changes without notice

Requirements

  • 2+ years of experience with data normalization or ETL work
  • Strong SQL and Python skills
  • Comfortable working with messy, inconsistently formatted public data
  • Interest in civic tech or public sector data
  • Able to commit 20 hours per week

Benefits

  • Fully remote, part-time schedule
  • Flexible hours that fit around other commitments
  • Hourly pay at a competitive rate
  • Opportunity to work on genuinely public-interest data
  • Path to increased hours over time

Keep exploring related roles

Use these topic pages to discover more roles in the same hiring cluster.

Categories

data science & analytics

Skills

python sql pandas etl

Related remote AI jobs

Nearby roles that share similar skills, categories, or hiring intent.

Browse all jobs

Senior Autonomy Engineer, Data Curation

RemoteAI company

Full-time Senior

Backend Engineer, Platform

RemoteAI company

Full-time

Technical Writer

RemoteAI company

Part-time

Software Engineer, Applications (Scientific Development Solutions) (High Seniority)

RemoteAI company

Full-time Senior

PhD Autonomy Engineer Intern - Computer Vision / Deep Learning Summer 2027

RemoteAI company

Full-time Intern

Drone Platform Integration & Network Support Engineer

RemoteAI company

Full-time

Job Type

Part-time

Level

Junior

Language

English

Salary Range

Under $60k / year

AI Expertise

data science & analytics

Skills

python sql pandas etl

Ready to apply for this role?

Create a free talent account in under 2 minutes.

  • Apply to verified AI companies
  • Get AI-matched job recommendations
  • Message hiring managers directly
  • Build your public AI talent profile
Create free account & apply Log in

Interested in this role? Create your free profile to apply.

Apply — create free profile