Data Engineer

Hartford, CT, United States

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

Purpose and Scope:

Design, develop and implement enterprise data movement, transformation, and storage to facilitate application data migration / transfer and reporting structures.

Utilizes technologies to facilitate enterprise data pipelines, spark notebooks, dataflows, data lakes, SQL Serverless, and data warehouse processes and artifacts from internal and external application data sources.

Essential Responsibilities:

Focuses on data as an entity and does analysis on data in terms of content, integrity, and security.

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

Perform research and analysis of large data sets to include operational data and perform data validation and visualization and other statistical analyses.

Support change management activities for enterprise data analysis. Document all processes, models, and activities.

Perform all other position related duties as assigned or requested.

Work Environment, Physical Demands, and Mental Demands:

Typical office environment with no unusual hazards, occasional lifting to 20 pounds, constant sitting while using the computer terminal, constant use of sight abilities while reviewing documents, constant use of speech/hearing abilities for communication, constant mental alertness, must possess planning/organizing skills, and must be able to work under deadlines.

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:

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

US Citizenship is required

#LI-CJ1

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