Data Analyst – Utility & Sustainability Focus

About the role

Our global commercial real estate services firm is looking for a Data Analyst in Chicago to support utility and sustainability data analysis, reporting, and accuracy across large, complex datasets. The position works on a day shift, Monday‑Friday, hybrid schedule.

Key responsibilities

• Analyze, validate, and enter utility invoice data into tracking systems ensuring billing accuracy and contract compliance.
• Perform data cleansing, normalization, and quality checks across large datasets from multiple sources.
• Support creation of dashboards, reports, and visualizations for finance, real estate, sustainability, and leadership stakeholders.
• Assist with sustainability data preparation related to energy usage, emissions tracking, and reporting.
• Maintain data integrity and document methodologies, assumptions, and controls.
• Collaborate with internal stakeholders and external vendors or utility providers to resolve data issues and support reporting needs.

Required profile

• Bachelor’s degree in Finance, Accounting, Economics, Data Analytics, Sustainability or related field.
• Minimum 2 years of experience as a data analyst, financial analyst or similar role.
• Experience working with utility invoices and utility data.
• Strong financial acumen including cost analysis, variance analysis and reconciliation.
• High attention to detail and strong analytical/problem‑solving abilities.

Required skills

• Advanced proficiency in Microsoft Excel (pivot tables, complex formulas).
• Experience with data analysis and visualization tools such as Smartsheet, Power BI or Tableau.
• Ability to perform data cleansing, normalization and quality checks.