Business Intelligence (BI) Analyst

Posting Title Business Intelligence (BI) Analyst . Location Remote . Position Type Regular . Hours Per Week 40 . Working at NLR Join the National Laboratory of the Rockies (NLR), where world-class scientists, engineers, and experts are accelerating energy innovation through breakthrough research and systems integration. From our mission to our collaborative culture, NLR stands out in the research community for its commitment to an affordable and secure energy future. Spanning foundational science to applied systems engineering and analysis, we focus on solving complex challenges to deliver advanced, secure, reliable, and cost-effective energy solutions. Our work helps strengthen U.S. industries, support job creation, and promote national economic growth. At NLR, you'll find a mission-driven environment supported by state-of-the-art facilities, multidisciplinary research teams, and strong collaborations with industry, academia, and other national laboratories. We offer robust professional development opportunities, and a competitive benefits package designed to support your career and well-being. 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. Conduct data analysis and modeling to identify trends, insights, and actionable recommendations. Develop and document business requirements for new data sets, reports, and dashboards. Perform testing and validation of reports/dashboards, ensuring adherence to business and technical requirements. Define, validate, and manage business definitions for data sets and reporting schemas. Collaborate with ITS to enhance data governance policies and ensure the accuracy and integrity of enterprise data. Contribute to the development of new data sets, ensuring alignment with business requirements and reporting needs. Provide troubleshooting and support for BI stakeholders and end-users. Support development and maintenance of system documentation and training materials. Contribute to creation and refinement of data governance policies and procedures. Support education and training for customers using available BI and reporting tools. Analyze new data sources for integration into the enterprise reporting framework. Recommend and implement enhancements to the OCFO BI reporting framework for improved performance and scalability. Actively contribute to cross-functional projects, ensuring alignment with OCFO objectives. . 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. Excellent written and verbal communication skills. Strong organizational and time management abilities. Ability to communicate technical concepts to non‑technical audiences. Strong team orientation, supporting colleagues consistently. Demonstrated analytical and problem‑solving capabilities. 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. . Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard basis of age (40 and over), color, disability, gender identity, genetic information, marital status, domestic partner status, military or veteran status, national origin/ancestry, race, religion, creed, sex (including pregnancy, childbirth, breastfeeding), sexual orientation, and any other applicable status protected by federal, state, or local laws. Reasonable Accommodations E -Verify www.dhs.gov/E-Verify For information about right to work, click here for English or here for Spanish. E-Verify is a registered trademark of the U.S. Department of Homeland Security. This business uses E-Verify in its hiring practices to achieve a lawful workforce.