Data Analyst II

TRC Companies, Inc. • Denver, CO

3d • Remote

About The Position

TRC’s Advanced Energy Strategic Deployment team is seeking a Data Analyst II to support data management, analysis, and reporting across strategic projects that advance the energy sector. The successful candidate will be responsible for analyzing metrics and building reports for a variety of projects, with the knowledge and expertise to create, edit, and modify data sets and produce accurate, timely, and clear analytics for the team and our clients. The ideal candidate is an independent, detail-oriented contributor with a positive attitude who excels at multitasking while maintaining a high degree of accuracy, efficiency, and reliability. They will bring curiosity about emerging tools—including AI—and a desire to apply data analytics, visualization, and geospatial techniques to real-world advanced energy challenges. A sufficient understanding of the energy industry to interpret the data required for the position is preferred.

Requirements

• Bachelor’s degree in Data Analytics, Computer Science, Geography/GIS, Engineering, Environmental Studies, a related field, or equivalent experience.
• 3+ years of experience performing data analysis and using tools to create reports, dashboards, and data exploration.
• Advanced computer skills, including MS Office (Word, Excel, PowerPoint, Outlook, Teams); advanced Excel skills preferred.
• Experience with data analysis and visualization software (e.g., Power BI, SQL, Tableau, R, or Python).
• Excellent verbal and written communication skills, strong time-management skills, and attention to detail.
• Ability to contribute to multiple projects simultaneously with demonstrated accuracy and reliability.
• Experience applying AI / machine-learning tools to data analysis, automation, or reporting.
• Strong Power BI development skills (data modeling, DAX, interactive dashboards).
• Microsoft Enterprise ecosystem experience, including Microsoft Dynamics (a plus), Power Platform, and SharePoint.
• ArcGIS / Esri experience for spatial data creation, analysis, and visualization.
• Additional data analytics skills such as SQL, Python, R, or data-pipeline/API integration.
• Ability to multitask, prioritize, and self-direct across many concurrent stretch assignments in a high-paced, high-accountability environment with minimal oversight.
• Strong interest or experience supporting projects in the energy space, such as energy efficiency (EE), demand response (DR), distributed energy resource management systems (DERMS), or similar utility/clean-energy projects.

Nice To Haves

• Residency in the Denver, Colorado area preferred.

Responsibilities

• Provide valuable insight to program teams based on the data collected, enabling informed decision-making.
• Build and maintain customized dashboards and reporting for clients, subcontractors, management, and cross-functional team members in our Customer Relationship Management (CRM) database.
• Sort through and interpret high quantities of data, identifying, diagnosing, and correcting discrepancies to ensure accuracy.
• Develop data models through reporting and visualization to support decision-making.
• Monitor and report program key performance metrics and provide updates to management.
• Support program platform tasks, including configuration, dashboards, and data import/export as directed.
• Provide input for troubleshooting, process improvements, automation, and system enhancements.
• Research and present market intelligence and customer trends to support strategic advanced energy projects.
• Explore and pilot AI-enabled and geospatial (GIS) approaches to streamline data-intensive processes and enhance analysis.

Benefits

• Medical, dental, vision, and disability insurance.
• 401k package that includes both traditional and Roth IRA options and Company match.
• Paid time off contingent upon full time or part time status and level of seniority (ranging from 15 to 25 days per year).
• All full-time employees enjoy a minimum of 8 Paid Holidays per year.
• TRC ensures that all employees, including those that work part-time, receive paid sick, family, and disability leave in accordance with the laws of their state of residence.
• Employee may be eligible for participation in the Company’s annual Discretionary Bonus Program which is contingent on Company, Business Segment, and Individual performance against Key Performance Indicators which vary by year and employee.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level