Hybrid Data Modeler - Mid Level

As one of the world’s leading mission capability integrator and transformative enterprise IT providers, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our 22,000 employees “Do The Can’t Be Done”, solving the most daunting challenges facing our customers.

Peraton’s National Programs Business Intelligence Systems & Applications Operating Unit has a need for an experienced Data Modeler to support its SITE III JIOC contract charged with the orchestration, sustainment, and evolution of a portfolio of applications that focus on Collection Management, Intelligence Surveillance and Reconnaissance (ISR) and intelligence operations that directly support intelligence analysts, operations, and collection managers across the Combatant Commands.  The SITE III JIOC contract is designed to establish and ensure a multi-discipline approach to requirements engineering, solutions engineering, scheduling, reliability, resiliency, services development, integration, test and evaluation, maintainability and analysis across the National apparatus of Defense Intelligence, Combatant Commands, supporting Partner Nations and other Federal Agencies to ensure timely and accurate Joint Intelligence Operations (JIOC) collection, correlation and dissemination.  Our support team applies best practices in architecture design, data science, cloud services, DevSecOps and platform integration to develop, sustain and continually evolve the enterprise business systems environment, systems integration, and back-end business process workflows.

The successful candidate will perform the following:

• Ensures the successful implementation and day-to-day operation of database systems supporting critical Agency systems.
• Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications.
• Analyzes needs and requirements of existing and proposed systems, and develops technical, structural, and organizational specifications.
• May create standards and/or do modeling to monitor and enhance capacity and performance. Communicates with technical, applications, and operational staff, in order to design an optimal database architecture (performance, accessibility, backup, and recovery plan).
• Analyzes and makes recommendations for improvements to existing software regarding database performance, stability, usability and scalability.
• Performs logical and physical data modeling, designs relational database models and creates physical data models from logical data models.
• Designs database servers and interfaces to improve database and application performance.
• Supports the development effort by authoring stored procedures, functions, views and check constraints.
• Up to 50% remote work allowed

Requires 8 to 10 years with BS/BA or 6 to 8 years with MS/MA or 3 to 5 years with PhD.

Required Qualifications

• Requires a Bachelor's degree with 8 years of relevant experience. Additional experience may be considered in lieu of degree.
• Active TS/SCI
• Experience in applying data modeling principles/methods including conceptual, logical & physical data models
• Relational database experience
• 2+ years experience with AWS technologies including PostgresSQL and EC2
• ETL experience
• Experience with integrating multiple data feeds into a consolidated data source for access by users via UI and by systems, e.g., via API
• Experience with ER Studio Expertise or other similar modeling tools
• GraphQL experience

Desired Qualifications

• Experience with S3, DynamoDB, DocumentDB, ElasticSearch, Kafka, GeoServer
• DIA experience
• Understanding of the Intelligence Lifecycle and Collection Management mission space
• Familiarity with intelligence discipline data and Collection Management data and processes
• Familiarity with existing IC/Service systems in the Intelligence Lifecycle and Collection Management mission space
• Implementation of data-centricity and data fabric concepts
• Understanding of DoD/IC data standards
• Familiarity with securing/hardening data infrastructure
• Familiarity with IC Audit and Logging
• Current polygraph

Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our employees do the can’t be done, solving the most daunting challenges facing our customers.