Staff Data Engineer (CRASH)

Reposted 23 Days Ago
Be an Early Applicant
Washington, DC, USA
In-Office
Senior level
Artificial Intelligence • Machine Learning • Software • Analytics
We build software to help save lives. Our AI / ML products support transportation leaders within the public sector.
The Role
Lead architecture and build scalable data pipelines and ETL for large datasets, optimize data models and DB structures, ensure data quality and governance, work with cloud platforms (Snowflake/AWS), mentor junior engineers, collaborate with data scientists and product teams, and apply geospatial and big-data technologies to deliver data-driven transportation solutions.
Summary Generated by Built In

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 hands-on senior data engineer who sets technical direction. You'll set the standards our data engineers build to, mentor them, and own how crash and roadway data gets from client systems into CRASH: 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 cleaning, checking and pipeline work that slows onboarding today, and you stay accountable for the data that ships. You're a self-starter who works well with research, data science, GIS, software engineering and customer teams, and you're in the office multiple times a week.

Expected Duties:

  • Own technical standards for data engineering: review designs and code, mentor the team's data engineers, and help hire.
  • Lead data projects hands-on, working within the product team that owns each one: make the technical calls and see the work through to release.
  • 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 and cleaning, and pipeline code built from the research team's mapping specs, 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 as a technical lead (setting direction, reviewing designs, mentoring 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

Salary Range: $150,000 - 200,000

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

Skills Required

  • Bachelor's in Computer Science, Data Science, or a related field
  • 7+ years of experience in data engineering, with prior leadership roles
  • Strong proficiency in SQL (DDL, DML, data architecture)
  • Strong proficiency in Python and Jupyter
  • Knowledge of data modeling, data warehousing, and ETL processes
  • Experience with cloud-based data platforms such as Snowflake and AWS
  • Experience working with DBMSs such as PostgreSQL and MySQL
  • Familiarity with extracting, analyzing, and mapping geospatial data and GIS systems
  • Familiarity with distributed systems and big data technologies such as Apache Spark
  • Understanding of data visualization concepts and tools
  • Strong problem-solving and analytical skills
  • Excellent communication and collaboration skills
  • Ability to work independently and adapt to changing priorities
  • Experience in a startup or fast-paced environment
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Washington, DC
39 Employees
Year Founded: 2024

What We Do

At Citian, we are building software that saves lives and changes the face of transportation management within the public sector. We are a fast-growing, venture-backed SaaS startup in Washington, DC. and our products provide transportation leaders with better insights and data into their roadways.

Similar Jobs

GoodRx Logo GoodRx

Counsel

Consumer Web • Coupons • Healthtech • Social Impact • Pharmaceutical
Remote or Hybrid
USA
800 Employees
142K-305K Annually

Applied Systems Logo Applied Systems

Data Engineer

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
160K-260K Annually

Coursera + Udemy  Logo Coursera + Udemy

Category Manager

Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Remote or Hybrid
United States
1500 Employees
137K-174K Annually

Hilton Logo Hilton

Security Officer (Overnight, Part-Time) - Waldorf Astoria Washington DC

Events • Food • Travel • Hospitality • Hotels & Resorts
In-Office
Washington, DC, USA
500000 Employees

Similar Companies Hiring

Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account