Parsons Corporation Data Engineer in Springfield, Virginia
Minimum Clearance Required to Start:
Top Secret SCI
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.
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 be able to obtain, maintain and/or currently possess a security clearance.
Parsons is an equal opportunity, drug-free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LGBTQ+. All qualified applicants will receive consideration for employment without regard to an individual’s race, color, religion, national origin, ethnicity, union affiliation, age, sex, sexual orientation, gender identity and expression, pregnancy, employable physical or mental disability, veteran status, genetic information, immigration status, or any other basis protected by all applicable laws.