Senior Data Engineer – Federal On-Prem Data Platform

Strategic Innovation Group, LLC; Arlington (VA); On-site; USD 150,000 - 185,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Generous PTO

401(k) with match

Life insurance

Disability insurance

Health Savings Account (HSA)

Job summary

Strategic Innovation Group (SIG) in Arlington, VA seeks a Senior Data Engineer to lead the data core of a federal analytics platform. You will own the physical data model, ingestion architecture, and reusable connector framework, driving standards for the data team in an Agile environment.

You will work with stakeholders to deliver a Minimum Viable Product and establish the foundation for expansion, ensuring the data and dashboards are accurate and secure in a government-controlled environment.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• 5+ years in data engineering with 3+ years as lead on a production data platform.
• Expert-level SQL and PostgreSQL data modeling.
• Strong Python for pipelines and orchestration (Airflow/Daggerster/Prefect).
• Experience building reusable ingestion from heterogeneous sources with schema validation.

Responsibilities

• Design and implement centralized data layer in PostgreSQL with governed schema.
• Ingest and normalize data from multiple federal sources via scalable pipelines.
• Build reusable connectors and CI/CD deployment with automated tests and security scans.
• Implement PII anonymization and access controls per NIST 800-53 Moderate.
• Document data criteria, runbooks, and metadata for data lineage and governance.
• Lead data quality defect tracking and resolution.
• Collaborate with developers on API access and data core improvements.
• Troubleshoot pipeline failures and performance issues.
• Participate in Agile ceremonies and continuous improvement.

Skills

SQL & PostgreSQL

Python

Airflow

Kubernetes

Data ingestion

PII handling

Agile

Education

Bachelor's degree in CS/IS/Engineering

Master's degree preferred

Tools

GitLab

Jenkins

Azure DevOps

Rancher

PostgreSQL

Docker

Job description

Strategic Innovation Group (SIG) in Arlington, VA seeks a Senior Data Engineer to lead the data core of a federal analytics platform. You will own the physical data model, ingestion architecture, and reusable connector framework, driving standards for the data team in an Agile environment.

You will work with stakeholders to deliver a Minimum Viable Product and establish the foundation for expansion, ensuring the data and dashboards are accurate and secure in a government-controlled environment.