Data Engineer
At a glance
Mid-level Data Engineering role at Black Canyon Consulting. Bethesda · no salary stated · we estimate $112,500–$160,000 across the United States.
Black Canyon Consulting has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build Python and SQL pipelines that collect data and reshape it for downstream use
- Use DuckDB and Apache Iceberg to organize data into bronze, silver and gold layers
- Create reusable ingestion and mapping workflows for databases, APIs, files and other sources
- Apply AI-enabled workflows to profile sources, map data, generate pipelines, test and troubleshoot
- Add validation, reconciliation, monitoring and error handling, while supporting backfills and schema changes
What you bring
- At least four years working in data engineering or software engineering
- Strong practical skills in Python, SQL, DuckDB and Apache Iceberg
- Production ETL/ELT experience with databases, APIs, files and semi-structured sources
- Experience creating metadata-driven pipelines and layered data architectures
- AWS data-service experience, especially Amazon S3 and AWS Glue, plus Git, automated testing and CI/CD
Who this fits
This mid-level role suits an engineer experienced in production pipelines, data quality and AI-assisted engineering workflows. You'll coordinate with the data architect and lead engineer, contribute to code reviews and documentation, and help with operational support.
From the employer
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!
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.