Business Intelligence (BI) Analyst

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., * 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.

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., * 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., * 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.

Pulled from the full job description

• 403(b) matching
• Tuition reimbursement
• 403(b)
• AD&D insurance
• Health insurance
• Paid time off
• Vision insurance, 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.

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., 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.