Data Warehouse/Business Intelligence Developer

Full Time

Job Description

Company Description
Join us and make YOUR mark on the World!

Are you interested in joining some of the brightest talent in the world to strengthen the United States' security? Come join Lawrence Livermore National Laboratory (LLNL) where our employees apply their expertise to create solutions for BIG ideas that make our world a better place.

We are committed to a diverse and equitable workforce with an inclusive culture that values and celebrates the diversity of our people, talents, ideas, experiences, and perspectives. This is essential to innovation and creativity for continued success of the Laboratory's mission.
Job Description
We have an opening for a Data Warehouse/(Business Intelligence 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 (EAS), in support of LivIT, within in the Computing Directorate.

This position will be filled at eitherSES.1 or SES.2 based on knowledge and related experience as assessed by the hiring team. Additional job responsibilities (outlined below) will be assigned if hired at the higher level.

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 processes that load multiple data sources, such as databases and data files.
  • Develop and maintain complex PL/SQL functions and procedures.
  • Create and optimize complex SQL queries for reports and applications.
  • Estimates of tasks, duties and technologies for future releases and write technical documentation in collaboration on project plans.
  • Provide end user support and problem diagnosis and resolution.
  • Perform all assignments in accordance with ES&H, Security, and business practice requirements and policies.
  • Perform other duties as assigned.

Additional job responsibilities at the SES.2 Level
  • Provide technical guidance in SQL Tuning and Data Modeling.
  • Lead group ETL efforts and re-architect inefficient processes to be more performant.
Qualifications
  • 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 the equivalent combination of education and related experience.
  • Experience with formal software engineering methods.
  • Knowledge and/or experience with relational database design, techniques and development methodologies with the ability to understand the benefits and liabilities of various design patterns.
  • Experience using SQL, PL/SQL, and Oracle databases.
  • Experience developing ETL processes within Oracle database environments, as well as from non-Oracle environments, using SQL Server, MySQL, File Transfer, or similar technologies.
  • Ability to effectively manage concurrent technical tasks with competing priorities and deadlines.
  • Sufficient interpersonal skills necessary to effectively collaborate with customers and organizations in a multidisciplinary team environment.
  • Experience working independently and/or collaboratively as part of a multi-disciplinary team environment.
  • Proficient written, and verbal communication skills necessary to prepare, present and explain technical information to others.

Additional Qualifications at the SES.2 Level
  • Broad experience working in an Agile/Scrum environment.
  • Broad experience working with Business Intelligence Tools, such as, MicroStrategy, Tableau.
  • Comprehensive experience with PL/SQL and Data Architecture.
Additional Information
Why Lawrence Livermore National Laboratory?
  • Included in 2020 Best Places to Work by Glassdoor!
  • Work for a premier innovative national Laboratory
  • Comprehensive Benefits Package
  • Flexible schedules (*depending on project needs)
  • Collaborative, creative, inclusive, and fun team environment

Learn more about our company, selection process, position types and security clearances by visiting our Careersite .

COVID-19 Vaccination Mandate

LLNL demonstrates its commitment to public safety by requiring that all new Laboratory employees be immunized against COVID-19 unless granted an accommodation under applicable state or federal law. This requirement will apply to all new hires including those who will be working on site, as well as those who will be teleworking.

Security Clearance

LLNL is a Department of Energy (DOE) and National Nuclear Security Administration (NNSA) Laboratory. Most positions will require a DOE L or Q clearance (please reference Security Clearance requirement). If you are selected, wewill initiate a Federal background investigation to determine if youmeet eligibility requirements for access to classified information or matter. In addition, all L or Q cleared employees are subject to random drug testing. An L or Q clearance requires U.S. citizenship. If you hold multiple citizenships (U.S. and another country), you may be required to renounce your non-U.S. citizenship before a DOE L or Q clearance will be processed/granted. For additional information please see DOE Order 472.2 .

Equal Employment Opportunity

LLNL is an affirmative action and equal opportunity employer that values and hires a diverse workforce. 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 are committed to a diverse and equitable workforce with an inclusive culture that values and celebrates the diversity of our people, talents, ideas, experiences, and perspectives. This is essential to innovation and creativity for continued success of the Laboratory's mission.

LLNS is committed to offering reasonable accommodations during the application and recruiting processes due to a disability.If you need assistance or an accommodation due to a disability, please submit a request via our online form .

Pre-Employment Drug Test

External applicant(s) selected for this position will be required to 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.

CaliforniaPrivacy Notice

The California Consumer Privacy Act (CCPA) grants privacy rights to all California residents. The law also entitlesjob 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 .

Position Information

This is a Career Indefinite position. Lab employees and external candidates may be considered for this position.

Why Lawrence Livermore National Laboratory?
  • Included in 2022Best Places to Work by Glassdoor!
  • Work for a premier innovative national Laboratory
  • Comprehensive Benefits Package
  • Flexible schedules (*depending on project needs)
  • Collaborative, creative, inclusive, and fun team environment

Learn more about our company, selection process, position types and security clearances by visiting our Careersite .

COVID-19 Vaccination Mandate

LLNL demonstrates its commitment to public safety by requiring that all new Laboratory employees be immunized against COVID-19 unless granted an accommodation under applicable state or federal law. This requirement will apply to all new hires including those who will be working on site, as well as those who will be teleworking.

Security Clearance

This position requires a Department of Energy (DOE) Q-level clearance.If you are selected, wewill initiate a Federal background investigation to determine if youmeet eligibility requirements for access to classified information or matter. In addition, all L or Q cleared employees are subject to random drug testing. Q-level clearance requires U.S. citizenship.For additional information, please see DOE Order 472.2 .

Pre-Employment Drug Test

External applicant(s) selected for this position will be required to 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.

Equal Employment Opportunity

LLNL is an affirmative action and equal opportunity employer that values and hires a diverse workforce. 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.

If you need assistance and/or a reasonable accommodation during the application or the recruiting process, please submit a request via our online form .

CaliforniaPrivacy Notice

The California Consumer Privacy Act (CCPA) grants privacy rights to all California residents. The law also entitlesjob 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 .
Dice Id : LLNL
Position Id : REF2220V
Originally Posted : 5 months ago
Have a Job? Post it

Similar Positions

Cybersecurity Engineer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Software/Database Developer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Audio Video Installation Technician
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Computer Scientist
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Network Engineer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Unified Communications & Collaboration Engineer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
WIRELESS NETWORK ENGINEER
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Software Developer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Senior Java Developer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA
Security Software Engineer
  • Lawrence Livermore National Laboratory
  • Livermore, CA, USA