Utility Billing & Data Analytics Specialist

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

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