SMX ยท 1 day ago
Cleared On Site Data Engineer (4899)
Washington, DC
Full-time
Onsite
Senior Level, Lead/Staff
$115K/yr - $192K/yr
10+ years expSMX is seeking a Senior Data Architect to provide strategic and technical leadership for enterprise data architecture and analytics modernization efforts. 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.
AnalyticsCloud ComputingCloud Data ServicesCloud SecurityCyber SecurityInformation TechnologyIT ManagementSoftware
No H1B
Security Clearance RequiredU.S. Citizen Only
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
Qualification
Required
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
An active Top Secret clearance is mandatory
Preferred
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
Benefits
Health insurance
Paid leave
Retirement
Company
SMX
SMX is a provider of information technology (IT), services, and advanced engineering with a focus on Cloud Solutions.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Peter LaMontagne
Chief Executive Officer
Recent News
2025-11-24
Precedence Research
2025-11-18
Company data provided by crunchbase