SME Data Engineer

Key Skills

AWS, Data Analysis, ETL frameworks, Google Cloud Platform (GCP), Linux Operating system, Machine learning techniques, MySQL, Optimization, Oracle, PLSQL, PostgreSQL, Unix Operating system

Job Description

Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, you’ll help protect our national security while working on innovative projects that offer opportunities for advancement.

Currently, ManTech is seeking a motivated, career and customer-oriented SME Data Engineer to join our team.

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 solutions to promote efficient trade and travel. Further, effective solutions help CBP ensure the movement of people, capital, and products is legal, safe, and secure. In response to this challenge, ManTech, as a trusted mission partner of CBP seeks capable, qualified, and versatile SME Data Engineers to help develop complex data analytical solutions for law enforcement personnel to assess risk of potential threats entering the country.

Responsibilities include, but are not limited to:

• Developing large volume data sets sourced from multitude of relational (Oracle) tables to allow data analysts and scientists to construct training sets for machine learned models and recurring reports & dashboards.
• Working closely with government client and technical teams (DBA’s etc.) to assist in creating/managing/optimizing scheduled Extract, Transform and Load (ETL) jobs and workflows.
• Data analysis, problem solving, investigation and creative thinking to manage very large datasets to be used in variety of formats for varying analytical products.
• Assist with the implementation of data migration/pipelines from on-prem to cloud/non-relational storage platforms.
• Respond to data queries/analysis requests from various groups within an organization. Create and publish regularly scheduled and/or ad hoc reports as needed.
• Researching and documenting data definitions and provenance for all subject areas and primary data sets supporting the core business applications.
• Responsible for data engineering source code control using GitLab.

Basic Qualifications:

• Experience with relational databases and knowledge of query tools and/or BI tools like Power BI or OBIEE and data analysis tools.
• Experience with the Hadoop eco system, including HDFS, YARN, Hive, Pig, and batch-oriented and streaming distributed processing methods such as Spark, Kafka, or Storm.
• Strong experience in automating ETL jobs via UNIX/LINUX shell scripts and CRON jobs.
• Demonstrate a strong practical understanding of data warehousing from a production relational database environment.
• Strong experience using analytic functions within Oracle or similar tools within non-relational (MongoDB, Cassandra etc.) database systems.
• Experience with Atlassian suite of tools such as Jira and Confluence
• Knowledge of Continuous Integration & Continuous Development tools (CI/CD).
• Must be able to multitask efficiently and progressively and work comfortably in an ever-changing data environment. 
• Must work well in a team environment as well as independently.
• Excellent verbal/written communication and problem solving skills; ability to communicate information to a variety of groups at different technical skill levels.

Preferred Qualifications:

• 5+ years of experience in developing, maintaining and optimizing complex Oracle PL/SQL packages to aggregate transactional data for consumption by data science/machine learning applications.
• 10+ years of experience in working in large (80+ TB) complex data warehousing environment. Must have full life cycle experience in design, development, deployment and monitoring.
• Experience with one or more relational database systems such as Oracle, MySQL, Postgres, SQL server, with heavy emphasis on Oracle.
• Experience in architecting data engineering pipelines/data lakes within cloud services (AWS, GCP etc.).
• Experience with Amazon S3, Redshift, EMR and Scala.
• Experience with migrating on-prem legacy database objects and data to the Amazon S3 cloud environment.
• Strong experience in converting JSON documents to targets such as Parquet, Postgres, and Redshift.
• Experience or familiarity with data science/machine learning and development experience for supervised and unsupervised learning with structure and unstructured datasets.

Education:

• HS Diploma/GED and 20+ years
• AS/AA and 18+ years
• BS/BA and 12+ years
• MS/MA/MBA and 9+ years
• PhD/Doctorate and 7+ years

Certification:

• None

Security Clearance Requirements:

• Must be a U.S Citizen with the ability to obtain DHS CBP Suitability and Top Secret clearance
• DHS Suitability required before start

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.

The projected compensation range for this position is $155,200-$257,900. There are differentiating factors that can impact a final salary/hourly rate, including, but not limited to, Contract Wage Determination, relevant work experience, skills and competencies that align to the specified role, geographic location (For Remote Opportunities), education and certifications as well as Federal Government Contract Labor categories. In addition, ManTech invests in it’s employees beyond just compensation. ManTech’s benefits offerings include, dependent upon position, Health Insurance, Life Insurance, Paid Time Off, Holiday Pay, Short Term and Long Term Disability, Retirement and Savings, Learning and Development opportunities, wellness programs as well as other optional benefit elections.

For all positions requiring access to technology/software source code that is subject to export control laws, employment with the company is contingent on either verifying U.S.-person status or obtaining any necessary license. The applicant will be required to answer certain questions for export control purposes, and that information will be reviewed by compliance personnel to ensure compliance with federal law. ManTech may choose not to apply for a license for such individuals whose access to export-controlled technology or software source code may require authorization and may decline to proceed with an applicant on that basis alone.

ManTech International Corporation, as well as its subsidiaries proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active Duty Wartime or Campaign Badge Veteran, Armed Forces Services Medal, or any other characteristic protected by law.