Data Warehouse Developer

3 weeks ago


Livermore, California, United States LLNL Full time
Job Title: Data Warehouse Developer

Job Summary:

We are seeking a highly skilled Data Warehouse Developer to join our team at Lawrence Livermore National Laboratory (LLNL). As a Data Warehouse Developer, you will be responsible for designing, developing, and maintaining complex data loading processes for enterprise reporting across the Laboratory.

Key Responsibilities:

* 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.

Requirements:

* 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 Requirements 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.

About LLNL:

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.

How to Apply:

If you are interested in this opportunity, please submit your application through our website.

  • Livermore, California, United States LLNL Full time

    Job SummaryWe are seeking a highly skilled Data Warehouse Developer to join our team at Lawrence Livermore National Laboratory (LLNL). As a Data Warehouse Developer, you will be responsible for designing, developing, and maintaining complex data loading processes for enterprise reporting across the Laboratory.Key ResponsibilitiesProvide application...


  • Livermore, California, United States PVH Corp. Full time

    Job Title: Warehouse Associate/DriverJoin PVH Corp. as a Warehouse Associate/Driver and be part of a dynamic team that drives success in the retail industry.Job Summary:We are seeking a highly motivated and detail-oriented Warehouse Associate/Driver to join our team. As a Warehouse Associate/Driver, you will be responsible for shipping and receiving...


  • Livermore, California, United States PVH Corp. Full time

    Job Title: Store Warehouse Associate (Driver)At PVH Corp., we are seeking a highly skilled and detail-oriented Store Warehouse Associate (Driver) to join our team. As a key member of our warehouse team, you will be responsible for ensuring the efficient and safe movement of merchandise between our warehouse and retail stores.Key Responsibilities:Deliver...


  • Livermore, California, United States Performance Food Group Full time

    Job Title: Warehouse Sanitation SpecialistWe are seeking a highly motivated and detail-oriented Warehouse Sanitation Specialist to join our team at Performance Food Group. As a key member of our warehouse team, you will be responsible for maintaining a clean and safe working environment for our associates.Responsibilities:Maintain a clean and organized...


  • Livermore, California, United States Manpower Group Inc. Full time

    Job Summary:As a Warehouse Operations Specialist at Manpower Group Inc., you will be responsible for providing light industrial services in a warehouse or distribution environment. This role requires the ability to operate a pallet jack and lift up to 25 pounds, as well as good reading, writing, and communication skills.Key Responsibilities: Provide light...


  • Livermore, California, United States PVH Corp. Full time

    Job Title: Store Warehouse Driver Full TimeAt PVH Corp., we are seeking a highly skilled and motivated Store Warehouse Driver to join our team. As a Store Warehouse Driver, you will play a critical role in ensuring the timely delivery of merchandise to our retail stores.Key Responsibilities:Deliver product to and from stores in a timely and efficient...


  • Livermore, California, United States Randstad Full time

    Inventory Associate Role at RandstadAs an Inventory Associate at Randstad, you will be responsible for coordinating all incoming and outgoing shipments with multiple locations. Your tasks will include preparing and submitting documents, creating Excel spreadsheets for tracking purposes, and maintaining product data to ensure accuracy. If you have experience...


  • Livermore, California, United States Lawrence Livermore National Laboratory Full time

    Job DescriptionWe are seeking a highly motivated and talented graduate student to join our Data Science Institute as a research intern. The selected candidate will have the opportunity to engage in practical research and contribute to various projects in the field of data science.ResponsibilitiesProvide technical and/or research support to projects in the...


  • Livermore, California, United States LLNL Full time

    Job DescriptionLawrence Livermore National Laboratory (LLNL) is seeking highly motivated and talented graduate students to participate in our Data Science Summer Institute (DSSI) internship program. As a DSSI intern, you will have the opportunity to engage in practical research and work with our team of scientists and engineers to advance the field of data...


  • Livermore, California, United States Modus Advanced, Inc. Full time

    Quality Assurance Role SummaryWe are seeking an experienced Advanced Manufacturing Quality Engineer to join our team at Modus Advanced, Inc. In this role, you will be responsible for planning, analyzing, and implementing continuous improvement opportunities in manufacturing processes to support Quality Engineering.Key ResponsibilitiesOversee advanced...


  • Livermore, California, United States Mancini's Sleepworld Full time

    Job Summary:The Director of Real Estate and Development will lead the strategic planning, acquisition, and management of real estate projects within Mancini's Sleepworld. This role requires extensive expertise in real estate development, portfolio management, and strong leadership skills to ensure alignment with the organization's long-term goals.Key...


  • Livermore, California, United States FormFactor Full time

    Job Title:Technology Development Program ManagerJob Summary:FormFactor is seeking a Technology Development Program Manager to drive the development and deployment of new probe card architectures. The successful candidate will have a strong background in mechanical engineering, physics, or electrical engineering, and experience in program management, with a...


  • Livermore, California, United States FormFactor Full time

    Job SummaryFormFactor is seeking a highly skilled Technology Development Program Manager to drive the development of new probe card architectures. The successful candidate will be responsible for leading cross-functional teams to develop, deploy, and transfer new technologies to the probes Business Unit.Key Responsibilities Drive the Product Lifecycle...

  • Marketing Assistant

    2 weeks ago


    Livermore, California, United States The Wine Group Full time

    About the RoleThe Cupcake Marketing Assistant plays a vital role in supporting the growth of The Wine Group's Cupcake brand. Reporting to the Brand Manager, Cupcake, this hybrid role is based out of our Livermore, CA location.Key ResponsibilitiesSupport in-store and out-of-store programmingDevelop sales materials and manage sell-in tool assetsAssist with...

  • Assembly Technician

    3 weeks ago


    Livermore, California, United States CPP Industries Full time

    Job SummaryWe are seeking a skilled Assembly Technician to join our team at CPP Industries. As an Assembly Technician, you will be responsible for assembling electronic screens, inspecting and servicing products, and performing warehouse labor tasks.Key ResponsibilitiesAssemble electronic screensInspect and service productsPerform warehouse labor...


  • Livermore, California, United States Abbott Laboratories Full time

    Job OpportunityAbbott Laboratories is seeking a highly skilled Business Development Representative to join our team. As a key member of our sales team, you will be responsible for driving exponential growth in your territory through closing new business and expanding existing business space.Key ResponsibilitiesBuild and understand your assigned territory's...


  • Livermore, California, United States FormFactor Full time

    Position:Market Segment Development Manager, Silicon PhotonicsLocation:Livermore, CAJob Id: 5666# of Openings: 1Market Segment Development Manager, Silicon PhotonicsFormFactor, IncLivermore, CAIn a rapidly evolving technology landscape, semiconductor manufacturers require a trusted partner to pioneer the frontiers of advanced integrated circuits (ICs). As...


  • Livermore, California, United States McGrath Full time

    Job OverviewMcGrath is a dynamic company that values innovation and collaboration. As a Human Resources Business Partner, you will play a critical role in driving strategic HR leadership for the West Region of our largest business unit, Mobile Modular.This role involves partnering with multiple leaders who lead sales, operations, and production teams. You...


  • Livermore, California, United States Abbott Full time

    Job SummaryAbbott is seeking a highly skilled Business Development Representative to drive exponential growth in their territory through closing new business and expanding existing business space. The ideal candidate will have a strong background in informatics and a proven track record of success in sales and business development.Key ResponsibilitiesBuild...


  • Livermore, California, United States LLNL Full time

    Job DescriptionWe are seeking a highly skilled High Performance Computing Software Developer to join our research software teams at LLNL. As a key member of our team, you will develop and maintain common infrastructure, perform focused software development tasks, and contribute to multiple projects using creativity and imagination.This position offers a...