Project Manager-Query Support

The Project Manager Query Support is responsible for planning managing and overseeing all query development data ingestion and analytical support activities in support of the CBP analytics and intelligence support program. This role ensures the timely and accurate delivery of ad hoc and recurring analytical queries leveraging enterprise data platforms including Databricks and Oracle environments to support CBP reporting advanced analytics and operational decision-making. The Project Manager serves as the primary interface between CBP stakeholders query developers data engineers and contractor leadership to ensure solutions align with mission requirements technical standards and program schedules.

This position will support the mission in multiple locations:

• Ashburn VA
• Sterling VA
• Washington D.C

Key Responsibilities

• Lead and manage all query support activities under the BISS contract.
• Oversee raw data ingestion ETL processes and data preparation activities in support of analytical and reporting requirements.
• Manage the development optimization validation and delivery of ad hoc and recurring queries using Databricks Oracle and enterprise data warehouse environments.
• Coordinate data analysis efforts using SQL and advanced analytical techniques including machine learning models to support CBP mission use cases.
• Support rules development and conduct impact assessments of analytical rules applied to multi-terabyte datasets to evaluate operational and business effects.
• Serve as the primary point of contact for CBP stakeholders regarding query requirements priorities and delivery schedules.
• Collaborate with data engineering teams to ensure Databricks pipelines Oracle datasets and analytical environments are optimized for performance scalability and accuracy.
• Ensure query logic analytical outputs and data transformations comply with CBP DHS and federal data governance security and quality standards.
• Manage schedules milestones workload prioritization and performance metrics related to query and analytics deliverables.
• Identify track and mitigate risks related to data availability ETL performance query complexity and analytical scalability.
• Ensure proper documentation of ETL processes query logic analytical methodologies and validation procedures.
• Drive continuous improvement by identifying opportunities to enhance analytical efficiency query performance and data usability using Databricks and Oracle capabilities.
• Prepare and deliver status reports analytical summaries and briefings to CBP leadership and program stakeholders.

*Position is part of a proposal effort*

Required Qualifications

• Bachelors degree in Information Systems Computer Science Data Analytics Statistics Mathematics Business or a related field.
• Minimum of 10 years of experience
• Minimum of 5 years of experience managing query analytics visualization or data support efforts preferably in a federal environment.
• Demonstrated experience managing teams responsible for data ingestion ETL SQL-based queries and enterprise data platforms.
• Proven ability to oversee and validate complex analytical work including SQL-based analysis and machine learning outputs without serving as a hands-on developer.
• Experience supporting analytical rules development and leading impact assessments on large-scale datasets
• Strong understanding of relational databases data warehouses and query optimization concepts.
• Working knowledge of Databricks including its role in data engineering analytics and integration with downstream reporting and visualization tools.
• Strong understanding of relational databases data warehouses and query optimization best practices.
• Proven ability to manage multiple priorities in a fast-paced deadline-driven environment
• Excellent written and verbal communication skills with experience interfacing with government stakeholders.
• Current Project Management Professional (PMP) or the ability to obtain.

Clearance Requirements

• Top Secret Clearance
• DHS/CBP suitability (current or ability to obtain)
• U.S. Citizenship required

Preferred Qualifications

• 8 years of experience supporting federal programs with preference for DHS or CBP environments
• Experience supporting cloud-based big data platforms and advanced analytics environments
• Familiarity with CBP datasets operational metrics and mission systems
• Experience working under performance-based federal contracts.

Work Environment

• On-site support at CBP facilities (possible hybrid support as defined by the contract and CBP requirements).
• Occasional extended hours may be required to support mission-critical reporting or surge requirements.

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the worlds leading mission capability integrator and transformative enterprise IT provider we deliver trusted highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land sea space air and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day our employees do the cant be done by solving the most daunting challenges facing our customers. Visit to learn how were keeping people around the world safe and secure.