Data Analyst, Energy Management

At Duke University, data drives decisions that power a world-class institution. As a Data Analyst, Energy Management, you will help ensure the accuracy, integrity, and analysis of utility and energy data that supports Duke University and Duke Health. Working within the Building Energy Management Department of Duke Facilities Management, you will transform complex utility and consumption data into meaningful insights that support operational excellence, cost management, sustainability initiatives, and strategic planning.

This role is ideal for a detail-oriented analyst who enjoys working with large datasets, identifying trends, solving data challenges, and partnering with stakeholders to improve reporting and business processes.

• Associate degree in Computer Science, Accounting, Engineering, or a related field.

• Minimum of three years of experience supporting a data-driven organization or an equivalent combination of relevant education and experience.
• Understanding of data flows from source systems to databases.
• Advanced proficiency in Microsoft Excel.

• Experience with SQL, Power BI, and/or other data visualization platforms.
• SAP experience.
• Knowledge of accounting principles and related business processes.
• Experience developing dashboards, reports, analytics, and forecasting models.

• Strong analytical and data processing skills.
• Ability to identify discrepancies, investigate root causes, and recommend solutions.
• Excellent written and verbal communication skills.
• High degree of accountability and attention to detail.
• Ability to manage multiple priorities and deadlines in a fast-paced environment.

• As a Data Analyst, you'll leverage data to support utility operations, budget planning, sustainability efforts, and customer billing across Duke's campuses.
• Analyze & Manage Critical Utility Data
• Collect, manage, validate, and analyze utility consumption and financial data to support accurate utility accounting and billing.
• Ensure data quality and integrity through ongoing monitoring, validation, and troubleshooting efforts.
• Identify data discrepancies and implement corrective actions to improve processes and reporting accuracy.
• Support Utility Billing & Financial Operations
• Utilize the EnergyCAP platform to process utility usage data and generate monthly utility bills.
• Manage billing activities for electricity, emergency power, steam, chilled water, hot water, domestic water, and storm water services.
• Review and record utility invoices from external providers to ensure accurate consumption, demand, and financial reporting.
• Develop Reporting & Analytics
• Create routine and ad hoc reports, dashboards, and analytical measures for Facilities Management and campus stakeholders.
• Analyze historical energy consumption trends, weather data, building occupancy, and construction activities to support forecasting and operational planning.
• Develop greenhouse gas emissions reports in partnership with Sustainable Duke.
• Enhance Data Quality & Operational Efficiency
• Monitor utility meters and investigate inaccurate or anomalous data.
• Coordinate with Facilities Management teams to resolve meter and data collection issues.
• Support utility meter modernization and migration initiatives across campus.

The Building Energy Management Department plays a vital role in supporting Duke's operational and sustainability objectives. Through data analytics, utility management, and strategic reporting, the team helps optimize resource usage, manage costs, and advance Duke's commitment to responsible energy stewardship.

At Duke, you'll join a collaborative community where innovation, service, and continuous improvement are valued. Your work will directly influence decisions that support one of the nation's leading universities and academic health systems.

Anticipated Pay Range: Duke University provide