Cleared On Site Data Engineer (4899)

SMX • Washington, DC • 8h ago

Cleared On Site Data Engineer (4899)at SMX(View all jobs) (https://www.smxtech.com/careers/)

Washington, DC

SMX is seeking a Senior Data Architect to provide strategic and technical leadership for enterprise data architecture and analytics modernization efforts. This individual will design, optimize, and oversee data solutions that enable advanced analytics, business intelligence, and reporting capabilities across multiple secure environments. This role will focus on designing, developing, optimizing, and maintaining data pipelines and backend data engineering solutions that power critical analytical products used by senior FBI leadership. The ideal candidate brings deep technical expertise in ETL processes, SQL, Python, AWS data services, and enterprise-scale data warehousing , with strong familiarity in BI ecosystems such as MicroStrategy (Strategy), ThoughtSpot, and related tools used within the HR Reports program. The position requires close collaboration with government leads, senior data developers, BI engineers, and cross-functional analytics teams to ensure high reliability, performance, and security of data products supporting mission-critical operations.

This is a full-time position requiring on-site work five days a week at a client's office in Washington, D.C. An active Top Secret clearance is mandatory.

Essential Duties and Responsibilities:

Design, build, and maintain scalable, secure ETL/ELT pipelines supporting HR Reports analytics and dashboard products.

Develop and optimize SQL-based transformations, stored procedures, and data models for high-volume enterprise datasets.

Implement data orchestration workflows using AWS services (e.g., Glue, Lambda, Step Functions, CloudWatch).

Ensure data quality, lineage, and integrity across multiple enterprise data sources.

Support and enhance cloud-based warehouse environments within AWS (e.g., Redshift, S3, IAM).

Collaborate with BI developers to ensure backend data structures meet MicroStrategy/Strategy and ThoughtSpot reporting needs.

Troubleshoot complex data pipeline or performance issues and implement long-term remediation solutions.

Translate government stakeholder requirements into technical specifications for new data sources and pipelines.

Partner with Data Analysts, Data Scientists, and BI Developers to support advanced analytics and ad-hoc data requests.

Apply data governance, security, and compliance best practices in alignment with FBI and SMX standards.

Recommend and implement improvements to automation, data architecture, pipeline reliability, and overall performance.

Maintain documentation for pipelines, logic, data flows, and system dependencies.

Stay current with modern data engineering practices and AWS service enhancements relevant to pipeline automation and warehousing.

Required Skills:

10+ years of experience in data architecture, data warehousing, or enterprise analytics systems.

Expert-level proficiency in SQL and data modeling

Hands-on experience designing and implementing ETL/ELT frameworks (e.g., Apache Airflow, dbt, AWS Glue, Informatica).

Demonstrated success architecting and optimizing large-scale BI/reporting solutions (MicroStrategy, ThoughtSpot, Power BI, Tableau).

Strong knowledge of AWS data ecosystem (Redshift, Athena, S3, Glue, Lambda) or similar cloud environments.

Experience defining and enforcing data governance , quality, and security standards.

Ability to design and document end-to-end data flows and integrations between transactional and analytical systems.

Excellent communication, analytical, and problem-solving skills.

Desired Skills/Experience:

Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or related technical field.

10+ years of experience in data engineering, backend data development, or enterprise-scale ETL development.

Experience supporting federal government IT systems or analytics programs.

Familiarity with Agile methodologies and Jira-based workload management.

Experience supporting or modernizing enterprise BI ecosystems.

** This position requires five days a week on site at customer location in Washington DC.

Application deadline 1-16-2026

LI-SA

cjpost

The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

The proposed salary for this position is:

$114,600-$192,500 USD

At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.

We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what's possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.

SMX is an Equal Opportunity employer including disabilities and veterans.

Selected applicant may be subject to a background investigation and/or education verification.

SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).

SMX

Go to Apply

Share this job

Similar Jobs

Personnel Security Specialist

Executive Office for U.S. Attorneys and the Office of the U.S. Attorneys • Washington, DC • 23min ago

IT & Engineering

Summary For more information on the Department of Justice and the United States Attorneys' Offices, visit http://www.justice.gov/usao/. As needed, additional positions may be filled using this announcement. Responsibilit...

23min ago

Go to Apply

Cloud Software Engineer

General Dynamics Information Technology • Reston, VA • 50min ago

IT & Engineering

Req ID: RQ211031 Type of Requisition: Regular Clearance Level Must Be Able to Obtain: None Public Trust/Other Required: None Job Family: Software Engineering Skills: Agile Methodology,C++ Programming Language,Cloud Devel...

50min ago

Go to Apply

Azure Cloud Developer

General Dynamics Information Technology • Fairfax, VA • 52min ago

IT & Engineering

Req ID: RQ211417 Type of Requisition: Regular Clearance Level Must Be Able to Obtain: None Public Trust/Other Required: MBI (T2) Job Family: Software Engineering Skills: Cloud Development,Microsoft Azure,Terraform Certif...

52min ago

Go to Apply

Systems Administrator

Guidehouse • Bethesda, MD • 57min ago

IT & Engineering

Job Family : Systems Engineering (SYE) Travel Required : Up to 10% Clearance Required : Active Top Secret SCI with Polygraph What You Will Do : As a Systems Administrator, you will be involved in managing and maintaining...

57min ago

Go to Apply

Cloud Engineer

SAIC • Washington, DC • 58min ago

IT & Engineering

Description The Application Vulnerability Assessment Program (AVAP) Engineer is responsible for operating and securing the program's application security platforms, including OpenText Fortify, OWASP Dependency-Track, and...

58min ago

Go to Apply

Cybersecurity Testing and Evaluation Specialist - Entry to Mid Level (Maryland)

National Security Agency/Central Security Service • Fort Meade, MD • 1h ago

IT & Engineering

Summary As a Cybersecurity Testing Specialist, you will apply your cybersecurity expertise to perform formal assessments mimicking real-world attacks to identify methods for circumventing security features of application...

1h ago

Go to Apply

(USA) Technician, Low Voltage, Licensed

Walmart • Fairfax, VA • 3h ago

IT & Engineering

Position Summary... What you'll do... Sets up and configures various low voltage systems (for example, security systems, fire alarms, CCTV, audio/video systems, network cabling). Runs, terminates, and labels cables accor...

3h ago

Go to Apply

Arkime Engineer - Active TS/SCI with CI Poly

ENS Solutions • College Park, MD • 7h ago

IT & Engineering

We are seeking a highly skilled Arkime (formerly Moloch) Implementation & Sustainment Engineer to design, deploy, operate, and enhance our enterprise packet-capture and deep network visibility capability. The ideal c...

7h ago

Go to Apply

Arkime Engineer - Active TS/SCI with CI Poly

ENS Solutions • Reston, VA • 7h ago

IT & Engineering

7h ago

Go to Apply

Arkime Engineer - Active TS/SCI with CI Poly

ENS Solutions • Washington, DC • 7h ago

IT & Engineering

7h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.