Senior Data Engineer

MANTECH seeks a motivated, career and customer-oriented Senior Data Engineer to join our team in Ashburn, VA. This is a hybrid-remote position with 2-3 days on-site per week.

As a Senior Data Engineer, you will facilitate data-driven decision-making in response to national security threats supporting U.S. Customs and Border Protection (CBP). In this role, you will apply advanced data engineering techniques to large-scale operational datasets, architecting resilient pipelines and analytics solutions to ensure the movement of people, capital, and products remains legal, safe, and secure.

Responsibilities include but are not limited to:

• Apply analytical reasoning, problem-solving, investigative techniques, and creative thinking to large-scale datasets supporting mission-critical operational scenarios.
• Develop, implement, and maintain scalable ETL pipelines and data workflows using modern cloud technologies.
• Support database modernization and migration from legacy on-premises environments to cloud platforms.
• Respond to data queries and analytical requests from organizational stakeholders by developing, publishing, and maintaining scheduled and ad hoc reports.
• Research, define, and document data elements, business definitions, and source-system information across core business subject areas.
• Maintain source code repositories and standard version control practices using GitLab.
• Apply a practical understanding of cargo and passenger data systems to support analytical application functionality and frontline targeting operations.

Minimum Qualifications:

• Relevant professional experience based on highest level of education:
  • BS/BA with 10+ years of experience
  • MS/MA/MBA with 8+ years of experience
  • PhD/Doctorate with 6+ years of experience
  • AS/AA with 14+ years of experience
  • High School Diploma/GED with 16+ years of experience
• Experience in application development across the full life cycle on Data Warehouse engagements.
• Experience in large-scale (80TB+) and complex data warehousing architecture, design, and implementation or migration.
• Experience administering and tuning relational database management systems (such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL), including advanced SQL development, schema modeling, query performance optimization, and indexing.
• Experience engineering and maintaining scalable data pipelines and Lakehouse solutions using Databricks, including Apache Spark workload tuning and Delta Lake table design.
• Experience deploying and operationalizing scalable ETL/ELT data-integration pipelines and migrating on-premises workloads to cloud environments such as AWS, Microsoft Azure, or equivalent platforms.

Preferred Qualifications:

• Active Top Secret clearance is strongly preferred (to accelerate the CBP background investigation timeline).
• Working knowledge of Continuous Integration & Continuous Deployment (CI/CD) pipelines and tools.
• Experience with business intelligence and data analytics tools, including Microsoft Power BI or Oracle Business Intelligence Enterprise Edition (OBIEE), to build actionable dashboards and visualizations.
• Experience with the Hadoop ecosystem (HDFS, YARN, Hive, Pig) and distributed batch/streaming frameworks such as Spark, Kafka, or Storm.
• Experience using Atlassian collaboration and agile delivery tools, including Jira and Confluence, for sprint tracking and technical documentation.

Clearance Requirements:

• Must be a U.S. citizen.
• Must be able to obtain and maintain DHS CBP Suitability.
• Active Top Secret clearance preferred.

Physical Requirements:

• The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, or to communicate with co-workers, management, and customers, which may involve delivering presentations.