Back to jobs

Lead Data Engineer

Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Remote — work setting source
This is a hands-on technical leadership role with responsibility for guiding and reviewing the work of other Data Engineers. This position is remote. Duties & Responsibilities
Read the full posting
Employment
Not stated

Before you apply

Employer’s visa record
10 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • 6+ years of relevant data engineering or data platform experience, including experience leading or mentoring other engineers.
  • Experience with Kafka or Amazon MSK and CDC architectures.
  • Experience building cloud-based analytical platforms using object storage and columnar formats such as Parquet.
  • Experience with GeoParquet, PostGIS, or geospatial datasets.
  • Strong understanding of partitioning, schema evolution, snapshots, compaction, incremental processing, and analytical query optimization.
  • Experience with OpenSearch, document stores, or vector search technologies.
Qualification wording
6+ years of relevant data engineering or data platform experience, including experience leading or mentoring other engineers.
Experience with Kafka or Amazon MSK and CDC architectures.
Experience building cloud-based analytical platforms using object storage and columnar formats such as Parquet.
Experience with GeoParquet, PostGIS, or geospatial datasets.
Strong understanding of partitioning, schema evolution, snapshots, compaction, incremental processing, and analytical query optimization.
Experience with OpenSearch, document stores, or vector search technologies.
Education & alternatives
Educational Requirements - Bachelor's degree in Computer Science, Data Engineering, Information Systems, Engineering, or a related field. Requirements
Apply at Black Canyon Consulting

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 29, 202653 days ago
Recorded sightings
42
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 53

Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

Black Canyon Consulting is hiring

12 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • DuckDB
  • Iceberg
  • Kafka
  • S3
Where the posting names them
- Strong hands-on experience with DuckDB and Apache Iceberg. - Advanced SQL and strong Python development experience. - Experience building cloud-based analytical platforms using object storage and columnar formats such as Parquet.
We are seeking a Lead Data Engineer to design and implement the core analytical data platform for a federal permitting modernization initiative. The Lead Data Engineer will establish a modern lakehouse environment using DuckDB, Apache Iceberg, Amazon S3, and AWS Glue Catalog and will lead the engineering patterns used to ingest, harmonize, and serve data across multiple source systems. The role will also help implement metadata-driven and agentic approaches to data engineering, including source analysis, mapping, pipeline generation, testing, reconciliation, and quality assurance. This is a hands-on technical leadership role with responsibility for guiding and reviewing the work of other Data Engineers.
Duties & Responsibilities - Design and implement the core DuckDB / Apache Iceberg data platform on AWS. - Define physical data organization, schema, partitioning, file layout, snapshot, compaction, and optimization strategies for Iceberg tables.
- Define physical data organization, schema, partitioning, file layout, snapshot, compaction, and optimization strategies for Iceberg tables. - Integrate DuckDB with Amazon S3, Apache Iceberg, and AWS Glue Catalog. - Establish bronze, silver, and gold data-layer conventions and reusable engineering patterns.
- Experience implementing bronze/silver/gold or comparable layered data architectures and transforming heterogeneous enterprise datasets. - Experience with AWS data services, particularly Amazon S3 and AWS Glue. - Experience designing reusable, metadata-driven ingestion and transformation frameworks.
- Lead development of certified data products, analytical datasets, and business metrics. - Optimize DuckDB queries and Iceberg datasets for performance and efficiency. - Develop engineering documentation, operational procedures, and technical handoff materials.
- 6+ years of relevant data engineering or data platform experience, including experience leading or mentoring other engineers. - Strong hands-on experience with DuckDB and Apache Iceberg. - Advanced SQL and strong Python development experience.
- Design and implement the core DuckDB / Apache Iceberg data platform on AWS. - Define physical data organization, schema, partitioning, file layout, snapshot, compaction, and optimization strategies for Iceberg tables. - Integrate DuckDB with Amazon S3, Apache Iceberg, and AWS Glue Catalog.
Bonus Skills - Experience with Kafka or Amazon MSK and CDC architectures. - Experience with GeoParquet, PostGIS, or geospatial datasets.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

Overview

We are seeking a Lead Data Engineer to design and implement the core analytical data platform for a federal permitting modernization initiative.

The Lead Data Engineer will establish a modern lakehouse environment using DuckDB, Apache Iceberg, Amazon S3, and AWS Glue Catalog and will lead the engineering patterns used to ingest, harmonize, and serve data across multiple source systems. The role will also help implement metadata-driven and agentic approaches to data engineering, including source analysis, mapping, pipeline generation, testing, reconciliation, and quality assurance.

This is a hands-on technical leadership role with responsibility for guiding and reviewing the work of other Data Engineers.

This position is remote.

Duties & Responsibilities

  • Design and implement the core DuckDB / Apache Iceberg data platform on AWS.
  • Define physical data organization, schema, partitioning, file layout, snapshot, compaction, and optimization strategies for Iceberg tables.
  • Integrate DuckDB with Amazon S3, Apache Iceberg, and AWS Glue Catalog.
  • Establish bronze, silver, and gold data-layer conventions and reusable engineering patterns.
  • Lead and mentor Data Engineers, providing technical direction, code reviews, and engineering guidance.
  • Build and maintain analytical datasets supporting application services, reporting, analytics, and data science.
  • Develop reusable patterns for incremental loads, CDC, schema evolution, late-arriving data, backfills, and historical reconstruction.
  • Work with the Data Architect to implement the common canonical data model and source-to-canonical mappings.
  • Lead migration and harmonization of datasets from multiple source systems.
  • Implement reconciliation processes that demonstrate completeness and accuracy between source and target systems.
  • Establish automated data-quality monitoring, operational observability, and testing.
  • Implement agentic and AI-enabled data engineering patterns supporting activities such as source analysis, mapping, pipeline generation, troubleshooting, reconciliation, and quality assurance.
  • Support integration of structured data with associated document and geospatial datasets.
  • Lead development of certified data products, analytical datasets, and business metrics.
  • Optimize DuckDB queries and Iceberg datasets for performance and efficiency.
  • Develop engineering documentation, operational procedures, and technical handoff materials.

Educational Requirements

  • Bachelor's degree in Computer Science, Data Engineering, Information Systems, Engineering, or a related field.

Requirements

  • 6+ years of relevant data engineering or data platform experience, including experience leading or mentoring other engineers.
  • Strong hands-on experience with DuckDB and Apache Iceberg.
  • Advanced SQL and strong Python development experience.
  • Experience building cloud-based analytical platforms using object storage and columnar formats such as Parquet.
  • Strong understanding of partitioning, schema evolution, snapshots, compaction, incremental processing, and analytical query optimization.
  • Experience implementing bronze/silver/gold or comparable layered data architectures and transforming heterogeneous enterprise datasets.
  • Experience with AWS data services, particularly Amazon S3 and AWS Glue.
  • Experience designing reusable, metadata-driven ingestion and transformation frameworks.
  • Experience implementing automated data quality, reconciliation, monitoring, and operational controls.
  • Experience with agentic or AI-enabled data engineering solutions, including the use of agents or AI-assisted workflows for activities such as data mapping, pipeline generation, validation, testing, or troubleshooting.
  • Hands-on experience with agentic frameworks such as LangChain, LangGraph, or similar frameworks for building tool-using or multi-step AI workflows.
  • Strong troubleshooting, performance tuning, and technical leadership skills.

Bonus Skills

  • Experience with Kafka or Amazon MSK and CDC architectures.
  • Experience with GeoParquet, PostGIS, or geospatial datasets.
  • Experience with OpenSearch, document stores, or vector search technologies.
  • Experience integrating enterprise SaaS platforms, APIs, databases, and file-based sources.
  • Experience working in the U.S. Federal Government space.

Experience with permitting, regulatory, land management, environmental, energy, or natural-resource datasets.

Benefits and Salary

We attract the best people in the business with our competitive benefits package that includes medical, dental and vision coverage, 401k plan with employer contribution, paid holidays, vacation, and tuition reimbursement.

If you enjoy being a part of a high performing, professional service and technology focused organization, please apply today!

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Bethesda, MD

This is a hands-on technical leadership role with responsibility for guiding and reviewing the work of other Data Engineers. This position is remote. Duties & Responsibilities
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.