Cleared On Site Data Engineer

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 Micro Strategy, Thought Spot, 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.

• 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.
• 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 Micro Strategy/Strategy and Thought Spot 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.

• 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 (Micro Strategy, Thought Spot, 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.

• 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.

$114,600 - $192,500 USD

SMX is an Equal Opportunity employer including disabilities and veterans.

WE ARE AN EQUAL OPPORTUNITY EMPLOYER. Applicants and employees are considered for positions and are evaluated without regard to mental or physical disability, race, color, creed, religion, sex, gender, national origin, ancestry, age, genetic information, military or veteran status, sexual orientation, gender identity or expression, marital status, familial status or any other legally protected status under applicable law or other similar factors that are not job‑related.

No question on the application is intended to secure information about these subjects. We encourage all qualified individuals to apply for employment. We also provide reasonable accommodation to qualified individuals with disabilities in accordance with the Americans With Disabilities Act and applicable state and local law. If you require assistance or a reasonable accommodation to complete the application or any aspect of the application process, please contact the Talent Acquisition team at