Data Engineer

Peraton is seeking a Data Engineer to join our team of qualified, diverse individuals. This position will be located in Herndon, VA with some remote work possible. The qualified applicant will become part of Peraton's Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Consular Affairs (CA). This initiative will modernize and consolidate the operational environment under a common technology framework in order to better support the services provided to CA's customers.

The Data Engineer is responsible for working with large datasets, verifying data is collected, stored, and processed in a reliable and optimized manner. The Data Engineers develop ETL processes, manage data warehouses, and confirm data integrity. This role collaborates closely with data scientists and analysts to provide clean, structured data that supports business insights and decision-making. Strong problem-solving skills and expertise in big data technologies are key to success in this role.

Roles and Responsibilities:

Work with the system engineering team to understand customer business needs and priorities.
• Implement Azure cloud analytics and databases, leveraging tools such as Azure Synapse, Azure SQL, Synapse pipelines, Databricks, and related frameworks
• Utilize data science tools such as Anaconda, R, Weka, and Synapse Analytics for advanced data processing modeling.
• Define system and technical requirements, including both functional and non-functional, to support database management system development within an Agile environment.
• Develop conceptual, logical, and physical designs for database solutions.
• Develop and maintain database solutions for managing structured and unstructured data.
• Develop and maintain database solutions for data ingestion (batch and streaming).
• Develop and maintain database scripts supporting ETL processes and functions.
• Monitor and tune database solutions for optimal performance.
• Develop and maintain secure database solutions that are compliant with DISA STIG and NIST specifications (security controls).
• Develop data analytic models, incorporating machine learning (ML), deep neural networks (DNN), and large language models (LLM) to support business objectives.
• Support CI/CD initiatives and utilize static code analyzers to ensure high quality source code.
• Author clear documentation for database solutions, including data dictionaries, data catalogs, and design artifacts.
• Integrate database solutions with the software applications and/or platforms.
• Support software testing activities, including IV&V, and provide timely software defect resolutions.
• Monitor production and non-production database solutions for performance and troubleshoot issues as required.
• Provide production and operational support, as needed, to ensure deployed database solutions meet functional and non-functional requirements.
• Develop and maintain backup/restore solutions to support production and non-production database solutions.

DOSCSM

Basic Qualifications:

• Bachelor's degree and eight (8) years' experience.
• At least 5 years of experience with developing relational database management systems (RDBMS) using Oracle, PostgreSQL, MySQL, or Microsoft SQL Server in a production environment.
• Experience in software development and maintenance projects with involvement in requirements management, technical design/development, and deployment steps within SDLC.
• Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment.
• Experience designing database solutions using conceptual, logical, and physical diagrams.
• Experience with developing database solutions involving storage of structured and unstructured data, data ingestion via batch and streaming, and ETL processes.
• Excellent communication skills, both verbally and in writing.
• Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment.
• Must be able to obtain or have an Active Secret (or higher) clearance. Interim clearances acceptable.

Preferred Qualifications:

• Experience with enterprise software system modernization efforts.
• Experience developing database solutions in an incremental manner using the Agile methodology.
• Experience in cloud-based environments including the development of database solutions that are based on a hybrid-cloud architecture.
• Experience developing database solutions for high volume, highly available, and secure software system.
• Experience developing database solutions in a secure environment that are required to meet DISA STIG and NIST specifications (security controls).
• Knowledge of software development methodologies, practices, and tools.
• Ability to work independently and in a team environment.

Peraton is a next-generation national security company that 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, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.