Data Integration Engineer

Sacramento, CA, United States

Amentum is seeking a dynamic, motived, energetic and driven Data Integration Engineer! US Citizenship is required to apply.

Design, develop and implement enterprise data integration and pipeline architectures to facilitate the collection, storage, and management of data for various analytical, operational, and decision-making purposes. Utilizes technologies to facilitate implementation of various integration patterns to ensure appropriate integration between Amentum systems including enterprise data pipelines, spark notebooks, dataflows, data lakes, SQL Serverless, messaging, API’s and data warehouse processes and artifacts from internal and external data sources.

Essential Responsibilities:

Focuses on data integration between key business data sources, applications, services, and systems.

Works on design and implementation of data flows/pipelines – focuses on control and optimization of data movement and transformation.

Works on data integration between different systems or source/sink requirements.

Specific Job Duties:

Design and implement data integration and pipeline architectures to facilitate the collection, storage, and management of data from various sources and systems.

Develop and maintain ETL (Extract, Transform, Load) processes and data workflows that ensure efficient and error-free data transfer between systems.

Select and implement suitable integration methods for various enterprise needs.

Create and enforce data quality checks and balances to ensure accuracy and integrity of integrated data.

Collaborate with data engineers and analysts to understand data needs and deliver tailored data resources for analytics and reporting purposes.

Optimize data integration processes for improved performance, scalability, and reliability, utilizing best practices in data engineering.

Implement data privacy and security measures in compliance with regulatory requirements and company policies.

Troubleshoot and resolve issues related to data integration, including performance bottlenecks and data discrepancies.

Document data integration processes, including data flow diagrams and data models, to ensure clarity and maintainability for future modifications.

Design, develop, test, and manage the overall framework to facilitate analysis and processing of enterprise data working closely with the Data Architect to direct and optimize the flow of data within the framework and ensure consistency of data delivery and utilization across multiple projects.

Design how data will be stored, accessed, used, integrated, and managed by different data regimes and digital systems, working with data users to determine, create, and populate optimal data architectures, structures, and systems.

Recommend and implement ways to improve data reliability, efficiency, and quality; shall evaluate, compare, and improve the different approaches including the design patterns innovation, data lifecycle design, data ontology alignment, annotated datasets, and elastic search approaches.

Process, clean, and verify the integrity, accuracy, completeness, and uniformity of enterprise data sets, integrating external or new datasets into existing datasets, as required.

Design, implement, and operate data management systems for business intelligence needs.

Plan, design, and optimize data throughput and query performance.

Build data and analytics proofs that will offer deeper insight into datasets, allowing for critical discoveries surrounding key performance indicators and user activity.

Quality - Quality is the foundation for the management of our business and the keystone to our goal of customer satisfaction. It is our policy to consistently provide services that meet customer expectations. Accordingly, each employee must conform to the Amentum Quality Policy and carry out job activities in compliance with applicable Amentum Quality System documents and customer contracts. Each employee must read and understand his/her Quality Management and Customer Satisfaction responsibilities.

Procedure Compliance - Each employee must read, understand, and implement the general and specific operational, safety, quality and environmental requirements of all plans, procedures and policies pertaining to his/her job.

Required -

Bachelor's degree in Computer Science or related field and 5 years of experience.

Excellent communications and analytical skills.

US Citizenship is required to apply.

Demonstrated working knowledge and experience with several of the following technologies/tools:

Microsoft SQL (T-SQL)

Oracle SQL (PL-SQL)

Azure Synapse

Azure ADLS

Azure Pipelines

Azure Spark Notebooks (SCALA, Python, Spark SQL)

REST API

JSON Files

Parquet Files

Delta Lake Files

Data Vault 2.0

SQL Serverless

Synapse Data Warehouse (MPP - Dedicated)

Microsoft DevOps and GitHub

Agile Development

Data Encryption / Decryption

API-based Integration, API Management

File transfer Tools such as GoAnywhere

Experience with one or more of the following - MuleSoft, Boomi, WebsphereMQ, RabbitMQ, or Apigee.

Knowledge of various integration patterns including appropriate application of Asynchronous vs Synchronous integration.

Knowledge and application of Event driven integration.

Amentum is proud to be an Equal Opportunity Employer. Our hiring practices provide equal opportunity for employment without regard to race, religion, color, sex, gender, national origin, age, United States military veteran’s status, ancestry, sexual orientation, marital status, family structure, medical condition including genetic characteristics or information, veteran status, or mental or physical disability so long as the essential functions of the job can be performed with or without reasonable accommodation, or any other protected category under federal, state, or local law.

Labor Law Posters (https://postings.govdocs.com/#/vxSkbztPuAwwxfs)

EEO including Disability/Protected Veterans