Data Engineering and Automation Lead (Project Leader 2/3)

Los Alamos National Laboratory

Los Alamos (NM)

Hybrid

USD 96,000 - 195,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Los Alamos National Laboratory seeks a Data Engineering and Automation Lead to design, automate, and sustain data pipelines and governed data products for informed decision-making. You will lead production data processes, implement ETL/ELT pipelines, and shape scalable data models in a fast-paced research environment.

The role requires strong Python/SQL expertise, production engineering practices, and the ability to collaborate across teams.

Qualifications

  • Bachelor's degree in a related field from an accredited institution and 5 years of directly related experience; or an equivalent combination of education and experience.
  • Bachelor's degree in a related field from an accredited institution and 8 years of directly related experience; or an equivalent combination of education and experience.
  • Experience planning and coordinating technical work, managing scope and dependencies, identifying risks, engaging stakeholders, and delivering solutions through production implementation.
  • The demonstrated ability to translate business needs into technical solutions and communicate architecture, risks, decisions, and results to technical and non-technical audiences.
  • The demonstrated ability to develop, test, and support Python and SQL solutions used for production data processing, automation, and integration.
  • Demonstrated experience building and supporting automated ETL or ELT pipelines that integrate data from multiple source types, such as databases, APIs, enterprise applications, spreadsheets, or flat files.
  • Demonstrated experience designing relational, dimensional, or analytical data models that support reusable reporting, metrics, or analytical use cases.
  • Experience applying version control, modular design, code review, automated testing, error handling, logging, configuration management, documentation, and controlled deployment practices.
  • Experience validating and reconciling data to authoritative sources, troubleshooting deployed solutions, and establishing reliable operational support practices.
  • The demonstrated ability to independently learn and apply new technologies, adapt solutions as enterprise platforms evolve, and share acquired knowledge with others.
  • Advanced experience establishing technical architecture, reusable data-engineering patterns, or production standards across multiple products or organizations.
  • Demonstrated record of leading complex data or software initiatives involving multiple systems, organizations, and stakeholders.
  • The demonstrated ability to exercise independent technical judgment, resolve ambiguous problems, and provide consultative guidance to management and delivery teams.
  • Experience mentoring technical personnel and developing broader organizational capability.

Responsibilities

  • Design, automate, and sustain data pipelines, data models and governed data products to support operations and strategic decisions.
  • Build and maintain production data processing solutions using Python and SQL.
  • Develop and manage automated ETL/ELT pipelines that integrate diverse data sources.
  • Create robust data models to enable reusable reporting and analytics use cases.
  • Apply data-governance practices, metadata cataloging, lineage, and data stewardship.

Skills

Python
SQL
Technical leadership
Data modeling
Communication
Collaboration
Learning agility

Education

Bachelor's degree in related field

Tools

Databricks
Apache Spark
Delta Lake
SAP
Oracle

Job description

What You Will Do

This position will be filled either as a Project Leader 2 or a Project Leader 3, depending on the skills of the selected candidate(s).

Come join the best and brightest minds in the world at one of the most innovative and creative multidisciplinary research institutions engaged in strategic science on behalf of national security. The work we do at Los Alamos National Laboratory (LANL) matters to our country and the world!

You will support Production Support Services (PSS) within ALDWP, responsible for production, operations, and manufacturing support for Pit and Detonator production at Los Alamos National Laboratory (LANL). The PSS-4 Data, Insights, and Visualization (DIV) team is seeking a highly motivated Data Engineering and Automation Lead to design, automate, and sustain data pipelines, data models and governed data products that support operational and strategic decision-making.

Salary Range: While the posted salary range for this position is broad, it is highly unusual for selected applicants to be hired at the top end of the range and more common for selected candidates to grow into the full salary band over time.

  • Project Leader 2 Salary Range: $96,600 to $158,000
  • Project Leader 3 Salary Range: $117,200 to $195,400

#shiftwork

What You Need
Minimum Job Requirements:

Applicants must submit a comprehensive resume reflective of relevant experience that addresses the minimum job requirements and desired qualifications of the position below for full consideration.

  • Education/Experience Requirements for the Project Leader 2: Position requires a bachelor's degree in a related field from an accredited institution and 5 years of directly related experience; or, an equivalent combination of education and experience directly related to the occupation.
  • Education/Experience Requirements for the Project Leader 3: Position requires a bachelor's degree in a related field from an accredited institution and 8 years of directly related experience; or, an equivalent combination of education and experience directly related to the occupation.
  • Technical Project Leadership:
    • Experience planning and coordinating technical work, managing scope and dependencies, identifying risks, engaging stakeholders, and delivering solutions through production implementation.
  • Communication and Collaboration:
    • The demonstrated ability to translate business needs into technical solutions and communicate architecture, risks, decisions, and results to technical and non-technical audiences.
  • Python and SQL:
    • The demonstrated ability to develop, test, and support Python and SQL solutions used for production data processing, automation, and integration.
  • Data Integration and Pipeline Development:
    • Demonstrated experience building and supporting automated ETL or ELT pipelines that integrate data from multiple source types, such as databases, APIs, enterprise applications, spreadsheets, or flat files.
  • Data Modeling:
    • Demonstrated experience designing relational, dimensional, or analytical data models that support reusable reporting, metrics, or analytical use cases.
  • Production Engineering Practices:
    • Experience applying version control, modular design, code review, automated testing, error handling, logging, configuration management, documentation, and controlled deployment practices.
  • Data Quality and Support:
    • Experience validating and reconciling data to authoritative sources, troubleshooting deployed solutions, and establishing reliable operational support practices.
  • Continuous Learning:
    • The demonstrated ability to independently learn and apply new technologies, adapt solutions as enterprise platforms evolve, and share acquired knowledge with others.
  • Project Leader 3: In addition to the job requirements outlined for the Project Leader 2 above, job requirements for the Project Leader 3 include...
    • Advanced experience establishing technical architecture, reusable data-engineering patterns, or production standards across multiple products or organizations.
    • Demonstrated record of leading complex data or software initiatives involving multiple systems, organizations, and stakeholders.
    • The demonstrated ability to exercise independent technical judgment, resolve ambiguous problems, and provide consultative guidance to management and delivery teams.
    • Experience mentoring technical personnel and developing broader organizational capability.
Qualifications We Desire:
  • Experience with enterprise lakehouse or cloud data platforms (e.g., Databricks, Apache Spark, or Delta Lake).
  • Experience developing governed datasets and semantic models for business intelligence platforms (e.g., Power BI, including data refresh patterns).
  • Experience integrating enterprise business systems and operational data stores, such as SAP or Oracle.
  • Experience implementing automated data workflow and deployment practices, such as workflow orchestration, CI/CD, or infrastructure automation.
  • Experience developing data-capture solutions, such as forms or applications that validate and store data in an approved operational database.
  • Experience applying data-governance and data-management practices, (e.g., metadata cataloging, lineage, master data management, or data stewardship).
  • Experience preparing structured or unstructured data for advanced analytical use cases, such as machine learning or governed super intelligence.
  • Experience working in environments with formal regulatory, security, or operational controls.
  • Relevant professional certifications in data engineering, business intelligence, data management, or project management.
  • An active DOE Q-level clearance.
Work Location:

The work location for this position is hybrid and is located in Los Alamos, New Mexico. Hybrid is defined as working partially onsite/partially offsite but within 2 hours ground commute of this location. This is not a Telework or Remote position. All work locations are at the discretion of management and can change at any time with appropriate notice.

Work Schedule:

This position may/will require 24/7 coverage, which could/will involve working a shift/weekend schedule. Employees may be eligible for the shift differential pay when assigned by their manager. Shift/weekend assignments are at the discretion of the manager.

Position Commitment:

Regular appointment employees are required to serve a period of continuous service in their current position in order to be eligible to apply for posted jobs throughout the Laboratory. If an employee has not served the time required, they may only apply for Laboratory jobs with the documented approval of their Division Leader. The position commitment for this position is 2 years.

Note to Applicants:

Due to federal restrictions contained in the current National Defense Authorization Act, citizens of the People's Republic of China-including the special administrative regions of Hong Kong and Macau-as well as citizens of the Islamic Republic of Iran, the Democratic People's Republic of Korea (North Korea), and the Russian Federation, who are not Lawful Permanent Residents ("green card" holders) are prohibited from accessing facilities that support the mission, functions, and operations of national security laboratories and nuclear weapons production facilities, which includes Los Alamos National Laboratory.

Where You Will Work

Located in beautiful northern New Mexico, Los Alamos National Laboratory (LANL) is a multidisciplinary research institution engaged in strategic science on behalf of national security. Our generous benefits package includes:

  • PPO or High-Deductible medical insurance with the same large nationwide network
  • Dental and Vision insurance
  • Free basic life and disability insurance
  • Paid childbirth and parental leave
  • Award-winning 401(k) (6% matching plus 3.5% annually)
  • Learning opportunities and tuition assistance
  • Flexible schedules and time off (PTO and holidays)
  • Onsite gyms and wellness programs
  • Extensive relocation packages (outside a 50-mile radius)
Additional Details
Directive 206.2:

Employment with Triad requires a favorable decision by NNSA indicating employee is suitable under NNSA Supplemental Directive 206.2. Please note that this requirement applies only to citizens of the United States. Foreign nationals are subject to a similar requirement under DOE Order 142.3A.

Clearance: Q

(Position will be cleared to this level). Selected applicants will be subject to a background investigation conducted by or on behalf of the Federal Government and must meet eligibility requirements* for access to classified matter. This position requires a Q clearance and obtaining such clearance requires US Citizenship except in extremely rare circumstances. Dependent upon the position, additional authorization to access classified information may be required, which may or may not be available to dual citizens. Receipt of a Q clearance and additional access authorization ultimately is a decision of the Federal Government and not of Triad.

*Eligibility requirements: To obtain a clearance, an individual must be at least 18 years of age; U.S. citizenship is required except in very limited circumstances. See DOE Order 472.2 for additional information.

New-Employment Drug Test:

The Laboratory requires successful applicants to complete a new-employment drug test and maintains a substance abuse policy that includes random drug testing. Although New Mexico and other states have legalized the use of marijuana, use and possession of marijuana remain illegal under federal law. A positive drug test for marijuana will result in termination of employment, even if the use was pre-offer.

Regular Position:

Term status Laboratory employees applying for regular-status positions are converted to regular status.

Internal Applicants:

Regular appointment employees who have served the required period of continuous service in their current position are eligible to apply for posted jobs throughout the Laboratory. If an employee has not served the required period of continuous service, they may only apply for Laboratory jobs with the documented approval of their Division Leader. Please refer to Policy P701 for applicant eligibility requirements.

Equal Opportunity:

Los Alamos National Laboratory is an equal opportunity employer. All employment practices are based on qualification and merit, without regard to protected categories such as race, color, national origin, ancestry, religion, age, sex, gender identity, sexual orientation, marital status or spousal affiliation, physical or mental disability, medical conditions, pregnancy, status as a protected veteran, genetic information, or citizenship within the limits imposed by applicable federal, state and local laws and regulations.

The Laboratory is also committed to making our workplace accessible to individuals with disabilities and will provide reasonable accommodations, upon request, for individuals to participate in the application and hiring process. To request such an accommodation, please send an email to applyhelp@lanl.gov or call (505)-664-6947 opt. 3.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Science/Engineering Project Leader 3
Science/Engineering Project Leader 3

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 120,000 - 160,000
Health insurance
Dental and vision insurance
Life and disability insurance
+6
Project Leader 2
Project Leader 2

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 110,000 - 160,000
Health insurance
Tuition assistance
Paid time off
HPC & AI Workload Management Team Lead (HPC Engineer 2/3)
HPC & AI Workload Management Team Lead (HPC Engineer 2/3)

Los Alamos National Laboratory • Los Alamos (NM)

Hybrid
USD 106,000 - 216,000
Health insurance (PPO/HSA)
Dental insurance
Vision insurance
+5
Artificial Intelligence and Data Science Scientist (Scientist 1)
Artificial Intelligence and Data Science Scientist (Scientist 1)

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 120,000 - 170,000
Relocation packages
Comprehensive benefits
Division Leader - Application & Data Services (IT Manager 6)
Division Leader - Application & Data Services (IT Manager 6)

Los Alamos National Laboratory • Los Alamos (NM)

Hybrid
USD 250,000 - 320,000
Medical insurance
Dental and vision insurance
401(k) with matching
+1
High Performance Computing Engineer for Workflow Modernization (HPC Engineer 2/3)
High Performance Computing Engineer for Workflow Modernization (HPC Engineer 2/3)

Los Alamos National Laboratory • Los Alamos (NM)

Hybrid
USD 106,000 - 216,000
Relocation assistance
Flexible schedules
Onsite gyms and wellness
Systems Analyst 2/3 (Weekends)
Systems Analyst 2/3 (Weekends)

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 88,000 - 176,000
Onsite gym access
Relocation assistance
Competitive benefits
Project Leader 1/2
Project Leader 1/2

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 80,000 - 158,000
Onsite gyms and wellness programs
Flexible relocation packages
Tuition assistance
Operations Support Specialist 2/3 (IPO Metrics and Data Analysis)
Operations Support Specialist 2/3 (IPO Metrics and Data Analysis)

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 73,000 - 115,000
Medical & dental insurance
Relocation assistance
Tuition assistance
+2
R&D Engineer 1/2
R&D Engineer 1/2

Los Alamos National Laboratory • Los Alamos (NM)

On-site
USD 97,000 - 176,000