Data Modeler

Job Description

Description

SAIC is seeking an experienced, results-oriented, mission-driven Data Modeler in support of a USG big data program that Extracts, Transforms, and Loads (ETL) incoming datasets for use by numerous down-stream systems and analysts. The qualified candidate will be part of an Agile team of multi-disciplinary engineers who support an effort to increase the speed of data delivery for structured and unstructured data in the interest and support of national security objectives.

RESPONSIBILITIES:

• Develop and maintain data models in accordance with customer requirements
• Perform periodic assessments of authorized data models for potential adjustments
• Support execution of the ETL process on periodic and one-time data sets to include conditioning and write out of the modified data sets
• Support analysis of conditioned data sets to ensure compliance with current data models

Qualifications

REQUIRED:

• Active TS/SCI with polygraph clearance
• Bachelor’s Degree in data science, computer science, information engineering, or a related subject - OR 4 additional years of relevant experience may be substituted in lieu of degree
• Experience with big data technologies and platforms, such as Databricks, AWS EMR, and Apache Spark to execute an Extract, Transform, and Load (ETL) mission
• Ability to develop and maintain data models and to map incoming data sets to the appropriate model
• Experience developing required database schemas containing windows, screens, tables and columns and reports that support the database model
• Requires experience using and creating SQL to include creating/querying tables, joining tables, and extracting data across multiple data sets
• Able to code in Python, PySpark, and Java
• Experience with Apache NiFi
• Able to write data sets to AWS S3 storage
• Able to identify technical problems and develop software updates and fixes
• Experience with Agile tools, such as JIRA, Confluence, Jenkins, and GitHub
• Must be creative problem solver and critical thinking skills

Overview

SAIC® is a premier Fortune 500® technology integrator focused on advancing the power of technology and innovation to serve and protect our world. Our robust portfolio of offerings across the defense, space, civilian and intelligence markets includes secure high-end solutions in mission IT, enterprise IT, engineering services and professional services. We integrate emerging technology, rapidly and securely, into mission critical operations that modernize and enable critical national imperatives.

We are approximately 24,000 strong; driven by mission, united by purpose, and inspired by opportunities. SAIC is an Equal Opportunity Employer, fostering a culture of diversity, equity and inclusion, which is core to our values and important to attract and retain exceptional talent. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $7.4 billion. For more information, visit saic.com. For ongoing news, please visit our newsroom.