Haystack
← Back to Jobs
Other
CI

Data Engineering Lead

CitianWashington D.C.🇺🇸United StatesPosted Oct 13, 2026

Why This Role Stands Out

As a Data Engineering Lead at Citian, you will drive innovation in transportation technology by building and optimizing data pipelines, working with AI-first approaches to enhance efficiency and data quality. This hybrid role is perfect for a hands-on leader who thrives in a collaborative environment, enjoys mentoring a team, and is passionate about leveraging data to create safer and smarter infrastructure. You will have the opportunity to grow your leadership skills while making a tangible impact on critical transportation systems.

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Washington D.C., United States
Posted
7 hours ago
SQLAWSMachine LearningSOC 2SnowflakeAirflowBigQueryCustomer SuccessDatabricksGISOnboardingPostgreSQLPythonRedshiftdbt

Job Description

Citian is a fast growing, venture backed SaaS technology company based in Washington, DC. Our software solutions revolutionize how our transportation and infrastructure systems – roads, rail, transit, bicycle, pedestrian – operate.

Our tech solutions:

  • Reduce traffic fatalities
  • Enhance pedestrian accessibility
  • Empower system operators to save time & money

You’ll work with some of the brightest minds in the software and transportation industries. Our engineers and data scientists apply the latest in emerging tech, Artificial Intelligence, and Machine Learning to build smarter, more advanced tools for our diverse client base. We work with clients across the United States, with global ambitions in the years ahead.

Who You Are:

You're a data engineering leader who still builds. You'll lead Citian's data engineers and own how crash, roadway and asset data gets from client systems into CRASH and ADAPT: reliably, accurately, and fast enough to keep up with new clients. You work AI-first: you use coding agents to build and test pipelines, you put AI to work on the repetitive mapping, cleaning and checking that slows onboarding today, and you stay accountable for the data that ships. You're a self-starter who works well with data science, GIS, software engineering and customer teams, and you're in the office multiple times a week.

Expected Duties:

  • Lead and grow the data engineering team: set priorities, review work, mentor, and hire.
  • Set how the team works with AI agents, and measure whether it improves onboarding speed and data quality.
  • Design, build and run data pipelines that are reliable, observable and recoverable, with alerts when a run fails or doesn't happen.
  • Make client onboarding repeatable with standard ingestion, cleaning and mapping, so several onboardings can run in parallel.
  • Apply AI to data work, such as assisted schema mapping, cleaning and anomaly detection, with checks that verify its output.
  • Make data repositories agent-ready (clear context files, reliable build and test commands, checks agents can run) and build reusable skills and agents the team can share.
  • Define data quality with product, data science and customer success, and build automated checks that measure it.
  • Own data models and multi-tenant schemas, and bring client schemas onto a consistent standard.
  • Work with GIS on geospatial data, including matching crash records to roadway networks.
  • Work with platform engineering on the data platform: warehouse, orchestration, access and cost.
  • Assess our data tooling and architecture (warehouse, orchestration, transformation) and lead changes where they pay off.
  • Set data governance with engineering leadership and our SOC 2 program: access, retention, lineage, and handling of sensitive and government data.
  • Partner with data science on datasets for analytics and models.

Required Skills & Experience:

  • Bachelor's degree in Computer Science, Data Science, or a related field
  • 7+ years of data engineering, including 2+ years leading engineers
  • Strong SQL and data modeling, warehouse and relational (PostgreSQL)
  • Strong Python for pipelines and tools
  • Building and operating production pipelines with orchestration and monitoring (Airflow, Dagster, Prefect or similar)
  • Cloud data platforms (Snowflake, BigQuery, Redshift, Databricks or similar) on AWS or another cloud
  • Geospatial data (PostGIS, GeoPandas, GIS tools or similar)
  • Data quality testing and validation (dbt tests, Great Expectations or similar)
  • Hands-on agentic coding (Claude Code or similar): breaking work into agent-sized tasks, writing specs and tests agents can work against, and reviewing agent output critically
  • Clear written communication; you document what you build

Preferred Skills:

  • Transportation, crash, roadway or other public-sector data
  • Multi-tenant SaaS data architecture
  • Transformation frameworks (dbt or similar) and distributed processing (Spark or similar)
  • Government data requirements (CJIS, state data agreements) or SOC 2
  • Applying LLMs to data mapping, cleaning or extraction, with evaluation of accuracy
  • Building agent tooling (MCP servers, skills or similar) that other engineers use

Your Citian Advantage:

  • Competitive salary and benefits package including medical, dental, and vision insurance and generous PTO.
  • 401(k) company match and monthly commuter transportation benefit
  • On-site gym and free snacks in the office
  • High-growth potential and opportunities for advancement within a fast growing, venture-backed SaaS startup!

Let's build smarter cities together! Learn more about Citian here: www.citian.co

** Citian is an organization committed to diversity and inclusion to drive our business results and create a better future every day for our diverse employees, clients, partners, and communities. We believe a diverse workforce allows us to match our growth ambitions and drive inclusion across the business. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Equal Opportunity/Affirmative Action Employer Minorities/Females/Protected Veterans/Persons with Disabilities