Data Engineer (Azure Synapse ETL/SQL)

Program Overview

About The Role

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.

SCA / Union / Intern Rate or Range

Details

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.

Benefits Statement: Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at

Application Duration Statement: The application period for the job is estimated to be 30 days from the job posting date. However, this timeline may be shortened or extended depending on business needs and the availability of qualified candidates.

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