What are the responsibilities and job description for the Senior/Principal Solutions Architect - Data Engineer, Onsite position at Sandia National Laboratories?
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:
We are seeking a highly motivated Data Engineer to architect and develop solutions to store, manage, and provision data to consumers within the Denodo platform.
Our team of software engineers have a deep understanding of our customers’ business domains. Combining this knowledge with our comprehensive set of capabilities, allows us to extract data from a broad range of sources and deliver trusted datasets for reports, visualizations, and analytical models.
On any given day you may be called on to:
Salary Range
$114,000 - $227,500
Enterprise data is created/managed by many source systems using different technologies and stored in various structures. Our team of software engineers and solutions architects have a deep understanding of Sandia business domains. Combining this knowledge with our comprehensive set of capabilities, allows us to unify disparate enterprise datasets and deliver consistent/reliable data to consumers (data scientists, analysts, report developers, etc.) to answer critical business questions.
Posting Duration
This posting will be open for application submissions for a minimum of seven (7) 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: 695408
Job Family: IT
Regular/Temporary Position: R
Full/Part-Time Status: F
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*
- These benefits vary by job classification.
We are seeking a highly motivated Data Engineer to architect and develop solutions to store, manage, and provision data to consumers within the Denodo platform.
Our team of software engineers have a deep understanding of our customers’ business domains. Combining this knowledge with our comprehensive set of capabilities, allows us to extract data from a broad range of sources and deliver trusted datasets for reports, visualizations, and analytical models.
On any given day you may be called on to:
- Develop and maintain data pipelines to support data science and engineering initiatives
- Integrate and manage data from diverse sources, including cloud-based platforms
- Utilize data visualization techniques to present data insights to stakeholders
- Serve as a Denodo data integration and delivery expert to support enterprise reporting and analytics
Salary Range
$114,000 - $227,500
- 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.
- Bachelor's degree in Computer Engineering/Computer Science/Management Information Systems or related field, plus 5 years of experience; or equivalent (AS 9 years or no degree 13 years)
- Ability to obtain and maintain a DOE Q clearance
- Experience developing data engineering solutions using programming languages such as Python, Java, SQL, and PL/SQL
- Experience with developing data pipelines from many sources from structured and unstructured data sets in a variety of formats
- Experience in design, management, and solutioning of large, complex data sets and models
- Experience with data extraction, transformation, and loading (ETL) processes
- Experience with database technologies: SQL Server, Oracle, MySQL, columnar (Snowflake), NoSQL
- Experience with Big Data tools such as, Spark, Hive, Impala, Polybase, Phoenix, Presto, Kylin, etc.
- Experience designing and developing virtual data views in the Denodo platform
- Configuration Management: Experience with software code/configuration management tools such as Git, Subversion, etc
- Experience gathering user specifications and defining requirements
- Ability to complete tasks with evolving requirements and minimal direction
- Strong critical thinking and problem-solving skills, and ability to see/convey the big picture
- Ability to tackle ambiguity and adapt to a fast-paced, customer-focused operation
- Ability to work and communicate in an interdisciplinary team environment
Enterprise data is created/managed by many source systems using different technologies and stored in various structures. Our team of software engineers and solutions architects have a deep understanding of Sandia business domains. Combining this knowledge with our comprehensive set of capabilities, allows us to unify disparate enterprise datasets and deliver consistent/reliable data to consumers (data scientists, analysts, report developers, etc.) to answer critical business questions.
Posting Duration
This posting will be open for application submissions for a minimum of seven (7) 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: 695408
Job Family: IT
Regular/Temporary Position: R
Full/Part-Time Status: F
Salary : $114,000 - $227,500
