Senior Data Engineer — Secure Federal Pipelines

Analytica; Bethesda (MD); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Bonuses

Employer paid health care

Training and development funds

401k match

Job summary

Analytica in Bethesda, MD is seeking an experienced Senior Data Engineer to design scalable ETL/ELT pipelines, data connectors, and RESTful services for a federal data modernization initiative. You will ingrain data quality, lineage, and secure data practices across multi-source environments.

You will build reusable components, collaborate with cross-functional teams, and contribute to a secure platform that supports AI-assisted analytics while complying with federal security requirements and

Qualifications

• 7+ years of experience in data engineering or related software engineering.
• Production-grade data pipelines experience in enterprise environments.
• Strong experience with ETL/ELT architecture, data transformation, orchestration, validation, reconciliation, lineage, logging, and monitoring.
• Advanced proficiency with SQL and relational databases.
• Strong programming experience in Python.
• Experience developing and integrating REST APIs and other data integration interfaces.
• U.S. citizenship and ability to obtain and maintain Top Secret eligibility.
• Active Top Secret clearance highly preferred.

Responsibilities

• Design, develop, test, and deploy scalable ETL/ELT pipelines for high-volume, multi-source data environments.
• Build reusable data connectors and integration services for ingesting data from APIs, databases, files, and other sources.
• Develop and integrate REST APIs and data services to support ingestion, retrieval, transformation, and downstream apps.
• Design data transformation and normalization processes for structured and unstructured data.
• Implement data quality controls including validation, reconciliation, deduplication, error handling, and auditability.
• Develop automated processes for data lineage, metadata capture, logging, monitoring, and auditability.
• Design and optimize data models, schemas, and storage solutions using relational and other technologies.
• Develop efficient SQL queries, stored procedures, transformations, and data-processing logic for large datasets.
• Build and maintain automated CI/CD pipelines for data engineering components and applications.

Skills

ETL/ELT

SQL

Python

Data pipelines

REST APIs

PostgreSQL

SQL Server

Linux

CI/CD

Git

Education

Bachelor's degree in CS or related field

Tools

Kubernetes

Docker

Azure DevOps

Git

SQL Server

PostgreSQL

Job description

Analytica in Bethesda, MD is seeking an experienced Senior Data Engineer to design scalable ETL/ELT pipelines, data connectors, and RESTful services for a federal data modernization initiative. You will ingrain data quality, lineage, and secure data practices across multi-source environments.

You will build reusable components, collaborate with cross-functional teams, and contribute to a secure platform that supports AI-assisted analytics while complying with federal security requirements and