Utilities Data Analyst - Energy

Be part of an amazing story

Macy’s is more than just a store. We’re a story. One that’s captured the hearts and minds of America for more than 160 years. A story about innovations and traditions…about inspiring stores and irresistible products…about the excitement of the Macy’s 4th of July Fireworks, and the wonder of the Thanksgiving Day Parade. We’ve been part of memorable moments and milestones for countless customers and colleagues. Those stories are part of what makes this such a special place to work.

Job Overview

As a Utilities Data Analyst, you’ll provide leadership at both strategic and operational levels in energy planning, invoice auditing, and process improvement. This position requires the regular use of independent judgment and discretion, particularly when evaluating complex data, interpreting ambiguous information, and determining corrective actions. Your work will primarily involve utility invoice analysis and auditing, locating and resolving errors, and identifying cost saving opportunities.

You will synthesize energy information across electricity, natural gas, fuel oil, mall utilities, water, and steam to support Finance and business partners. The ability to interpret data to formulate recommendations, troubleshoot issues, and communicate insights is essential. Familiarity with national climate patterns and their impact on energy usage, along with a basic understanding of building systems, will enhance your effectiveness in this analytical role. Adaptability, urgency, and collaboration are key.

What You Will Do

• Conduct utility bill analysis and energy data vetting. 
• Identify and resolve data errors and overbillings for electric, water, gas, steam, oil, etc., working directly with hundreds of utility vendors. 
• Provide granular, accurate, and cleaned energy data to Finance for budgeting and ROF processes. 
• Analyze trends, identify causes of overages, and uncover opportunities for savings. 
• Interpret complex datasets to formulate recommendations and troubleshoot root causes. 
• Apply independent discretion when determining next steps for billing disputes or unusual consumption patterns. 
• Incorporate national climate considerations when explaining trends, anomalies, or seasonal variances. 
• Leverage basic knowledge of building systems to contextualize consumption irregularities and support root cause analysis. 
• Assist with all utility and energy service provider issues. 
• Work collaboratively with Facilities Management, Corporate Accounting, and Stores Finance partners to maximize results. 
• Provide analytical support and insights to business partners as needed. 
• Create ad hoc reports and analyses. 
• Demonstrate regular, dependable attendance and punctuality. 
• Communicate professionally with business partners at all levels.
• Foster an environment of acceptance and respect that strengthens relationships, and ensures authentic connections with colleagues, customers, and communities. 
• In addition to the essential duties mentioned above, other duties may be assigned.

Skills You Will Need

Data Management: Understanding budgets, financial commitments, and cost saving initiatives; ability to identify process improvements. 

Analytical Judgment: Ability to exercise independent discretion when evaluating ambiguous or conflicting data. 

Problem Solving: Skilled at identifying root causes by integrating data, climate considerations, and building related factors. 

Advanced Excel: Proficient with pivot tables, VLOOKUP, INDEX MATCH, advanced formulas, and macros to automate and optimize workflows. 

Coordination: Strong collaborator across internal and external stakeholders; able to drive alignment and execution. 

Strategic Thinking: Ability to drive initiatives, enhance operations, and align analysis with organizational goals. 

Communication: Clear written and verbal communication; able to present insights to partners at all levels. 

Workflow Management: Skilled at prioritizing tasks, managing deadlines, and ensuring timely project completion. 

Collaboration: Effective in working cross functionally to support