Senior Data Engineer

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

We are seeking an experienced Senior Data Engineer to build reusable connectors and data pipelines that ingest, validate, normalize, and persist agency data for a Federal data analytics and AI modernization initiative.

The team will deliver a secure, scalable platform that integrates structured and unstructured data, provides data visualization and traceable AI-assisted analytics, and gives examiners centralized tools for search, review, monitoring, and decision support. The platform will support professional judgment and will not replace authoritative agency financial or grants-management systems or execute financial transactions.

Analytica has been recognized by Inc. Magazine as the fastest-growing private US small business. We work with U.S. government customers in health, civilian, and national security missions. As a core member you’ll work with a diverse team of professionals to solve matters, architect nuisances, and come up with alternatives. We offer competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match.

Key Responsibilities

• Design, develop, test, and deploy scalable ETL/ELT pipelines for high-volume, multi-source data environments.
• Build reusable data connectors and integration services to ingest data from APIs, databases, files, and other enterprise data sources.
• Develop and integrate RESTful APIs and data services to support data ingestion, retrieval, transformation, and downstream applications.
• Design data transformation and normalization processes for structured and unstructured data.
• Implement data quality controls, including validation, reconciliation, deduplication, error handling, and exception management.
• 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 appropriate data 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.

Required Qualifications

• 7+ years of experience in data engineering, data integration, or a related software engineering discipline.
• Demonstrated experience building and maintaining production-grade data pipelines 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.
• Experience working with relational databases and data-storage technologies, such as PostgreSQL or Microsoft SQL Server.
• Experience with Linux-based development or deployment environments.
• Experience with Git-based source control and CI/CD practices.
• Experience developing automated tests for data pipelines, APIs, or software components.
• Strong communication, documentation, problem-solving, and cross-functional collaboration skills.
• U.S. citizenship and ability to obtain and maintain Top Secret eligibility, as required for all contractor personnel supporting the effort.
• Active Top Secret clearance highly preferred.

Preferred Qualifications

• Experience with Kubernetes, Rancher, Docker, or other container orchestration technologies.
• Experience with Jenkins, Azure DevOps, or comparable CI/CD platforms.
• Experience with self-hosted Azure DevOps environments.
• Experience developing data solutions in secure Federal, on-premises, or hybrid cloud environments.
• Experience with PostgreSQL and/or Microsoft SQL Server administration, optimization, or advanced development..
• Experience implementing data catalogs, metadata management, data lineage, or data governance capabilities.
• Experience integrating structured and unstructured data across disparate systems.
• Experience with event-driven architectures, message queues, or streaming data technologies.
• Familiarity with Federal security, privacy, accessibility, and compliance requirements.
• Experience supporting Federal financial management, budget execution, grants management, payment systems, award oversight, financial reporting, or financial stewardship is preferred.
• Experience supporting Federal financial management, grants, payment, or award-oversight platforms.

About ANALYTICA:Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established SBA small business that hasbeen recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growingcompanies in theU.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services.The companyis appraised by the Software Engineering Institute (SEI) at CMMI Maturity Level 3 and is an ISO 9001:2008 certified provider.

Analytica LLC is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other characteristic protected by applicable federal, state, or local law. As a federal contractor, we comply with the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and take affirmative action to employ and advance in employment qualified protected veterans. We ensure that all employment decisions are based on merit, qualifications, and business needs. We prohibit discrimination and harassment of any kind. Analytica LLC also provides reasonable accommodations to applicants and employees with disabilities, in accordance with applicable law.

To enhance efficiency, fairness, and accuracy, Analytica may use AI-assisted tools to support certain aspects of our hiring process.

• Application Review: AI tools may help identify skills and experiences relevant to the role.
• Interview Support: AI-powered notetaking tools may be used during interviews to document discussions and summarize key points.

These tools are used to assist our team. All hiring decisions are made by Analytica recruiters and hiring managers.

By submitting an application, you acknowledge that AI-assisted tools may be used to support parts of the application and interview process.

When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.