Business Intelligence (BI) Analyst

National Laboratory of the Rockies

1d•$76,600 - $126,400•Remote

About The Position

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.

Requirements

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.

Nice To Haves

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.

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.

Benefits

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
tuition reimbursement
performance-, merit-, and achievement- based awards that include a monetary component
relocation expense reimbursement