Automation Engineer in Albuquerque

Energy Jobline ZR; Albuquerque (NM); On-site; USD 95,000 - 130,000; Full time

Job summary

Edgewater Federal Solutions is seeking an Automation Engineer to support a major laboratory. The candidate should have hands-on experience with automation tools such as Ansible, Puppet, and Chef, and with UNIX/Linux/Windows OS, scripting, and data queries.

Responsibilities include building data pipelines and APIs, and integrating data across on‑premises databases and cloud platforms (AWS/Azure/GCP). DOE clearance is required; candidates must reside in Albuquerque or relocate by start date.

Qualifications

• BS in a relevant discipline and at least 3 years of related experience.
• Ability to obtain and maintain a DOE security clearance.
• Must be US-based and able to reside in Albuquerque or relocate by start date.
• Experience with automation technologies such as Ansible, Puppet, or Chef.
• Strong Python and SQL programming skills.
• Experience designing and consuming RESTful APIs.
• Experience with ETL/ELT tools (dbt, PySpark).
• 3+ years in data engineering, data pipeline development, and tool evaluation.
• Excellent problem-solving and cross-functional collaboration.

Responsibilities

• Evaluate and recommend data ingestion and pipeline tools.
• Design and implement data pipelines to ingest, process, and transform data.
• Develop and manage data orchestration workflows.
• Design, develop, and maintain APIs to enable data integration.
• Work with on-premises databases and cloud platforms to support data architectures.
• Integrate data pipelines with various applications.
• Collaborate with DBAs, solution architects, and stakeholders.
• Implement and manage data virtualization solutions (Denodo preferred).
• Ensure data quality, security, and compliance throughout the data lifecycle.
• Document processes and architectures for data engineering workflows.

Skills

Automation tools

Python

SQL

REST APIs

ETL/ELT

Data engineering

Problem solving

Education

BS in relevant discipline

Tools

Ansible

Puppet

Chef

dbt

PySpark

Job description

Job DescriptionJob Description

Edgewater Federal Solutions is seeking an Automation Engineer to support a major laboratory.

We are seeking someone with experience with automation and orchestration tools such as Ansible, Puppet, and Chef. Experience in UNIX, Linux, and/or Windows Operating System (OS), including file management, scripting, editing, and security. Experience with a variety of programming , software, or tools to develop regular or ad-hoc queries from large datasets. Familiar with networkcommunication protocols, and other related protocols. Ability to implement solutions integrating Rest application program interface (API) based web services.

Responsibilities

• Evaluate and recommend data ingestion and pipeline tools (open source and vendor solutions) to support scalable data workflows.
• Design and implement data pipelines to ingest, process, and transform structured and unstructured data from diverse sources.
• Develop and manage data orchestration workflows using open-source or COTS tools to automate and monitor complex data pipelines.
• Design, develop, and maintain APIs or leverage existing APIs to enable seamless data integration across COTS, custom-built applications, and data platforms.
• Work with both on-premises infrastructure (Oracle/Microsoft databases, MongoDB) and cloud platforms (AWS, Azure, GCP, or others) to support current and future data architectures.
• Integrate data pipelines with various applications, ensuring seamless data flow and interoperability.
• Collaborate with database administrators, application owners, solution architects, and other stakeholders to understand data requirements and deliver robust solutions.
• Implement and manage data virtualization solutions, with a preference for experience in Denodo.
• Ensure data quality, security, and compliance throughout the data lifecycle.
• Document processes, architectures, and best practices for data engineering workflows

Qualifications

• BS in relevant discipline plus minimum 3 years or more years of directly related experience that demonstrates the knowledge, skills, and ability to perform the duties of the job.
• Must be able to obtain and maintain a DOE Security Clearance
• Must be US
• Work is performed onsite and therefore candidate must reside in the Albuquerque area or be willing to relocate by start date

Required Skills:

• Knowledge in automation technologies such as Ansible, Puppet, or Chef.
• Strong programming skills in Python and SQL.
• Experience designing, developing, and consuming RESTful APIs and other API technologies to facilitate data integration and interoperability.
• Experience with ETL/ELT tools and frameworks (e.g., dbt, PySpark).
• Proven experience (3+ years) in data engineering, data pipeline development, and tool evaluation.
• Excellent problem-solving skills and ability to work collaboratively in a cross-functional team.

Desired Skills:

• Knowledge of data virtualization concepts and experience with Denodo .
• Hands-on experience with data orchestration tools such as Apache Airflow, Prefect, Luigi, or similar platforms for workflow automation and scheduling.
• Familiarity with big data technologies (Hadoop, Spark, Kafka) is a plus.
• Hands-on experience with cloud platforms (AWS, Azure, GCP) and hybrid data architectures.
• Experience integrating data pipelines with COTS and custom applications.
• Strong understanding of data modeling, metadata management, and data governance.

Company Description

Edgewater Federal Solutions is a privately held government contracting firm located in Frederick, MD. The company was founded in 2002 with the vision of being highly recognized and admired for supporting customer missions through employee empowerment, exceptional services and timely delivery. Edgewater Federal Solutions is ISO 9001, 20000-1, 270001 certified, appraised at CMMI Level 3 Maturity for Development and Services, and has been named in the Top Workplaces in the Greater Washington Area since 2018.

It has been and continues to be the policy of Edgewater Federal Solutions to provide equal employment opportunities to all employees and applicants for employment without regard to , , , , , , , , marital status, veteran status, and/or other statuses protected by applicable law.

Company Description

Edgewater Federal Solutions is a privately held government contracting firm located in Frederick, MD. The company was founded in 2002 with the vision of being highly recognized and admired for supporting customer missions through employee empowerment, exceptional services and timely delivery. Edgewater Federal Solutions is ISO 9001, 20000-1, 270001 certified, appraised at CMMI Level 3 Maturity for Development and Services, and has been named in the Top Workplaces in the Greater Washington Area since 2018.

It has been and continues to be the policy of Edgewater Federal Solutions to provide equal employment opportunities to all employees and applicants for employment without regard to , , , , , , , , marital status, veteran status, and/or other statuses protected by applicable law.