NREL Business Intelligence Analyst in Golden, Colorado

Posting Title

Business Intelligence Analyst

.

Location

CO - Golden

.

Position Type

Regular

.

Hours Per Week

40

.

Job Summary

Primary role of the Business Intelligence (BI) Analyst will be to develop reports and dashboards utilizing enterprise project and financial data. The BI Analyst will work directly with the Financial Analysts, Business Managers, the IT Data Management Team, and lab dashboard users to design, implement and maintain dashboards and reports. The ideal candidate has extensive experience translating raw data and user requirements into useful visualizations and reports. The BI Analyst will cultivate and align with a strong team culture and collaborative environment centered on consistently delivering exceptional performance and outcomes.

Duties shall include:

  • Responsible for the overall design, implementation and maintenance of the Office of the CFO’s (OCFO) reports and dashboards, which includes reports targeted to NREL’s executive team, lab program managers, project managers and project coordinators, and business units.

  • Create ad-hoc reports as requested in a timely and accurate manner to provide actionable data to senior level manager and above both internal and external to the department

  • Responsible for developing and executing test plans to ensure accuracy of data

  • Ensures the use of demonstrated best practices for multiple business intelligence solutions

  • Works directly with the IT Data Management Team including the Database Architect, BI Developer, Database Administrators, and Data Engineers to facilitate Data Hub and integration requirements, troubleshoot data anomalies, and build new functionality/enhancements within the enterprise data architecture

  • Works directly with report authors within the OCFO to ensure synchronization of efforts and provide training and best practice guidance

  • Provides BI analytic guidance to projects and teams, ensuring that new initiatives or enhancements to enterprise business systems enable effective data reporting and display

  • Responsible for turning business requirements into technical requirements through prototyping and requirements documentation

  • Develop improved data visualizations as well as consistent NREL-branding across business intelligence dashboards

  • Support the budgeting and planning process, including variance analysis as well as long term strategic planning

  • Assist in month end and year end close responsibilities

Knowledge, Skills and Attributes:

  • Deep understanding of general BI data strategies and solutions utilizing a wide range of products

  • Ability to read, analyze, and interpret common metrics used to measure and monitor operational performance, define problems, collect data, establish facts, draw valid conclusions, and provide clear and concise communication with a wide audience of internal departments

  • Expert data analytic skills, including expert Excel data modeling techniques (VBA, macros, PowerView, PowerQuery, PowerPivot, etc.)

  • 5 years of hands-on experience with at least one mainstream BI tool (Power BI, OBIEE, Tableau, etc.)

  • 5 years of experience with and a wide base of knowledge of general Data Management principles, methodologies, and frameworks including master data management, data security, data dictionaries, metadata management, data governance and data quality.

  • Expert in building complex visualizations out of raw data with drill-down capabilities

  • Deep subject matter expertise in business processes mapping, solution design, and data analysis in technical/business environments supporting reporting and analytics needs

  • Good understanding of finance and accounting including budget creation, financial reporting and analysis and cash flow planning.

  • Excellent communication and presentation skills

  • Ability to work well in a cross-organizational team environment

  • Entrepreneurial, self-starter that gets excited about rolling up their sleeves and proactively solving problems

.

Required Education, Experience, and Skills

Relevant Bachelor's Degree and 5 or more years of experience or equivalent relevant education/experience. Or, relevant Master's Degree and 3 or more years of experience or equivalent relevant education/experience. Or, relevant PhD or equivalent relevant education/experience. Or, relevant JD or equivalent relevant education/experience. Complete understanding and wide application of technical principles, theories and concepts in the field. General knowledge of other related disciplines. Considerable knowledge of laws, regulations, principles, procedures and practices related to specific field. Strong leadership, project management and problem solving skills. Ability to use various computer software programs.

.

Preferred Qualifications

.

Submission Guidelines

Please note that in order to be considered an applicant for any position at NREL 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.

.

EEO Policy

NREL is dedicated to the principles of equal employment opportunity. NREL promotes a work environment that does not discriminate against workers or job applicants and prohibits unlawful discrimination on the basis of race, color, religion, sex, national origin, disability, age, marital status, ancestry, actual or perceived sexual orientation, or veteran status, including special disabled veterans.

NREL validates right to work using E-Verify. NREL will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. For additional information, click here at http://www.nrel.gov/careers/employment-policies.html .

The National Renewable Energy Laboratory (NREL) is a leader in the U.S. Department of Energy’s effort to secure an environmentally and economically sustainable energy future. With locations in Golden and Boulder, Colorado, and a satellite office in Washington, D.C., NREL is the primary laboratory for research, development, and deployment of renewable energy technologies in the United States.

Please review the information on our Hiring Process at https://www.nrel.gov/careers/hiring-process.html website before you create an account and apply for a job. We also hope you will learn more about NREL at https://www.nrel.gov/about/ , visit our Careers site at https://www.nrel.gov/careers/ , and continue to search for job opportunities at https://nrel.wd5.myworkdayjobs.com/NREL at the lab.