Senior Extract Transform Load Engineer

ManTech

Ashburn, VA

Full Time

Senior

9 days ago

Job Description

About the Role

MANTECH seeks a motivated, career- and customer-oriented Senior Data ETL Engineer to join our innovative team in Ashburn, VA. This is a hybrid position with 2 days onsite and 3 days remote. The role involves applying big data solutions to support the massive flow of people, capital, and products entering and departing the United States via air, land, sea, and cyberspace, ensuring efficient trade and travel through data analysis, cloud techniques, and operational support.

Key Responsibilities

Data analysis of large database tables to understand the data structures, definitions, and patterns which will be used to support various predictive models.
Data analysis, problem solving, investigation and creative thinking with massive amounts of data supporting a variety of operational scenarios.
Implement cloud techniques and workflows (on-prem to cloud 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.
Research and document data definitions for all subject areas and primary datasets supporting the core business applications and responsible for source code control using GitLab.
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) operation.
Work closely with the client to assist in managing data needs and supporting collection of data needed for various operational needs.

Requirements

HS Diploma/GED with 15-20 years, AS/AA with 13-18 years, BS/BA with 7-12 years, MS/MA/MBA with 5-9 years, or PhD/Doctorate with 3-7 years of experience.
At least 8 years' experience in application development/full life cycle on data warehouse engagements.
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.
Experience in Extract-Transform-Load (ETL) development with 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.
Knowledge of Continuous Integration & Continuous Development (CI/CD) tools.

Nice to Have

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 ecosystem, including HDFS, YARN, Hive, Pig, and batch-oriented and streaming distributed processing methods such as Spark, Kafka, or Storm.
Experience with Databricks, Informatica, AWS Glue and/or similar services.
Experience with Atlassian suite of tools such as Jira and Confluence.
Ability to multitask efficiently and work comfortably in an ever-changing data environment.
Strong verbal/written communication and problem-solving skills, with the ability to communicate to groups at different technical skill levels.

Qualifications

U.S. citizen with the ability to obtain and maintain DHS CBP suitability prior to starting.

Working at ManTech

ManTech International Corporation and its subsidiaries proactively fulfill their role as an equal opportunity employer, providing consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. They support individuals requiring reasonable accommodations during the application process.

Apply Now