Cornerstone Defense
Data Engineer
Cornerstone Defense, Herndon, Virginia, United States, 22070
Location: Herndon, VirginiaType: ContractJob #3320
Data Engineer/ScientistTS/SCI w/ POLYGRAPHChantilly, VAPosition Description:
JOB DUTIES:• Recommend to the Sponsor, changes to current applications and databases based on Sponsor requirements.• Recommend to the Sponsor, modernization options for data hosting, data cleansing, data transport, data exposure and data ingestion at an enterprise scale• Make recommendations to the Sponsor for modernization with a focus on performance, security, and cost, with the flexibility to store and manage large volumes of disparate, enterprise datasets while identifying the authoritative dataset and reducing dataset duplication.• Manage enhancements and improvements to current data systems technology and processes, including data access authorizations against enterprise-approved user attributes and solutions with Sponsor oversight.• Provide operations and maintenance of databases in the cloud infrastructure.• Support Sponsor's representatives in cloud environment purchase, engineering, and architecture related activities as applicable to applications and databases.• Execute development, design and creation of database systems that enable storage and smooth retrieval of data.• Ensure the smooth and secure running of the Sponsor's enterprise database systems.• Collaborate with team members, external stakeholders, and data stewards to define the current state of Sponsor data.• Build data models that are optimized for reporting from a data warehouse.REQUIRED SKILLS:• Demonstrated experience utilizing Oracle, PostgreSQL and modern database technologies.• Demonstrated experience with Tableau, COGNOS and modern technologies for reporting presentation.• Demonstrated experience performing testing and quality assurance of developed solutions within the existing Oracle data tier.• Demonstrated experience developing, creating, and modifying data structure and data load routines for analytic use cases.• Demonstrated experience working with relational data tiers including cleansing, transforming and processing of structured data.• Demonstrated experience working with views, triggers and Oracle PL and SQL.• Demonstrated knowledge of Amazon Web Services environments, including RDS, S3, etc.DESIRED SKILLS:• Demonstrated experience with IMMUTA data policy.• Demonstrated experience with a variety of data repository types (i.e., relational, NoSQL, distributed processing framework, etc.).• Demonstrated experience creating and interfacing with REST APIs.
Data Engineer/ScientistTS/SCI w/ POLYGRAPHChantilly, VAPosition Description:
JOB DUTIES:• Recommend to the Sponsor, changes to current applications and databases based on Sponsor requirements.• Recommend to the Sponsor, modernization options for data hosting, data cleansing, data transport, data exposure and data ingestion at an enterprise scale• Make recommendations to the Sponsor for modernization with a focus on performance, security, and cost, with the flexibility to store and manage large volumes of disparate, enterprise datasets while identifying the authoritative dataset and reducing dataset duplication.• Manage enhancements and improvements to current data systems technology and processes, including data access authorizations against enterprise-approved user attributes and solutions with Sponsor oversight.• Provide operations and maintenance of databases in the cloud infrastructure.• Support Sponsor's representatives in cloud environment purchase, engineering, and architecture related activities as applicable to applications and databases.• Execute development, design and creation of database systems that enable storage and smooth retrieval of data.• Ensure the smooth and secure running of the Sponsor's enterprise database systems.• Collaborate with team members, external stakeholders, and data stewards to define the current state of Sponsor data.• Build data models that are optimized for reporting from a data warehouse.REQUIRED SKILLS:• Demonstrated experience utilizing Oracle, PostgreSQL and modern database technologies.• Demonstrated experience with Tableau, COGNOS and modern technologies for reporting presentation.• Demonstrated experience performing testing and quality assurance of developed solutions within the existing Oracle data tier.• Demonstrated experience developing, creating, and modifying data structure and data load routines for analytic use cases.• Demonstrated experience working with relational data tiers including cleansing, transforming and processing of structured data.• Demonstrated experience working with views, triggers and Oracle PL and SQL.• Demonstrated knowledge of Amazon Web Services environments, including RDS, S3, etc.DESIRED SKILLS:• Demonstrated experience with IMMUTA data policy.• Demonstrated experience with a variety of data repository types (i.e., relational, NoSQL, distributed processing framework, etc.).• Demonstrated experience creating and interfacing with REST APIs.