Business Intelligence Developer Jobs

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.
Pay Range
$123,960 - $159,168 Annually for the SES.2 level
$148,650 - $190,932 Annually for the SES.3 level
Please note that the pay range information is a general guideline only. Many factors are taken into consideration when setting starting pay including education, experience, the external labor market, and internal equity.

We have an opening for a 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 business experts to create and optimize data loading processes and visualize enterprise reporting across the Laboratory. This position is in the Enterprise Application Services Division within the Computing Directorate, in support of the LivIT Program.
This position will be filled at either the SES.2 or SES.3 level 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.
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, develop, and implement MicroStrategy Reports and Dossiers in collaboration with project team members, consultants, and business stakeholders.
Gather functional requirements, develop Business Intelligence (BI) solution architecture, design dashboards (Dossiers), and ad-hoc reports in collaboration with business stakeholders.
Provide input to project plans that include estimates of tasks, duties and technologies for future releases and write technical documentation.
Provide end user support and problem diagnosis and resolution.
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
Design, implement, and maintain complex ETL (Extract, Transform, and Load) processes to integrate various data sources for enterprise reporting.
Provide advanced SQL tuning skills for complex queries, ETL’s, and data processing.
Provide database and MicroStrategy architecture.
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 equivalent combination of education and related experience.
Proficient in MicroStrategy Schema design and data warehouse design.
Broad experience working with complex MicroStrategy reports using advanced filters, level metrics, and transformation metrics.
Broad experience building, troubleshooting, and optimizing cubes and writing SQL queries to validate reports and dashboards.
Broad experience identifying and analyzing source data and mapping required metrics and hierarchies using the MicroStrategy semantic layer.
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
Advanced knowledge of dimensional data modeling, data warehouse, and reporting techniques.
Advanced experience with MicroStrategy architecture and design.
Advanced experience developing ETL processes within Oracle database environments and non-Oracle environments using SQL Server, MySQL, File Transfer, or similar technologies.
Qualifications We Desire
Working knowledge of Atlassian Jira, Confluence, or other collaboration/planning tools.
Experience with Denodo or other data virtualization technologies.
Experience with Agile methodologies.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Position Information
This is a Flexible Term appointment, which is for a definite period not to exceed six years. If final candidate is a Career Indefinite employee, Career Indefinite status may be maintained (should funding allow).
Why Lawrence Livermore National Laboratory?
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.
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.