Back to jobs

Data Engineer

Bethesda, MD

Overview

Black Canyon Consulting (BCC) is searching for a Data Engineer to support the design, development, and maintenance of data infrastructure that enables artificial intelligence, machine learning, and analytical workloads. The Data Engineer will help ensure that data is reliable, accessible, scalable, and operationally ready throughout the full lifecycle from ingestion through deployment.

Job Description

The Data Engineer will design, implement, maintain, and optimize data pipelines, APIs, data transformation workflows, and supporting infrastructure. This position will work with databases, data lakes, data warehouses, feature stores, and other data platforms to ensure information can be efficiently ingested, transformed, accessed, and used by analytical and AI-enabled systems.

The Data Engineer will also develop and maintain ETL/ELT processes, feature engineering workflows, and service layers that expose data or model endpoints to downstream systems and applications.

Duties and Responsibilities

  • Develop and maintain data ingestion and transformation pipelines using Python and SQL.
  • Implement bronze, silver, and gold data processing patterns using DuckDB and Apache Iceberg.
  • Build reusable, metadata-driven capabilities for ingesting data from databases, APIs, files, SaaS platforms, CDC, and event-driven sources.
  • Develop configuration-driven source onboarding and source-to-canonical data mappings.
  • Transform heterogeneous source data into standardized and governed data models while maintaining source provenance and traceability.
  • Implement agentic and AI-enabled workflows to support source profiling, schema analysis, data mapping, pipeline generation, testing, troubleshooting, reconciliation, and data quality.
  • Develop automated data validation, reconciliation, testing, monitoring, and error-handling capabilities.
  • Support incremental processing, schema evolution, backfills, and historical data migration.
  • Integrate structured data with related document and geospatial datasets where required.
  • Work with the Data Architect and Lead Data Engineer to implement common engineering standards and reusable platform patterns.
  • Participate in code reviews, automated testing, CI/CD, technical documentation, and operational support.

Requirements

  • 4+ years of relevant data engineering or software engineering experience.
  • Strong hands-on experience with Python, SQL, DuckDB, and Apache Iceberg.
  • Experience developing production ETL/ELT pipelines across databases, APIs, files, and semi-structured data sources.
  • Experience implementing bronze/silver/gold or comparable layered data architectures.
  • Experience designing reusable, metadata-driven ingestion and transformation pipelines.
  • Experience with AWS data services, particularly Amazon S3 and AWS Glue.
  • Experience with data modeling, source-to-target mappings, data quality, reconciliation, and schema evolution.
  • Experience developing or implementing agentic or AI-enabled data engineering workflows, including the use of AI agents or LLMs to assist with data engineering tasks.
  • Experience with Git-based development, automated testing, and CI/CD.

Bonus Skills

  • Experience with agentic frameworks such as LangChain, LangGraph, or similar orchestration frameworks.
  • Experience with Kafka, Amazon MSK, or CDC technologies.
  • Experience integrating Salesforce, ServiceNow, Microsoft Dataverse, or similar enterprise platforms.
  • Experience with OpenSearch, vector stores, or document-processing pipelines.
  • Experience with GeoParquet, PostGIS, or geospatial datasets.
  • 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!

Create a Job Alert

Interested in building your career at Black Canyon Consulting? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter*

Accepted file types: pdf, doc, docx, txt, rtf

Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Black Canyon Consulting’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...