Job Closed
This listing is no longer active.
Peraton Corporation, a national security company headquartered in Herndon, Virginia, supplies solutions for mission-critical programs and systems. Founded in 2017, Peraton's missio
Data Engineer (Azure Synapse ETL/SQL)
Location
United States
Posted
97 days ago
Salary
$86K - $138K / year
No structured requirement data.
Job Description
Data Engineer (Azure Synapse ETL/SQL)
Peraton Corporation
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.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This role involves developing, designing, and maintaining Power BI dashboards, reports, and data visualizations based on business requirements. - Build efficient data models (star schema, semantic models) using Power BI and Microsoft Fabric components. - Work with Microsoft Fabric features such as Lakehouse, Data Engineering pipelines, Dataflows Gen2, and Warehouse where applicable. - Optimize datasets, visuals, DAX queries, and report performance. - Collaborate with business stakeholders and technical teams to gather requirements and translate them into scalable reporting solutions. - Ensure data accuracy, governance, and compliance with organizational standards. - Troubleshoot issues related to datasets, refresh failures, permissions, and report performance. - Support the modernization of analytics platforms and the adoption of Microsoft Fabric within the KPMG ecosystem. Qualifications - A minimum of three years of experience as a Power BI Developer (or similar analytics role). - Strong proficiency in: - Power BI Desktop - Power BI Service (Workspaces, Gateways, Deployment Pipelines) - DAX (advanced level) - Power Query (M Language) - Hands-on experience in Microsoft Fabric, including at least one of the following: - Lakehouse - Data Engineering / Pipelines - Dataflows Gen2 - Warehouse - Strong understanding of data modeling, relational & dimensional modeling concepts. - Experience working with large datasets and optimizing report performance. - Ability to work independently, communicate clearly, and collaborate with cross-functional teams. Requirements - Experience with Azure data ecosystem (Azure Data Lake, Synapse, Databricks, ADF). - Background supporting enterprise analytics for finance, audit, or consulting environments. - Familiarity with CI/CD for Power BI and governance best practices.
System Engineer
DeltekDeltek is a leading provider of information solutions and enterprise software. Founded in 1983 by father-and-son team Donald and Kenneth deLaski, Deltek serves more than 15,000 cli
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description Deltek’s Enterprise Data & Intelligence organization is seeking a forward-thinking Semantic Developer to define and scale the enterprise semantic layer that powers trusted analytics, AI enablement, and operational decision-making across the company. This role operates at the intersection of business strategy, data architecture, and analytics engineering, designing and operationalizing enterprise-grade semantic models in Snowflake and Power BI. The Semantic Developer acts as both architect and translator, partnering with business leaders, analysts, data engineers, and AI teams to ensure the enterprise data cloud reflects a common language and supports scalable analytics and AI innovation. - Build and maintain semantic views in Snowflake as the foundation for Power BI semantic models. - Design and develop enterprise-grade semantic models in Power BI aligned with business requirements and analytics needs. - Collaborate with Data Engineering teams to ensure optimal data pipeline architecture and integration with semantic layers. - Establish and enforce best practices for semantic model design, including naming conventions, relationships, and calculation logic. - Serve as the primary liaison between business users, data strategists, technical teams, and decentralized development teams. - Partner closely with business stakeholders to understand reporting and analytics requirements. - Facilitate productive dialogue between technical and non-technical teams, ensuring all voices are heard and understood. - Translate business needs into technical specifications and vice versa. - Identify opportunities where semantic model improvements can drive business value and competitive advantage. - Design and deliver workshops to educate business users on leveraging the semantic layer for self-service analytics. - Create comprehensive documentation and training materials for semantic model usage. - Provide ongoing support and guidance to users adopting self-service reporting practices. - Develop governance frameworks that empower users while maintaining data integrity and security. - Integrate the Snowflake semantic layer with downstream BI tools, including Power BI. - Support Snowflake Cortex Analyst capabilities, enabling natural language querying on governed semantic models. - Implement DAX calculations, measures, and KPIs to support business intelligence needs. - Optimize model performance and ensure scalability as data volumes grow. - Maintain version control and documentation for all semantic model components. Qualifications - 3-5 years of hands-on experience with Power BI development, with significant focus on semantic model design. - Proven experience working with Snowflake, including creating and optimizing semantic views. - Strong understanding of data pipelines and ETL/ELT processes. - Proficiency in DAX (Data Analysis Expressions) and M Query language. - Experience with data modeling concepts including star schema, snowflake schema, and dimensional modeling. - Demonstrated ability to work collaboratively with business stakeholders and translate requirements into technical solutions. - Experience conducting user training sessions and workshops. - Strong documentation and communication skills. - Ability to explain complex technical concepts to non-technical audiences. - Understanding of data governance and security best practices. - Experience with version control systems and development lifecycle management. - Ability to manage multiple priorities and work independently in a fast-paced environment. - Exceptional interpersonal and communication skills, including active listening and synthesizing diverse perspectives. - Experience facilitating meetings, workshops, and training sessions with groups ranging from 5-50+ participants. - Demonstrated business acumen with ability to understand industry trends, business metrics, and organizational objectives. - Comfortable navigating ambiguity and mediating between competing priorities. Preferred Qualifications - Experience with Cloud data platforms. - Experience with other BI tools or data visualization platforms. - Knowledge of SQL and database design principles. - Familiarity with Agile/Scrum methodologies. - Certification in Power BI or related Microsoft technologies. - Experience with data governance frameworks and metadata management. Compensation Info The U.S. salary range for this position is $72,000.00-$130,000.00. This range is subject to change as Deltek takes a number of factors into consideration when determining individual base pay, such as location, job-related knowledge, skills and experience. Certain roles are eligible for additional rewards, including incentive compensation and equity. Benefits - Employees have access to healthcare benefits. - 401(k) plan and company match. - Paid vacation time and holidays. - Well-living programs. - Short-term and long-term disability coverage. - Basic life insurance. - Tuition reimbursement.
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This role involves developing and maintaining ETL processes using Snowflake. - Develop and maintain ETL processes using Snowflake - Design and implement data models and schemas in Snowflake - Optimize and tune Snowflake queries for performance - Collaborate with data analysts and business stakeholders to understand data requirements - Ensure data quality and integrity across the Snowflake environment Qualifications - Bachelor’s degree in Computer Science, Data Science, or a related field - At least 9 years of experience working with Snowflake - Strong SQL skills and experience with data warehousing concepts - Experience with ETL tools and processes - Knowledge of cloud platforms (AWS, Azure, GCP) is a plus Requirements - Strictly no C2C / 1099 / third-party companies; all roles are W2 only - Coding test is required for every role - At least 3 to 5 years of real-time experience preferred Company Description Bright Vision Technologies is a forward-thinking software development company dedicated to building innovative solutions that help businesses automate and optimize their operations. We leverage cutting-edge technologies to create scalable, secure, and high-performance applications.
HCM Data Migration Middleware Developer
CACI International IncExpertise and Technology for National Security
• Design and develop ETL pipelines using Oracle Integration Cloud (OIC), Informatica, Talend, or equivalent middleware tools to transform extracted legacy HR data into Oracle Fusion HCM HDL and HSDL load file formats • Build data transformation rules that map legacy data values (codes, descriptions, hierarchies) to Oracle Fusion HCM reference data, value sets, and lookup values for each agency migration • Develop data cleansing pipelines that identify and remediate data quality issues including missing required fields, invalid date formats, duplicate records, and referential integrity violations before target system loading • Design and implement batch processing frameworks capable of handling large-volume agency migrations ranging from small to very large agency employee populations with configurable parallelism and restart/recovery capabilities • Build comprehensive error handling and exception management within ETL pipelines including error categorization, automated retry logic, and error reporting dashboards for migration teams • Develop data reconciliation processes that compare source record counts, key data element values, and business rule validations between legacy extracts, transformation outputs, and target system loaded records • Create and maintain data quality dashboards providing real-time visibility into migration pipeline status, error rates, data completeness metrics, and reconciliation results for each agency migration wave • Design reusable transformation templates and parameterized mapping configurations that accelerate successive agency migrations by leveraging patterns from completed migrations • Collaborate with legacy system export developers (PeopleSoft/EBS team) to define extraction file formats, handoff procedures, and data interface specifications • Support iterative mock migration cycles (typically 3-4 per agency) and final cutover data loads, optimizing pipeline performance and resolving data quality issues identified in each cycle • Document ETL design specifications, transformation rules, data flow diagrams, and operational runbooks for each agency migration in accordance with SAFe Agile artifact standards • Apply established methods, standards, and practices to independently resolve functional and technical issues of moderate scope, contributing to team knowledge bases and consulting with senior staff on complex or unfamiliar problems as they arise • Communicate effectively with project team members and direct stakeholders to report progress, explain technical approaches, and support collaborative problem-solving within assigned workstreams and Agile Release Train ceremonies


