Data Integration Engineer

Amentum - Trenton, NJ

Full-time

Trenton, NJ

Professional, Scientific, and Technical Services

About the position

Amentum is seeking a dynamic and motivated Data Integration Engineer to design, develop, and implement enterprise data integration and pipeline architectures. This role focuses on facilitating the collection, storage, and management of data for various analytical, operational, and decision-making purposes, ensuring appropriate integration between Amentum systems and external data sources.

Responsibilities

• Design and implement data integration and pipeline architectures.
• Develop and maintain ETL processes and data workflows.
• Select and implement suitable integration methods for enterprise needs.
• Create and enforce data quality checks to ensure accuracy and integrity of integrated data.
• Collaborate with data engineers and analysts to understand data needs.
• Optimize data integration processes for improved performance and reliability.
• Implement data privacy and security measures in compliance with regulations.
• Troubleshoot and resolve issues related to data integration.
• Document data integration processes for clarity and maintainability.
• Design data storage and access methods for different data regimes.
• Recommend and implement improvements for data reliability and quality.
• Process, clean, and verify the integrity of enterprise data sets.
• Design and operate data management systems for business intelligence needs.
• Plan and optimize data throughput and query performance.
• Build data and analytics proofs for deeper insights into datasets.

Requirements

• Bachelor's degree in Computer Science or related field and 5 years of experience.
• Excellent communications and analytical skills.
• Demonstrated working knowledge of Microsoft SQL (T-SQL), Oracle SQL (PL-SQL), Azure Synapse, Azure ADLS, Azure Pipelines, Azure Spark Notebooks, REST API, JSON Files, Parquet Files, Delta Lake Files, Data Vault 2.0, SQL Serverless, Synapse Data Warehouse, Microsoft DevOps and GitHub, Agile Development, Data Encryption/Decryption, API-based Integration, and File transfer Tools.
• Experience with integration tools such as MuleSoft, Boomi, WebsphereMQ, RabbitMQ, or Apigee.
• Knowledge of various integration patterns and event-driven integration.