Data Analyst II

About Us

TRC, Member of WSP, is a global consulting environmental and engineering firm and one of the top design firms in the energy sector. Together, TRC and WSP’s 83,000 experts create positive, long-lasting impacts for our communities and our clients in the power and energy, transportation and infrastructure, environmental, and property and buildings sectors. As part of our team, you’ll discover a world of opportunities to connect with innovative thinkers, forge your path, and have fun tackling the world’s most challenging projects.

At TRC, Member of WSP, you can have a rewarding career on every level.

TRC has long set the bar for clients who require more than just engineering, combining science with the latest technology to devise innovative solutions that stand the test of time. From pipelines to power plants, roadways to reservoirs, schoolyards to security solutions, clients look to TRC for breakthrough thinking backed by the innovative follow-through of an industry leader.

We recognize that the expertise of our staff is our strongest asset, so we generously reward employees for successful performance and invest in their careers through training and the development of new skills and certifications.

Overview

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.

Why Consider This Job Opportunity?

Advance your career through ongoing learning and development

Maintain a healthy work-life balance with supportive policies

Collaborate within an inclusive and respectful team environment

Contribute to a rapidly expanding and future-focused industry

Support impactful projects driving the clean energy transition

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.

Qualifications

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.

Residency in the Denver, Colorado area preferred.

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.

Benefits * : TRC offers a competitive benefit package consisting of:

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.

These benefits are applicable to US employees depending on their employment status (full time, part time, or temporary). TRC offers jurisdiction specific benefit packages for International and Puerto Rico employees.

Compensation : In accordance with local law, the below salary range is applicable for the job and location associated with this requisition. Compensation will vary based upon experience, education, skill level, geographical location, and other compensable factors.

Other Compensation: 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.

Disclaimers

TRC is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by applicable law. All employment decisions are made based on qualifications, merit, and business needs. We celebrate diversity and are committed to creating an inclusive environment for all employees.

The complete job description and application are available on TRC’s career site.

TRC accepts applications for this position on an ongoing, rolling basis and reserves the right to cancel this posting at any time.

Salary Range

USD $70,586.88 - USD $85,000.00 /Yr.

Employment type: Full-time

Industries: Environmental Services