Utility Analyst

trak group

Union Township, OH

Apply

JOB DETAILS

SKILLS

ACT!, Analysis Skills, Auditing, Billing, Communication Skills, Computer Skills, Contract Approval, Contract Management, Cost Control, Customer Relationship Management (CRM) Systems, Customer Support/Service, Customer/Client Research, Data Quality, Data Sets, Detail Oriented, Financial Reporting, Internet Service Providers, Microsoft Excel, Natural Gas, Organizational Skills, Pivot Tables, Presentation/Verbal Skills, Problem Solving Skills, Purchasing/Procurement, Record Keeping, Reporting Skills, Telecommunications, Time Management, Trend Analysis, Usage Analysis, Writing Skills

LOCATION

Union Township, OH

POSTED

10 days ago

Utility Analyst

Setting/Hours: 100% In-Office | 8-5

Join trak group in partnering with a growing client in Union Township, Ohio that’s expanding its Shared Services team.

The Utility Analyst is responsible for analyzing utility invoices, monitoring utility accounts,
identifying billing discrepancies, maintaining utility-related Excel spreadsheets, and providing
analytical support for clients and internal teams. This position requires strong Excel skills,
attention to detail, and the ability to interpret utility tariffs, supplier contracts, and billing data.

Key Responsibilities:
•Review and analyze electric, natural gas, water, sewer, telecommunications, ISP, fire and
alarm and elevator invoices for accuracy and cost savings opportunities.
•Audit utility bills to identify billing errors, overcharges, rate discrepancies, and savings
opportunities.
•Maintain utility account records, including account numbers, service locations, suppliers,
contract expiration dates, and billing contacts.
•Prepare monthly, quarterly, and annual utility reports for clients and management.
•Develop and maintain Excel spreadsheets used for utility tracking and reporting.
•Analyze historical usage and cost trends to identify anomalies and cost-saving
opportunities.
•Support utility procurement activities by gathering account information and usage data.
•Assist with utility supplier contract administration and renewal tracking.
•Coordinate with utility companies, suppliers, and clients to resolve billing and account
issues.
•Verify implementation of utility rate changes, supplier enrollments, and contract terms.
•Prepare ad hoc reports and perform special projects as assigned.
•Implement client approved recommendations, working with vendors and clients through
email and telephone conversations.

Required Qualifications:
•Advanced Microsoft Excel skills, including:
o Maintaining Pivot Tables
o Maintaining VLOOKUP/XLOOKUP
o Data validation
o Conditional formatting
o Charting and reporting
•Strong analytical and problem-solving abilities.
•IT skills relating to networks, telecommunications
•Excellent attention to detail and accuracy.
•Strong organizational and time-management skills.
•Effective written and verbal communication skills.
•Comfortable working with large Excel datasets and performing account audits.

Preferred Qualifications:
•Experience with CRM systems (specifically ACT!)
•Experience creating automated reports.
•Experience with Excel Power Query

Success Factors:
The ideal candidate is highly organized, detail-oriented, comfortable working with large
datasets, and enjoys identifying billing discrepancies and cost-saving opportunities. They
possess strong Excel skills and can communicate findings clearly to clients, suppliers, and
internal stakeholders.

If you're ready to take the next step in your career and want to make an impact, partner with trak group to explore this opportunity.

#shared

About the Company

trak group

trak group, established in 1972, is proud of its impeccable reputation as a professional recruiting and staffing firm. trak has demonstrated an unmatched level of expertise and success in the industry, and takes great pride in its A+ rating from the Better Business Bureau.

trak has been awarded “Best Places to Work” by the Business Courier three consecutive years; following the third and final nomination, trak was respectfully awarded with “The Best of the Best”. We continue to hold the Consumers’ Choice Award for Business Excellence and the “SPECTRUM Award” for Service Excellence from City Beat News indicating a 5-star customer service rating. Six of our employees have been inducted into the prestigious “International Hall of Fame” and four carry national certifications lending to their dedication and passion for our industry.

Specializing in direct hire, alternative hire and contract opportunities, trak is currently partnering with over 300 client companies in the Greater Cincinnati and Northern Kentucky Area. Because we are proud of our process, we take time to source, screen and evaluate each candidate. Our placement fields include office support, customer service, accounting and finance, operations, management, human resources, sales and marketing, engineering and supply chain management.

COMPANY SIZE

500 to 999 employees

INDUSTRY

Staffing/Employment Agencies

FOUNDED

1972

WEBSITE

http://www.trakcincy.com/