Data Engineer

General information

Description & Requirements

ManTech seeks a motivated, career- and customer-oriented Subject Matter Expert Data Engineer to join our innovative team in Ashburn, VA. This is a hybrid position with 2 days onsite and 3 days remote.

Each day U.S. Customs and Border Protection (CBP) oversees the massive flow of people, capital, and products that enter and depart the United States via air, land, sea, and cyberspace. The volume and complexity of both physical and virtual border crossings require the application of “big data” solutions to promote efficient trade and travel. Further, effective solutions help CBP ensure the legal, safe, and secure movement of people, capital, and products. In response to this challenge, ManTech, as a trusted mission partner of CBP, seeks capable, qualified, and versatile Data Engineer subject matter experts (SMEs) to facilitate data-driven decision making in response to national security threats.

Responsibilities include but are not limited to:

• Responsible for data analysis of large database tables to understand the data structures, definitions, and patterns which will be used to support various predictive models.
• Work closely with the client to assist in managing data needs and supporting collection of data needed for various operational needs.
• Data analysis, problem solving, investigation and creative thinking with massive amount of data supporting variety of operational scenarios and responsible for source code control using GitLab.
• Implement cloud techniques and workflows (on-prem to cloud platforms).
• Respond to data queries/analysis requests from various groups within the organization. Create and publish regularly scheduled and/or ad hoc reports as needed.
• Research and document data definitions for all subject areas and primary datasets supporting the core business applications.
• Demonstrate a strong practical understanding of application-relevant cargo and passenger data and databases used to support analytic application development, functionality, and targeting end user (officer) operations.

Minimum Qualifications:

• HS Diploma/GED and 20+ years or AS/AA and 18+  years or BS/BA and 12+ years or MS/MA/MBA and 9+ years or PhD/Doctorate and 7+ years
• Experience in application development/full life cycle on Data Warehouse engagements  and at least 5 years’ experience in large (80TB+) and complex data warehousing architecture, design and implementation/migration
• Experience with one or more relational database systems such as Oracle, MySQL, Postgres, SQL server, etc. and experience in Extract-Transform-Load (ETL) development and knowledge of ETL concepts, tools, and data structures
• Experience with cloud platforms like Amazon Web Services (AWS), Microsoft Azure, etc. and migrating customers/projects to the cloud and experience with one of the modern Cloud DW like Redshift, Databricks or BigQuery.
• Experience working in Unix/Linux environment and with shell scripting and scheduling CRON jobs
• Experience with Database query tuning and other performance enhancement methodology is a plus.
• Experience with NoSQL database (MongoDB or DynamoDB or DocumentDB).

Preferred Qualifications:

• Knowledge of Continuous Integration & Continuous Development tools (CI/CD).
• Ability to multitask efficiently and progressively and work comfortably in an ever-changing data environment.
• Ability to work well in a team environment as well as independently.
• Have excellent verbal/written communication and problem-solving skills and ability to communicate information to a variety of groups at different technical skill levels.
• Experience with relational databases and knowledge of query tools and/or BI tools like Power BI or Business Objects (BO) and data analysis tools.
• Experience with the Hadoop ecosystem, including HDFS, YARN, Hive, Pig, and batch-oriented and streaming distributed processing methods such as Spark, Kafka, or Storm.
• Experience with Atlassian suite of tools such as Jira and Confluence.

Clearance Requirements:

• Must be a U.S. citizen with the ability to obtain DHS CBP suitability prior to starting this position.

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.