Data Analyst II

TRC Companies, Inc. is a global consulting environmental and engineering firm serving the energy and infrastructure sectors. The Data Analyst II will support data management, analysis, reporting, dashboard development, and data visualization for strategic advanced energy projects. The role will also monitor performance metrics, improve data processes, and explore AI-enabled and geospatial approaches.

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

Preferred

Residency in the Denver, Colorado area preferred

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.

Advance your career through ongoing learning and development.

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.

Company

Environmentally focused consulting, engineering, and construction management

South Windsor, Connecticut, USA

https://www.trccompanies.com/

Founded in 1961

5001-10000 employees

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

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

A sufficient understanding of the energy industry to interpret the data required for the position is preferred

Residency in the Denver, Colorado area preferred

3+ years of experience performing data analysis and using tools to create reports, dashboards, and data exploration.

Required skills

Data Analysis, Power BI, Data Modeling, DAX, Interactive Dashboards, SQL, Python, R, Microsoft Excel, Microsoft Power Platform, Microsoft SharePoint, ArcGIS/Esri, AI and Machine Learning, Data Pipeline/API Integration

Preferred skills

Residency in the Denver, Colorado area preferred

Experience

3+ years