Data Engineer

Data EngineerLocation: Chantilly, VAType: ContractClearance: Active TS/SCI w/ Polygraph needed to applyCompany Overview: Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation's toughest and most secure problems. If you are looking for a place to not only be professionally challenged, but encouraged and supported by a company that cares, don't look any further than Cornerstone Defense.Benefits Overview: Cornerstone Defense offers a very comprehensive benefits package including, but not limited to: Medical, Dental and Vision Plans * Generous PTO Policy * 401(k) * HSA and FSA options * Life and Disability Insurance * Tuition Reimbursement and Training * Perks at Work Discount Program * Referral Program * Leads Generation Program * CollegeAmerica 529 * Fitness Reimbursement Program * Travel Assistance * Norton Lifelock Benefit Solutions * Life Planning Financial & Legal ServicesDevelop new tools, code, and services to execute data engineering activities involving data of varying types and in varying conditions. Activities include the following tasks: Movement of structure and unstructured data using approved methods. Execute data ingestion activities for storing data in a local or enterprise level location. Develop code to format data that supports exploration. Analyze source data formats and work with Data Scientists and partners to determine the formats and transforms that best meet mission objectives. Develop code and tools to provide one-time and on-going data extraction from various repositories, formatting and transformations into enterprise or standalone data models. Develop new ETL and perform O&M and enhancements on existing ETL code using best practices/standards. Develop and deliver documentation for each project including ETL mappings, code use guide, code location and access instructions.Design and optimize Data Pipelines using tools such as Spark, Apache Iceberg, Trino, OpenSearch, EMR cloud services, NiFi and Kubernetes containersEnsure the pedigree and provenance of the data is maintained such that the access to data is protectedClean and preprocess data to enable access for advanced analyticsCollaborate with enterprise working groups to advance the state of data standardsCollaborate with the engineering team, data stewards, and mission partners to aid in getting actionable value out of the data holdingsCollaborate with software engineers to update, configure, and maintain data services based on the requirementsEnsure data quality by working with the testing and data quality team to enhance standardization of data conditioning pipelinesExperience adapting to various types and formats of data, and working with development teams to integrate new data processing platformsRequired Skills:10+ years' experience with:Data lifecycle engineeringDevelopment and maintenance of extract, transform and load (ETL) tools and servicesCloud and on-prem data storage and processing solutionsPython, SQL, Spark and other data engineering programmingCOTS and open source data engineering tools such as ElasticSearch and NiFiProcessing data within the Agile Lifecycle