Data Analyst, Colorado Solar for All

Department Information

The mission of the Colorado Energy Office (CEO) is to reduce greenhouse gas emissions and consumer energy costs by advancing clean energy, energy efficiency, and zero emission vehicles to benefit all Coloradans. We do this by developing and implementing highly impactful policies and programs, establishing Colorado as a leading state for climate action. The Colorado Energy Office is a great place to work, with collaborative and talented employees who are passionate about our mission and a hybrid (work from home/work from office) atmosphere. We are committed to increasing the diversity of our staff and providing culturally responsive programs and services. Therefore, we encourage responses from people of diverse backgrounds and abilities.

Description of Job

Starting Salary Range: $75,000.12 - $85,000.24 Annually

• This position is eligible for a hybrid working arrangement with an obligation to appear in the office on a weekly basis as determined by your department's director. Expectation is to be in-person at the Denver office at least one day per week. Funding for the position is tied to the federal grant which has a period of performance through August 31, 2029.

The Colorado Solar for All (COS4A) data analyst will develop and manage the extensive reporting process required by the Environmental Protection Agency (EPA) for Solar for All. This includes facilitating data collection for the EPA’s transaction and project level report, semi-annual report and Davis Bacon weekly reporting. The expectations for this program in Colorado and nationally are high, and candidates for this position should have extensive experience in data analysis with an understanding of the solar industry and associated metrics. The COS4A Data Analyst will be critical in designing and launching the program's reporting process and documentation to ensure compliance with the grant’s reporting requirements.

• Promote data-driven decision making through the collection, utilization and management of program and publicly accessible data.
• Work with COS4A team members and sub-contractors to develop standard operating procedures (SOPs) for data collection, management, and reporting processes, consistent with EPA reporting and Quality Assurance requirements and continuously improving as needed.
• Have ability to navigate and understand EPA AVERT, NREL PV Watts and any EPA provided calculators to generate metrics and understand outputs.
• Work with the COS4A Director, CEO IT professionals and Office of Information Technology (OIT) on procurement and development of a reporting software solution.
  • Manage the collection and storage of data within the chosen application
  • Develop customized reports necessary to meet grant reporting requirements
  • Support COS4A team members in processing and analyzing outputs and reports
• Create public dashboards to show program metrics and progress either through selected software solution or with Excel, Google Sheets, Tableau, PowerBI or similar platforms.
• Effectively communicate complex data findings to both technical and non-technical audiences.
• Conduct research, regularly review quantitative and qualitative data including program metrics and grantee feedback, evaluate program outcomes, and provide recommendations to the solar program managers as needed to ensure compliant reporting practices.
• Regularly identify public or program-specific datasets that help the COS4A improve program delivery and program outcomes and support communications and engagement strategies.
• Ensure program compliance with federal grant requirements, EPA requirements, Colorado Revised Statutes, CEO policies and procedures, Governor’s office employee handbook, Build America Buy America and Davis-Bacon Act.

• Work closely with COS4A team members and with CEO’s Quality Assurance Manager on any environmental information reporting.
• Work closely with CEO’s Communications and Engagement team to develop public communications related to program progress and success.
• Develop and maintain strong external stakeholder relationships including industry, local governments, utilities, financial institutions, community based organizations, other state agencies including the Public Utility Commission, Department Of Local Affairs and Colorado Department of Labor and Employment and formal and informal partner relationships needed for successful implementation.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

• Graduation from an accredited college or university with a Bachelor's degree in business administration, science, mathematics, engineering or related field.
  • Substitutions: additional, appropriate professional experience may be substituted for the degree requirement on a year-for-year basis
• Minimum 3 years of professional experience including at least 2 years in data analysis
• Working knowledge of statistical methods for data analysis
• Understanding of metrics involved with the solar industry
• Excellent knowledge of Microsoft Excel and Google Sheets for data analysis
• Excellent knowledge of database structure and functionality
• Excellent time management and organizational skills
• Excellent written, oral, and presentation communication skills
• Knowledge of federal and state policies, procedures and reporting requirements

Preferred Qualifications

• Master’s Degree in related field
• Ability to use PowerBI, Tableau, ArcGIS or similar platforms
• Experience in the solar industry
• EPA grant experience

Supplemental Information

To Apply:

A cover letter and resume must be submitted with the application for consideration. Your cover letter and resume must provide sufficient detail about your background and experience to allow the screening panel to properly assess your experience in the required elements, including your experience and achievements.

The State of Colorado/Office of the Governor offers a generous benefits package including:

• Annual leave accrued at 13.33 hours per month (4 weeks a year)
• Sick leave accrued at 6.66 hours a month (10 days a year)
• 12 paid holidays per year
• Medical and dental plans
• State paid life insurance policy of $50,000
• Choice of 2 retirement plans
• 401K and 457 plans
• State paid Short Term Disability coverage
• Additional optional life and disability plans
• Credit Union Membership
• RTD pass
• Training and professional development

Equity, Diversity and Inclusion

The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.

ADAAA Accommodations

The Office of the Governor is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADAAA Staffing Coordinator (the Director of Human Resources) at gov_hr@state.co.us.

Conditions of Employment

Applicants must pass a thorough background check prior to employment.