Early-Career Software Systems Engineer - Data Integration Framework, Hybrid

Sandia Corporation; Albuquerque (NM); Hybrid; USD 87,000 - 169,000; Full time

Job summary

Sandia National Laboratories in Albuquerque is seeking a Software Systems/Data Engineer to join the Design and Development Solutions team. You will analyze, design, develop, and deploy software solutions to meet mission needs with a focus on data engineering and API-driven data access.

The role requires strong SQL/data modeling, collaboration with business and technical teams, and a mix of onsite/offsite work with proximity to the assigned location.

Qualifications

• Bachelor's degree in relevant discipline or equivalent.
• Ability to obtain and maintain a DOE Q clearance.
• 4+ years of SQL experience across OLTP, data warehouse, or big data environments.
• 4+ years of experience as a Data Analyst, Data Engineer, or SQL Developer.
• 2+ years of experience writing medium to complex SQL queries or stored procedures.
• Strong understanding of query optimization techniques.
• Experience supporting REST API data services.
• Background in troubleshooting data integrity, quality, and performance issues.
• Experience with Jira and GitLab.
• Experience with Denodo or similar data virtualization platforms.
• Java and Python development experience.
• Experience with Hadoop or MongoDB.

Responsibilities

• Write and optimize SQL and query language scripts to enhance data accessibility and performance.
• Collaborate with business and technical teams to design new virtual data integration solutions.
• Document functional and technical details for data integration solutions clearly and comprehensively.
• Support troubleshooting efforts related to query performance and data quality issues.
• Develop and maintain APIs to enable data access and integration across systems.
• The selected applicant can work a combination of onsite and offsite work.

Skills

SQL

Data Engineer

REST APIs

Agile

Java

Python

Hadoop

MongoDB

Denodo

Education

Bachelor's degree

Tools

Jira

GitLab

Denodo

Hadoop

MongoDB

Job description

About Sandia

Sandia National Laboratories is the nation’s premier science and engineering lab for national security and technology innovation, with teams of specialists focused on cutting-edge work in a broad array of areas. Some of the main reasons we love our jobs:

• Challenging work with amazing impact that contributes to security, peace, and freedom worldwide
• Extraordinary co-workers
• Some of the best tools, equipment, and research facilities in the world
• Career advancement and enrichment opportunities
• Flexible work arrangements for many positions include 9/80 (work 80 hours every two weeks, with every other Friday off) and 4/10 (work 4 ten-hour days each week) compressed workweeks, part-time work, and telecommuting (a mix of onsite work and working from home)
• Generous vacation, strong medical and other benefits, competitive 401k, learning opportunities, relocation assistance and amenities aimed at creating a solid work/life balance*

World-changing technologies. Life-changing careers. Learn more about Sandia at: http://www.sandia.gov

• These benefits vary by job classification.

What Your Job Will Be Like

Are you looking for challenging and impactful work that contributes to security, peace, and freedom worldwide?

If so, Sandia National Laboratories' Science and Information Engineering System's group is seeking a motivated Software Systems Engineer to join the Design and Development Solutions team in analyzing, designing, developing, and deploying innovative software solutions to meet our mission customers' needs.

We are looking for a skilled Data Engineer with strong expertise in SQL and data modeling to design, develop, and optimize data solutions that drive efficient data access and high performance. The ideal candidate will work closely with business and technical teams to build scalable data models and integration solutions, troubleshoot data quality and performance issues, and develop APIs to support seamless data flow across systems.

On any given day, you may be called on to:

• Write and optimize SQL and query language scripts to enhance data accessibility and performance.
• Collaborate with business and technical teams to design new virtual data integration solutions.
• Document functional and technical details for data integration solutions clearly and comprehensively.
• Support troubleshooting efforts related to query performance and data quality issues.
• Develop and maintain APIs to enable data access and integration across systems.
• The selected applicant can work a combination of onsite and offsite work. The selected applicant must live within a reasonable distance for commuting to the assigned work location when necessary.

Salary Range

$87,400 - $168,800

• Salary range is estimated, and actual salary will be determined after consideration of the selected candidate's experience and qualifications, and application of any approved geographic salary differential.

Qualifications We Require

• Bachelor's degree in relevant discipline, or equivalent.
• Ability to obtain and maintain a DOE Q clearance.

Qualifications We Desire

• 4+ years of SQL experience across OLTP, data warehouse, or big data environments
• 4+ years of experience in a Data Analyst, Data Engineer, or SQL Developer role
• 2+ years of experience writing medium to complex SQL queries or stored procedures
• Strong understanding of query optimization techniques
• Experience supporting REST API data services
• Background in troubleshooting data integrity, quality, and performance issues
• Experience working in agile environments
• Familiarity with Jira and GitLab
• Experience working with both technical staff and business users to understand their data needs and provide tailored solutions
• Clear communication skills and a collaborative, self-directed approach
• Experience with Denodo or similar data virtualization platforms, creating virtual data views and ensuring data quality and consistency
• Java and Python development experience
• Experience working with Hadoop or MongoDB

About Our Team

The Science & Engineering Information Systems Organization is the partner of choice for innovative science and engineering information solutions for National Security missions. We Research, engineer, and support integrated information solutions that enable diverse customers to solve complex business problems and national security issues. Our organization can offer flexible work patterns with standard, 9/80, and 4/10 schedules available.

Posting Duration

This posting will be open for application submissions for a minimum of three (3) calendar days, including the 'posting date'. Sandia reserves the right to extend the posting date at any time.

Security Clearance

Sandia is required by DOE to conduct a pre-employment drug test and background review that includes checks of personal references, credit, law enforcement records, and employment/education verifications. Applicants for employment need to be able to obtain and maintain a DOE Q-level security clearance, which requires U.S. citizenship. If you hold more than one citizenship (i.e., of the U.S. and another country), your ability to obtain a security clearance may be impacted.

Applicants offered employment with Sandia are subject to a federal background investigation to meet the requirements for access to classified information or matter if the duties of the position require a DOE security clearance. Substance abuse or illegal drug use, falsification of information, criminal activity, serious misconduct or other indicators of untrustworthiness can cause a clearance to be denied or terminated by DOE, resulting in the inability to perform the duties assigned and subsequent termination of employment.

Eeo

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or veteran status and any other protected class under state or federal law.

NNSA Requirements For MedPEDs

If you have a Medical Portable Electronic Device (MedPED), such as a pacemaker, defibrillator, drug-releasing pump, hearing aids, or diagnostic equipment and other equipment for measuring, monitoring, and recording body functions such as heartbeat and brain waves, if employed by Sandia National Laboratories you may be required to comply with NNSA security requirements for MedPEDs.

If you have a MedPED and you are selected for an on-site interview at Sandia National Laboratories, there may be additional steps necessary to ensure compliance with NNSA security requirements prior to the interview date.

Job ID: 699588

Job Family: IT

Regular/Temporary Position: R

Full/Part-Time Status: F