Data Analyst

Trc Companies, Inc.; New Brunswick (NJ); On-site; USD 62,000 - 82,000; Full time

Benefits offered by this job

Health insurance

401(k) with company match

Paid time off

Paid holidays

Sick, family and disability leave

Job summary

TRC Companies, Inc. in New Jersey is seeking a Data Analyst to ensure data accuracy and integrity for energy efficiency programs.

You will run comprehensive reports, optimize CRM usage, and collaborate with management, contractors, and client teams in a fast-paced environment. The ideal candidate has strong Excel and programming skills, experience with data review, and the ability to coordinate across multiple internal and client stakeholders.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• Ability to travel within New Jersey and attend site visits.
• Proficiency in MS Excel, programming, and CRM usage.
• Strong attention to detail and data accuracy.
• Excellent oral and written communications; team oriented.

Responsibilities

• Understand and optimize CRM usage, reports, and dashboards.
• Run and maintain Excel-based reports to manage data quality.
• Analyze pipeline data to identify trends and compliance issues.
• Coordinate QA/QC review parameters across the program portfolio.
• Develop customer facing tools and data integrations across platforms.
• Forecast program production and goals via data analysis.
• Document findings clearly and present trends to management.
• Prepare PowerPoint presentations detailing findings and trends.
• Collaborate with internal teams and client stakeholders on requirements.
• Learn energy efficiency principles and mathematical models.

Skills

Excel

Programming

Data analysis

CRM

Communication

Team collaboration

Education

Bachelor's degree

Tools

CRM systems

Power BI

Job description

About Us

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.

Overview

The Data Analyst will ensure the accuracy, integrity, and compliance of energy efficiency program data and project pipelines and optimize use of program tools and systems. Working closely with TRC management, Trade Allies (contractors), and the client's QA/QC team, the Analyst will be responsible for running comprehensive reports that measure pipeline health, performance and future outlook. The ideal candidate has strong Excel, programming and data review skills, excellent follow-through, sound judgment, and the ability to coordinate across internal teams, contractors/Trade Allies, and client stakeholders in a fast-paced program environment.

Responsibilities

• Understand and optimize use of CRM, its process flows, output reports, and dashboards.
• Run and maintain Excel-based reports to proactively manage data and ensure pipeline attention and quality.
• Analyze project pipeline data to identify trends, outliers, and potential compliance issues; elevate findings and recommend corrective actions to TRC management.
• Collaborate with TRC & client management to define, refine, and standardize QA/QC review parameters across the energy efficiency program portfolio.
• Develop and maintain customer facing tools and data integration across multiple platforms.
• Support short- and long-term forecasting of program production and goal attainment through pipeline data analysis.
• Document programmatic findings clearly, elevate issues timely, and recommend corrective actions to improve project accuracy and consistency.
• Develop and present PowerPoint presentations to management detailing findings and trends.
• Coordinate with internal project teams, planning/reporting teams, outreach staff, management, Trade Allies, and the client to align on requirements, resolve issues, and maintain consistent review standards.
• Collaborate cross-functionally with internal project, planning, and management teams to ensure data accuracy and consistency.
• Learn, understand, and apply energy efficiency principles and mathematical models.
• Provide timely client support with commitment to customer satisfaction.
• Apply appropriate principles, theories, and concepts to complete assignments within timeframe required.
• Participate in and deliver internal and external trainings.
• Participate in and attend Trade Ally events and trainings.

Qualifications

• Bachelor’s degree from an accredited college in a related discipline, or equivalent experience/combined education, with up to 5 years of professional experience. Considered an emerging authority and SME in related discipline.
• Ability to attend site visits throughout the State of New Jersey.
• Strong computer and record-keeping skills: proficiency in MS Excel, programming, and use of Customer Relationship Management (CRM).
• Ability to handle a high volume of combined inquiries, workbook, database, and documentation reviews.
• Strong attention to detail and commitment to data accuracy.
• Strong proficiency in Microsoft Excel, including pivot tables, exception reporting, and data analysis.
• Excellent oral and written communications skills.
• Team player with a positive attitude and ability to work effectively across different teams.
• Ability to work with culturally diverse customers and contractors effectively and respectfully.
• Excellent time management and organizational skills
• Eligibility to work in the United States.

PREFERRED QUALIFICATIONS

• 1-5 years of experience in QA/QC, data analysis, forecasting, pipeline management, or accounts receivable.
• Experience working with contractors, vendors, or Trade Allies preferred.
• Technical, engineering, sustainability, LEED, CEM, or energy-related background or credentials are a plus.

WORK LOCATION

Candidate will be required to travel to Trade Ally events and trainings as required (approximately 10% within the State of New Jersey). Candidate will also be expected to work from the TRC New Jersey office, located at 317 George Street, Suite 520, New Brunswick, NJ 08901, approximately one day per week on average, and attend meetings at the utility client’s office as needed.

NOTE: Candidate must be New Jersey Resident and reside in New Jersey.

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 based on qualifications, merit, and business needs.We celebrate diversity and are committed to creating an inclusive environment for all employees.

Salary Range

USD $62,004.80 - USD $82,000.00 /Yr.