Vacancy expired!
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 MandateLLNL 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 ClearanceLLNL 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 OpportunityLLNL 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 TestExternal 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 NoticeThe 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 InformationThis 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 MandateLLNL 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 ClearanceThis 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 TestExternal 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 OpportunityLLNL 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 NoticeThe 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 .
- ID: #43309043
-
State: California
Livermore
94550
Livermore
USA
- City: Livermore
- Salary:
USD
TBD
TBD
- Job type: Permanent
- Showed: 2022-06-19
- Deadline: 2022-08-17
- Category: Et cetera