Data Engineer

Minimum Clearance Required to Start:
Top Secret SCI
Job Description:

Data Warehouse Engineers develop the data warehouse and/or data transformation processes to enable storing and retrieval of customer data. Data Engineer ingest data from internal and external sources and present that data for analytics and business intelligence. Data Engineers also main and administer application-specific databases. The Data Warehouse is currently implemented with the Data Vault 2.0 specification.

Duties include:
  • Design the logical data relationships and query structures of new databases considering factors such as access methods, access frequency, storage media, data volatility, query requirements, and operating environments to support insider threat detection application software and data analysis.
  • Develop logical data models translated into workable physical database schema and structures in the database development process to support insider threat detection application software and data analysis.
  • Design enterprise database strategies for functions such as backup, recovery and migration or to correct extremely complex operational and performance.
  • Implement new database designs using DataVault 2.0 methodology.
  • Evaluate data sets and engineer solutions for integrating into the Data Warehouse
  • Sustain existing Data Warehouse and application databases
  • Perform daily database administration functions such as developing queries and reports based on customer requirements, modifying or developing database views, and managing backup and recovery operations.
  • Develop, sustain and preserve user manuals and instructions that guide customers in executing data access functions such as running queries and reports.
  • Participate in multi-functional teams and manage work through JIRA.

  • Bachelors or equivalent experience in related field
  • Possess a minimum of seven (7) years of experience in Application Software and Extract Transform Load (ETL) and/or Data, Database and/or Data Warehouse implementations
  • Possess a minimum of three (3) years of experience in implementing, managing, and maintaining data warehouses
  • Possess experience with SQL and SQL Plus
  • Possess experience building and scheduling data integration scripts that automat ingest of data from multiple sources (Oracle, SQL, Postgres).
  • Possess experience using data Extract Transform Load (ETL) applications such as IBM DataStage and WhereScape.
  • Must have intermediate level proficiency in MS office products. (Word, Excel, PowerPoint, Outlook)
Must be able to obtain, maintain and/or currently possess a security clearance.
The position requires a COVID vaccination or an approved accommodation/exemption for a disability/medical condition or religious belief.