Data Engineer at blackcanyonconsultingblackcanyonconsulting · Bethesda, MD

Posted: 2026-10-20

Skills: Python, SQL, AWS, CI/CDOverview 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 d…Sign in to see the original postingBrowse more developer jobs on RoleBurst