Data Warehouse Developer

We have an opening for a Data Warehouse Developer. You will be responsible for all phases of the software development lifecycle (analysis, design, and implementation).  You will work closely with peer developers and financial business experts to create and optimize complex data loading processes for enterprise reporting across the Laboratory.  This position is in the Enterprise Application Services Division within the Computing Directorate, in support of the LivIT Program.

Telecommuting options are available for this position. 

In this role you will

• Provide application development and maintenance for all phases of the software development lifecycle, including analysis, design, and implementation.
• Design and maintain complex ETL (Extract, Transform and Load) processes that load from both data files and other databases.
• Develop and maintain complex PL/SQL functions and procedures.
• Create and optimize complex SQL queries for reports and applications.
• Provide input to project plans that includes estimates of tasks, duties and technologies for future releases and write technical documentation.
• Provide end user support and problem diagnosis and resolution.
• Perform all assignments in accordance with ESH&Q, Security, and business practice requirements and policies.
• Participate in cross-organizational activities in collaboration with a diverse user community.
• Perform other duties as assigned.

Additional job responsibilities at the SES.3 Level

• Provide advanced level development support of PL/SQL functions, procedures, and database architecture.
• Provide advanced SQL tuning skills to complex queries, ETL’s, and data processing.
• Provide advanced support towards the IT needs for financial and/or budget and planning applications.
• Design, evaluate, deploy, and maintain AI/ML models, data pipelines, and solutions. Build and deploy data pipelines focusing on data ingestion, integration, modeling, optimization, and quality for AI processing

• Ability to obtain and maintain a US DOE Q-level security clearance which requires U.S. Citizenship.  
• Bachelor’s degree in Computer Science, Information Systems or related field, or equivalent combination of education and related experience.
• Broad experience developing and maintaining custom ETL scripts.
• Comprehensive knowledge and experience with relational database design, techniques, and development methodologies with the ability to understand the benefits and liabilities of various design patterns and schemas such as Star and Snowflake schemas.
• Broad experience using SQL, PL/SQL, and Oracle 11g or higher.
• Comprehensive experience developing ETL processes within Oracle database environments and non-Oracle environments using SQL Server, MySQL, File Transfer, or similar technologies.
• Proficient interpersonal skills necessary to effectively collaborate as part of a cohesive development team working with multiple customers and organizations simultaneously with time constraints.
• Proficient written and verbal communication skills necessary to effectively prepare, present and explain technical information to others.

Additional Qualifications at the SES.3 Level

• Significant experience supporting financial and business applications.
• Advanced experience with SQL Tuning and ETL Optimization.
• Exposure to Large Language Model (LLM) and Natural Language Processing (NLP)
• Experience in retrieval augmented generation (RAG) models
• Write efficient and scalable code in to support transformation and analysis in a language such as Python.

All your information will be kept confidential according to EEO guidelines.

Position Information

This is a Career Indefinite position, open to Lab employees and external candidates.

Why Lawrence Livermore National Laboratory?

• Included in 2024 Best Places to Work by Glassdoor!
• Flexible Benefits Package
• 401(k)
• Relocation Assistance
• Education Reimbursement Program
• Flexible schedules (*depending on project needs)
• Inclusion, Diversity, Equity and Accountability (IDEA) - visit https://www.llnl.gov/diversity
• Our core beliefs - visit https://www.llnl.gov/diversity/our-values 
• Employee engagement - visit https://www.llnl.gov/diversity/employee-engagement

Security Clearance

This position requires a Department of Energy (DOE) Q-level clearance.  If you are selected, we will initiate a Federal background investigation to determine if you meet eligibility requirements for access to classified information or matter. Also, all L or Q cleared employees are subject to random drug testing.  Q-level clearance requires U.S. citizenship. 

Pre-Employment Drug Test

External applicant(s) selected for this position must pass a post-offer, pre-employment drug test. This includes testing for use of marijuana as Federal Law applies to us as a Federal Contractor.

Wireless and Medical Devices

Per the Department of Energy (DOE), Lawrence Livermore National Laboratory must meet certain restrictions with the use and/or possession of mobile devices in Limited Areas. Depending on your job duties, you may be required to work in a Limited Area where you are not permitted to have a personal and/or laboratory mobile device in your possession.  This includes, but not limited to cell phones, tablets, fitness devices, wireless headphones, and other Bluetooth/wireless enabled devices.  

If you use a medical device, which pairs with a mobile device, you must still follow the rules concerning the mobile device in individual sections within Limited Areas.  Sensitive Compartmented Information Facilities require separate approval. Hearing aids without wireless capabilities or wireless that has been disabled are allowed in Limited Areas, Secure Space and Transit/Buffer Space within buildings.

How to identify fake job advertisements

Please be aware of recruitment scams where people or entities are misusing the name of Lawrence Livermore National Laboratory (LLNL) to post fake job advertisements. LLNL never extends an offer without a personal interview and will never charge a fee for joining our company. All current job openings are displayed on the Career Page under “Find Your Job” of our website. If you have encountered a job posting or have been approached with a job offer that you suspect may be fraudulent, we strongly recommend you do not respond.

To learn more about recruitment scams: https://www.llnl.gov/sites/www/files/2023-05/LLNL-Job-Fraud-Statement-Updated-4.26.23.pdf

Equal Employment Opportunity

We are an equal opportunity employer that is committed to providing all with a work environment free of discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, religion, marital status, national origin, ancestry, sex, sexual orientation, gender identity, disability, medical condition, pregnancy, protected veteran status, age, citizenship, or any other characteristic protected by applicable laws.

We invite you to review the Equal Employment Opportunity posters which include EEO is the Law and Pay Transparency Nondiscrimination Provision.

Reasonable Accommodation

Our goal is to create an accessible and inclusive experience for all candidates applying and interviewing at the Laboratory.  If you need a reasonable accommodation during the application or the recruiting process, please use our online form to submit a request. 

California Privacy Notice

The California Consumer Privacy Act (CCPA) grants privacy rights to all California residents. The law also entitles job applicants, employees, and non-employee workers to be notified of what personal information LLNL collects and for what purpose. The Employee Privacy Notice can be accessed here.