Utility Analyst

Phillips Edison & Company, Inc.; Cincinnati (OH); On-site; USD 65,000 - 90,000; Full time

Job summary

Phillips Edison & Company, Inc. is seeking a detail-oriented analyst to manage utility billing data across a diverse real estate portfolio. You will review invoices, validate data, and coordinate with Accounting and Property Management to resolve discrepancies.

You will also support sustainability reporting, analyze usage trends, and develop dashboards to monitor utility costs. Collaboration across departments is essential to drive efficiencies and cost savings.

Qualifications

• Bachelor’s degree in a related analytical field (Finance, Accounting, Economics, Data Science, Sustainability, Engineering, or Mathematics).
• Strong Excel proficiency with data analysis, formulas, and large datasets.
• Demonstrated analytical and problem-solving capabilities.
• Excellent attention to detail and organizational skills.
• Effective written and verbal communication skills.
• Ability to manage multiple priorities and meet deadlines.
• Collaborative mindset across departments and stakeholders.

Responsibilities

• Manage utility billing data across a diverse real estate portfolio.
• Review, validate, and analyze utility invoices for accuracy and completeness.
• Investigate billing discrepancies and coordinate with vendors, Accounting, and Property Management to resolve issues.
• Maintain utility databases and ensure data integrity across reporting systems.
• Monitor consumption and costs to identify anomalies and opportunities for optimization.
• Support rate analysis and evaluate rate structures to optimize expenditures.
• Develop recurring reports and dashboards related to utility usage and costs.

Skills

Excel

Data analysis

Problem solving

Attention to detail

Communication

Multitasking

Education

Finance

Accounting

Engineering

Data Science

Economics

Sustainability

Tools

Power BI

Tableau

Job description

Key Responsibilities

Utility Billing & Data Management (Approximately 70%)

• Manage utility billing data across a diverse real estate portfolio.
• Review, validate, and analyze utility invoices for accuracy and completeness.
• Investigate billing discrepancies and coordinate with vendors, utility providers, Accounting, and Property Management to resolve issues.
• Maintain utility databases and ensure data integrity across reporting systems.
• Monitor utility consumption, costs, and trends to identify anomalies and opportunities for improved performance.
• Support utility rate analysis and evaluate rate structures to optimize utility expenditures.
• Develop recurring reports and dashboards related to utility usage and costs.

Stakeholder Support & Customer Service (Approximately 10%)

• Serve as a primary point of contact for utility-related questions from Property Management and Accounting teams.
• Respond to inquiries regarding utility billing, account setup, service issues, and consumption trends.
• Collaborate with internal stakeholders to improve utility-related processes and workflows.
• Build strong working relationships with utility providers and third-party vendors.

Sustainability Reporting & Analytics (Approximately 10%)

• Support annual sustainability reporting efforts by collecting, organizing, and analyzing utility consumption data.
• Assist with greenhouse gas emissions and resource consumption reporting.
• Contribute to internal and external sustainability disclosures and performance updates.
• Support data collection and validation for environmental and sustainability initiatives.

Special Projects & Performance Analysis (Approximately 10%)

• Assist with measurement and verification (M&V) activities for energy and water efficiency projects.
• Support analysis of resource reduction initiatives and operational improvement projects.
• Participate in cross-functional projects involving energy, water, waste, and sustainability data.
• Conduct ad hoc analyses and research to support sustainability and operational objectives.

Qualifications

Required

• Bachelor’s degree in Finance, Accounting, Engineering, Data Science, Business Analytics, Economics, Mathematics, Sustainability, or a related analytical field.
• Strong proficiency in Microsoft Excel, including data analysis, formulas, and large dataset management.
• Demonstrated analytical and problem-solving capabilities.
• Excellent attention to detail and organizational skills.
• Effective written and verbal communication skills.
• Ability to manage multiple priorities and meet deadlines.
• Strong customer service mindset and willingness to collaborate across departments.

Preferred

• Experience with utility billing analysis, utility data management, or sustainability reporting.
• Familiarity with commercial real estate operations.
• Exposure to data visualization and reporting tools such as Power BI or Tableau.
• Understanding of accounting, budgeting, or financial analysis concepts.
• Coursework or experience related to energy management, utility systems, engineering, sustainability, or data analytics.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.