Utility Analyst

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

Job summary

Phillips Edison & Company seeks a dedicated Utility Billing & Data Management professional to oversee billing data across a diverse real estate portfolio and validate invoices for accuracy. The role involves monitoring consumption trends, supporting rate analyses, and producing recurring reports and dashboards to optimize expenditures.

The candidate will collaborate with Accounting, Property Management, and utility providers, ensuring data integrity and driving process improvements across

Qualifications

• Bachelor's degree in a related analytical field.
• Proficiency with Microsoft Excel including 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.
• Strong customer service mindset and cross-department collaboration.

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, 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.
• 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.
• 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.
• Assist with measurement and verification 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.

Skills

Excel data analysis

Analytical skills

Attention to detail

Communication

Multi-tasking

Customer service

Collaboration

Data-driven decision making

Education

Bachelor's degree in Finance, Accounting, Engineering, Data Science, Business Analytics, Economics, Mathematics, Sustainability, or related analytical field

Tools

Power BI

Tableau

Job description

Key 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, 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.

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.