Department Information

Description of Job

This announcement is open only to eligible individuals currently employed within the Office of the Governor. The announcement is for transparency purposes only to comply with the Equal Pay for Equal Work Act. Only applications from eligible individuals currently employed within the Office of the Governor will be accepted.
Starting Salary Range:

The Data Analyst will play a crucial role in supporting the Weatherization Assistance Program at the Colorado Energy Office. The successful candidate will have a deep understanding of managing and analyzing data to optimize program efficiency and effectiveness. This candidate will primarily focus on data-related projects that enhance and improve WAP’s processes and deliverables to our subgrantees and clients across Colorado.

Key Responsibilities:

• Front-end Salesforce Projects and Project Management

  • Manuals and additional resources
  • Dashboards
  • Oversee licenses
  • Management of the product backlog
  • Liaise with STAR team and vendors
• Geographic Information Systems (GIS)
  • Coordinate ESRI GIS licensing for CEO. Work closely with ESRI and CEO Operations to solicit licensing requirements and request any new quotes or maintenance documents.
  • Develop WAP GIS WebApps platforms for sharing data
  • Work with CEO WAP leadership to perform ad hoc spatial analysis
  • Work with CEO WAP staff and subgrantees to provide trainings, education and progress updates
  • Develop WAP maps for allocation formula to identify those in need of WAP services (i.e. energy burdened populations)
  • Collaborate with the CEO WAP Sr. Engagement Manager to understand Engagement GIS needs and work together to meet those needs when possible.
• Rebates
  • Recover Energy Efficiency rebates
    • Process rebate recovery monthly and provide mid-year forecasts as necessary
    • Update process documentation.
  • Track rebate revenue
    • Track administrative and operational revenue as needed
  • Solar rebates
    • Assist with the process of rebate recovery monthly.
    • Assist with WAP-Xcel Annual Solar Report for submission to Xcel.
    • Collaborate with creating and updating process documentation.
  • Rebate contract amendments
    • Serve as the main point of contact for communication with Utilities regarding rebate contracts
    • Provide rebate forecasts and lead efforts to initiate contract amendments and all associated tasks
• Data Management and Analysis
  • Explore WAP data and identify areas for improvement, such as data gaps or duplicative data
  • Provide data to CEO WAP colleagues when necessary, such as DOE reports, Discovery Requests, State Plan submissions, etc.
  • Perform external data requests from stakeholders as needed.
  • Oversee data clean up efforts.
  • Engage with utility partners to collect client utility data for program analyses.
• Allocation Formula
  • Oversee the maintenance and evolution of the CEO WAP Allocation Formula

  • Work with CEO WAP leadership to identify priorities to emphasize within the Formula

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

• Bachelor's or Master's degree in Data Science, Statistics, Geography, Environmental Studies, a related field, or equivalent experience in the following:

  • Data management, analysis, and reporting
  • Proficiency in utilizing Salesforce for data management, analysis, and reporting
  • GIS and relevant GIS software, such as ArcGIS or QGIS
• Strong analytical skills with the ability to interpret complex datasets
• Excellent attention to detail and accuracy in data processing and reporting
• Excellent written and verbal communication skills.

• Demonstrated ability to work collaboratively in a team environment.

Preferred Qualifications:

• Salesforce reporting and database

Supplemental Information

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.