Posting Title
Business Intelligence (BI) Analyst

.

Location
Remote

.

Position Type
Regular

.

Hours Per Week
40

.

Job Description

National Laboratory of the Rockies’ (NLR) Office of the Chief Financial Officer (OCFO) is seeking a full-time Business Intelligence (BI) Analyst. This role reports within the Business Systems group and supports Financial Planning & Analysis. The role focuses on implementing and maintaining BI reporting tools, developing reports and dashboards, contributing to data governance, troubleshooting BI issues, and assisting with optimizing enterprise reporting structures for improved analytics and reporting performance across the enterprise. As well as assisting and developing training materials for stakeholders.

The analyst will collaborate with NLR Information Technology Services (ITS) data team for data governance, delivery of OCFO data sets, and troubleshooting BI system errors.

Key Responsibilities

• Participate in discussions with stakeholders to define and document requirements for new reports and dashboards.

• Serve as a subject matter expert for data visualization, reporting best practices, and data management frameworks.

• Design and develop innovative dashboards and visualizations to improve decision-making and business processes.

.

Basic Qualifications
Relevant Bachelor's Degree and 2 or more years of experience or equivalent relevant education/experience. Or, relevant Master's Degree or equivalent relevant education/experience.

Eligibility requirements: This position will require access to Controlled Unclassified Information which may include restricted dissemination requirements based on citizenship. As a result, applicants may be excluded from consideration based on citizenship in accordance with DOE O 471.7, Controlled Unclassified Information. https://www.directives.doe.gov/news/new-doe-o-471-7-controlled-unclassified-information

* Must meet educational requirements prior to employment start date.

Additional Required Qualifications

• Basic understanding and wide application of technical principles, theories, and concepts in the field.

• Basic knowledge of database concepts, data modeling, and schema design.

• Basic knowledge of Power BI, SSRS, Tableau, or other reporting tools.

• Strong proficiency with Microsoft Office productivity tools.

• Ability to access, query, analyze, and model incoming data.

• General knowledge of other related disciplines.

• Ability to work independently under general supervision and exercise judgment within established practices and procedures.

• Ability to work effectively in a team-oriented, matrixed organization.

• Must meet educational requirements prior to employment start date.

Preferred Qualifications

• Experience with SQL coding for data extraction, transformation, and optimization.
• Experience with Python, including use of Pandas for data manipulation, cleansing, modeling, and automation.
• Experience working with parquet files for optimized compression, storage, and movement of large datasets across reporting or analytics environments.
• Experience with Oracle databases, including accessing, querying, modeling, and restructuring financial or enterprise data.
• Experience with Azure SQL or other cloud-based database environments, including designing and maintaining cloud data structures for enterprise reporting.
• Experience with data engineering and data science techniques supporting enterprise reporting.
• Experience restructuring legacy financial data and optimizing wide tables for analytics.
• Proficiency in Microsoft Power BI, including DAX and governance best practices.
• Experience designing data visualizations and implementing reporting frameworks.
• Experience with Microsoft Office Products, especially Microsoft Excel and SmartView reporting
• Experience with financial systems.

.

Job Application Submission Window

The anticipated closing window for application submission is up to 30 days and may be extended as needed.

Annual Salary Range (based on full-time 40 hours per week)
Job Profile: Professional II / Annual Salary Range: $76,600 - $126,400

NLR takes into consideration a candidate’s education, training, and experience, expected quality and quantity of work, required travel (if any), external market and internal value, including seniority and merit systems, and internal pay alignment when determining the salary level for potential new employees. In compliance with the Colorado Equal Pay for Equal Work Act, a potential new employee’s salary history will not be used in compensation decisions.

Benefits Summary
Benefits include medical, dental, and vision insurance; short*- and long-term disability insurance; pension benefits*; 403(b) Employee Savings Plan with employer match*; life and accidental death and dismemberment (AD&D) insurance; personal time off (PTO) and sick leave; paid holidays; and tuition reimbursement*. NLR employees may be eligible for, but are not guaranteed, performance-, merit-, and achievement- based awards that include a monetary component. Some positions may be eligible for relocation expense reimbursement. Limited-term positions are not eligible for long-term disability or tuition reimbursement.

* Based on eligibility rules

Badging Requirement
NLR is subject to Department of Energy (DOE) access restrictions. All employees must also be able to obtain and maintain a federal Personal Identity Verification (PIV) card as required by Homeland Security Presidential Directive 12 (HSPD-12), which includes a favorable background investigation.

Drug Free Workplace

NLR is committed to maintaining a drug-free workplace in accordance with the federal Drug-Free Workplace Act and complies with federal laws prohibiting the possession and use of illegal drugs. Under federal law, marijuana remains an illegal drug.

If you are offered employment at NLR, you must pass a pre-employment drug test prior to commencing employment. Unless prohibited by state or local law, the pre-employment drug test will include marijuana. If you test positive on the pre-employment drug test, your offer of employment may be withdrawn.

Submission Guidelines

Please note that in order to be considered an applicant for any position at NLR you must submit an application form for each position for which you believe you are qualified. Applications are not kept on file for future positions. Please include a cover letter and resume with each position application.

.