Must be a U.S. Citizen with an Active TS or eligible for a Top Secret (Tier 5) clearance. No third party.

ABOUT THE ROLE

Strategic Innovation Group (SIG) is seeking a Senior Data Engineer to lead the data core of a new analytics platform for a federal government client. The platform consolidates program, financial, and performance data from multiple federal agency systems and Government-wide sources into a centralized PostgreSQL data layer that feeds dashboards, analytic rules, and reporting for oversight users, and is built on-premises within the client's FedRAMP Moderate environment. This role owns the physical data model, the ingestion architecture, and the reusable connector framework, sets engineering standards for the data team, and is the person who can explain why the numbers on the dashboard are right. The successful candidate will be proposed as key personnel and will work in an Agile environment alongside the program manager, solutions architect, data governance lead, application developers, configuration manager, security lead, and client stakeholders to deliver a Minimum Viable Product and the foundation for its expansion.

RESPONSIBILITIES

- Design and implement the centralized data layer in PostgreSQL to a governed schema and shared data vocabulary defined with the data governance lead.
- Architect a scalable ingestion pipeline in Python (Airflow, Dagster, Prefect, or comparable orchestration) that collects, normalizes, validates, and persists structured and unstructured data from agency financial-management, program-management, and payment systems and from Government-wide data sources.
- Build configuration-driven connectors (REST APIs, flat files, database replication, SFTP) that are reusable across agencies without source-code changes, and deploy them through the program CI/CD pipeline (GitLab, Jenkins or Azure DevOps) with automated build, test, and security scanning to the client's Rancher-managed Kubernetes platform.
- Implement PII anonymization, data-handling, and access controls at ingestion in coordination with the security lead, aligned to NIST SP 800-53 Moderate controls.
- Implement defined analytic rules and threshold-based indicators as deterministic, inspectable SQL that runs on a scheduled refresh, and document the data and criteria behind each rule.
- Lead the error-detection methodology for data-quality issues: identify, categorize, track, resolve, and report defects and anomalies throughout the lifecycle.
- Capture metadata and data lineage, and expose data-currency indicators (source, last refreshed, next refresh) to the user interface.
- Set coding, code-review, testing, and documentation standards for the data team; review the Data Engineer's work; and collaborate with application developers on API access to the data core.
- Troubleshoot and resolve pipeline failures, data discrepancies, and query performance bottlenecks.
- Produce technical documentation, data dictionaries, and runbooks, and deliver knowledge transfer so client staff can operate, maintain, and extend pipelines with minimal contractor reliance.
- Participate in Agile ceremonies, sprint planning, code reviews, demonstrations, and continuous improvement activities.

REQUIRED QUALIFICATIONS

- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field; equivalent experience may be considered.
- 8+ years of professional data engineering experience, including 3+ years as technical lead or senior engineer on a production data platform (6+ years with a Master's degree).
- Expert-level SQL and PostgreSQL data modeling, including normalized and analytic schemas, partitioning, indexing, and performance tuning.
- Strong Python for pipeline development and hands-on experience with an orchestration framework such as Airflow, Dagster, or Prefect.
- Demonstrated experience designing reusable, configuration-driven ingestion from heterogeneous sources with schema validation and data-quality checks.
- Experience deploying pipelines in containerized environments (Docker, Kubernetes) with Git-based version control and CI/CD.
- Experience handling PII and sensitive financial or program data under NIST SP 800-53 or equivalent controls.
- Experience working in Agile software development environments and collaborating with technical and non-technical stakeholders in a federal contracting environment.
- Strong written communication skills for data-model documentation, runbooks, and knowledge transfer.

PREFERRED QUALIFICATIONS

- Experience supporting federal civilian, financial-oversight, budget, or program-management IT systems.
- Experience integrating data from enterprise financial systems (e.g., SAP S/4HANA, Oracle, or comparable ERP) and Treasury or payment platforms.
- Experience with grants management or federal financial systems (e.g., GrantSolutions, eRA, Treasury payment systems) highly preferred.
- Experience extracting structured data from unstructured documents (PDF, DOCX) at scale.
- Experience with metadata management, data-lineage, and data-catalog tooling.
- Experience deploying to Kubernetes (Rancher preferred) in an on-premises federal environment with restricted internet access.
- Familiarity with Splunk log integration and NIST SP 800-53 audit-logging requirements.