Note: The job is a remote job and is open to candidates in USA. National Laboratory of the Rockies is a mission-driven research organization focused on energy innovation, systems integration, and secure, reliable energy solutions. The Business Intelligence (BI) Analyst will support Financial Planning & Analysis by implementing and maintaining BI reporting tools, developing dashboards, contributing to data governance, troubleshooting BI issues, and improving enterprise reporting performance. The role will also collaborate with Information Technology Services and support stakeholder training.
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
Skills
- 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
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Short-term disability insurance
- Long-term disability insurance
- Pension benefits
- 403(b) Employee Savings Plan with employer match
- Life insurance
- Accidental death and dismemberment (AD&D) insurance
- Personal time off (PTO)
- Sick leave
- Paid holidays
- Tuition reimbursement, based on eligibility rules
- Performance-, merit-, and achievement-based awards that include a monetary component, for eligible NLR employees; not guaranteed
- Relocation expense reimbursement for eligible positions
- Robust professional development opportunities
Company Overview