Cleared Onsite Data Engineer (5193)

SMX is seeking a Senior Data Engineer to lead the design, development, and evolution of enterprise-level data architecture supporting a federal law enforcement client. This role will drive the strategic integration of HR and financial data systems, enabling advanced analytics, AI/ML capabilities, and data-driven decision-making across the organization. The ideal candidate will bring deep expertise in cloud-based data platforms, data warehousing, and ETL/ELT pipelines, and will serve as a technical leader guiding cross-functional teams in delivering scalable, secure, and high-performance data solutions. This position requires close collaboration with stakeholders, engineers, and analysts to modernize data infrastructure and support mission-critical initiatives. This is a full-time position requiring on-site work four days a week at a client's office in Washington, D.C. An active Top-Secret clearance is mandatory.

Essential Duties and Responsibilities:

• Lead the design and implementation of enterprise data architecture across multiple systems, ensuring scalability, performance, and security
• Define data models, data standards, and architecture patterns for structured and unstructured data
• Architect and oversee ETL/ELT pipelines and data integration frameworks across cloud and on-prem environments
• Guide the development of data warehouses and data lakes using modern cloud technologies (e.g., AWS GovCloud, Redshift, Aurora/Postgres)
• Support integration of Business Intelligence tools (e.g., MicroStrategy, ThoughtSpot, Tableau, Power BI) for advanced analytics and reporting
• Collaborate with AI/ML teams to enable data pipelines that support predictive analytics and GenAI use cases
• Establish and enforce data governance, data quality, and metadata management standards
• Lead architecture reviews, technical design sessions, and system modernization efforts
• Partner with program leadership to align data strategy with mission objectives and contract deliverables
• Provide technical leadership and mentorship to data engineers, developers, and analysts

Required Skills:

• Active Top Secret (TS/SCI) Clearance (aligned to your standard requirement)
• Bachelor's degree in Computer Science, Information Systems, or related field (Master's preferred)
• 10+ years of experience in data architecture, data engineering, or related field
• Extensive experience with data warehousing and database technologies (e.g., SQL, Oracle, AWS Redshift)
• Strong expertise in ETL/ELT processes and data integration tools (e.g., Airflow, AWS Glue, Informatica, dbt)
• Experience designing and implementing cloud-based data platforms, preferably in AWS GovCloud
• Deep knowledge of data modeling (dimensional, relational, and NoSQL)
• Experience supporting federal government IT systems and contracts

Desired Skills/Experience:

• Experience with AI/ML data pipelines and GenAI-enabled analytics solutions
• Familiarity with MicroStrategy (Strategy), ThoughtSpot, or similar BI tools
• Experience supporting large-scale HR, financial, or enterprise data systems
• Knowledge of Kubernetes / AWS EKS for data platform deployment and scalability
• Experience with data governance frameworks, metadata management, and data cataloging tools
• Prior experience supporting ATO processes and secure cloud migrations (e.g., CMC, GovCloud)

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

Application deadline 4-24-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:

$95,600 - $160,700 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).