Responsibilities

Peraton is seeking a Data Engineer (Azure Synapse ETL/SQL) 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 Engineer will 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:

• Key Responsibility includes building and maintaining ETL pipelines using Azure Synapse.
• 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.

 

DOSCSM

Qualifications

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.
• Hands-on experience developing, testing and optimizing complex SQL scripts
• Hands-on experience with Azure Synapse Analytics for pipeline orchestration and/or SQL/Spark processing.
• 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.
• Must be able to obtain or have an Active Secret (or higher) clearance. Interim clearances acceptable.
• Must be a US Citizen.

 

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).
• Ability to work independently and in a team environment.

Peraton Overview

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.

Target Salary Range

$86,000 - $138,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.