Senior Data Engineer – Subject Matter Expert

Role Overview

Kearney & Company is hiring a Senior Data Engineer – Subject Matter Expert. The Senior Data Engineer SME will design, develop, optimize, and sustain enterprise data engineering solutions supporting the FASTR program within the War Data Platform. Working under the Technical Lead / Solution Architect, the SME will implement reliable ingestion, transformation, orchestration, and validation pipelines for Department of the Air Force financial data. This role collaborates with functional, architecture, and integration teams to deliver traceable, secure, and production-ready datasets that enable audit readiness, FIAR, and financial management reporting. Responsibilities include but not limited to: • Design, build, test, and maintain scalable batch and incremental data ingestion and transformation pipelines within the War Data Platform. • Implement approved source-to-target mappings, business rules, and data models in collaboration with Data Architecture / Transformation Analysts. • Develop and optimize SQL, Python, and ETL/ELT processes for large, complex financial datasets. • Build reusable data processing components, orchestration workflows, and automated data quality controls. • Implement completeness, accuracy, reconciliation, and lineage checks to support FIAR and Universe of Transactions requirements.