BASF Veterans Jobs

Job Information

Amentum Data Integration Engineer in Lansing, Michigan

Amentum is seeking a dynamic, motived, energetic and driven Data Integration Engineer!

US Citizenship is required to apply. This is a remote-telework role.

Design, develop and implement enterprise data integration architectures to facilitate the data communication, collection, storage, and management. Utilizes technologies to facilitate enterprise data APIs, spark notebooks, dataflows, data lakes, SQL Serverless, 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 utilizing API-based architecture.

  • Key focus is the oversight of API development, management, security, orchestration within the application-to-application integration and application to data warehouse environments.

Specific Job Duties:

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

  • 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.

  • 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.

  • Design how data will be stored, accessed, used, integrated, and managed by different data regimes and digital systems, working with data engineers and application subject matter experts to determine, create, and populate optimal data architectures, structures, and systems.

  • 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.

  • 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.

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

  • Perform all other position related duties as assigned or requested.

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.

Minimum Position Knowledge, Skills, and Abilities Required:

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

Excellent communications and analytical skills; demonstrated working knowledge and experience of several of the following technologies/tools is desired:

  • API-based Integration, API Management

  • File transfer Tools: GoAnywhere, MuleSoft, Boomi, WebsphereMQ, RabbitMQ, Apigee.

  • REST/SOAP API

  • Knowledge of Async vs Sync integration

  • Event driven integration

  • Microsoft SQL (T-SQL)

  • Oracle SQL (PL-SQL)

  • Azure Synapse

  • Azure ADLS

  • Azure Pipelines

  • Azure Spark Notebooks (SCALA, Python, Spark SQL)

  • 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

US Citizenship is required to apply. This is a remote-telework role.

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, gender identity, 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. Learn more about your rights under Federal EEO laws and supplemental language at EEO including Disability/Protected Veterans (https://www.dol.gov/agencies/ofccp/posters) and Labor Laws Posters (https://protect-us.mimecast.com/s/MI5TC2kqOqsOBPMVfnZ32U) .

DirectEmployers