Data Analyst

A global commercial real estate services firm is seeking a Data Analyst in Chicago, IL. This role supports utility and sustainability data analysis, reporting, and accuracy across large, complex datasets.About the Opportunity:Shift: Day shiftSchedule: Monday to FridayHours: 8:30am to 5:00pmSetting: Hybrid (3 days in office)Responsibilities:Analyze, validate, and enter utility invoice data into tracking systems while ensuring billing accuracy and contract compliancePerform data cleansing, normalization, and quality checks across large datasets from multiple sourcesSupport the creation of dashboards, reports, and visualizations for finance, real estate, sustainability, and leadership stakeholdersAssist with sustainability data preparation related to energy usage, emissions tracking, and reportingMaintain data integrity and document methodologies, assumptions, and controlsCollaborate with internal stakeholders and external vendors or utility providers to resolve data issues and support reporting needsQualifications:Bachelor's degree in Finance, Accounting, Economics, Data Analytics, Sustainability, or a related field2+ years of experience in a data analyst, financial analyst, or similar roleExperience working with utility invoices and utility dataStrong financial acumen, including cost analysis, variance analysis, and reconciliationAdvanced proficiency in Excel, including pivot tables and formulasExperience with data analysis tools such as Smartsheet, Power BI, Tableau, or similar platformsHigh attention to detail with strong analytical and problem-solving skillsDesired Skills:Experience supporting sustainability, energy management, or ESG reporting initiativesFamiliarity with utility tariffs, rate structures, and regulatory conceptsExperience with utility or energy management softwareExposure to GHG accounting frameworks, including Scope 1, Scope 2, and utility-related Scope 3 emissionsAbility to translate complex data into clear, executive-ready insightsStrong data visualization and storytelling skills