Data Analyst II

Groundbreaker. Game changer. Pioneer.

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.

TRC's professionals work with a broad range of commercial, industrial and government clients and the communities they serve. We deliver breakthrough solutions that address local needs -- so our clients can better succeed in an ever-changing world.

Working at TRC means tackling interesting, meaningful projects. We pride ourselves on our collaborative spirit, entrepreneurial zeal and agile corporate structure. 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.

The successful candidate will be responsible for analyzing metrics and report building for various programs throughout the country. Must have the knowledge and expertise to create, edit, and modify data sets with the ability to analyze and create accurate reports. The core objectives of this position will be to provide reports and analytics in a clear, accurate, and timely manner to various clients.

This position will include, but not limited to, the following tasks:

• Provide valuable insight to the program team based on the data collected for the program, in order for the team to make informed decisions.
• Provide input for troubleshooting, process improvements, and system enhancements.
• Customized dashboards and reporting for Client, subcontractor, management, cross-functional team members.
• Sorting through and interpreting high quantities of data.
• Monitor and report program key performance metrics and provide updates to management.
• Support weekly and monthly invoicing reviews and approvals.
• Work with the team's needs for tracking all fields and metrics required of each project, and the overall program.
• Developing data models through reporting and visualization to support decision-making.
• Identifying, diagnosing, and correcting discrepancies in data sets to ensure accuracy.
• Track weekly, monthly, quarterly and annual reporting deadlines and fulfill reporting requirements.
• Identify opportunities for process improvements and automation.
• Performing technical analysis and energy modeling to support program savings claims and program reporting
• Researching and presenting market intelligence and customer trends.
• Analyze recurring reports to identify opportunities as well as provide ad hoc analysis

General High-Level Roles

• Captures configuration (adding fields, updating field names, update forms, workflows)
• Captures dashboards
• Captures export/import (measure template creation, milestone track creation/updates, bulk data fixes, etc.)
• IT Jira Ticket Creation and/or working with the IT Contact to develop requirements
• Reporting
• ANB eTrack testing/troubleshooting/etc.

• Bachelor's Degree
• 2-5 years of experience performing data analysis
• 2+ years creating using tools to create reports, dashboards, and data exploration
• Excellent verbal and written communication skills, time management skills, and attention to detail
• Advanced computer skills: experience with MS Office (Word, Excel, PowerPoint, Outlook, Teams).
• Experience with Data analysis software (Excel, R Programming, SQL, Tableau, PowerBI),
• Ability to contribute to multiple projects simultaneously with demonstrated attention to detail
• Strong interest in sustainability and energy efficiency industry

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.

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.