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 shift Schedule: Monday to Friday Hours: 8:30am to 5:00pm Setting: Hybrid (3 days in office) Responsibilities: Analyze, validate, and enter utility invoice data into tracking systems while ensuring billing accuracy and contract compliance Perform data cleansing, normalization, and quality checks across large datasets from multiple sources Support the 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 Qualifications: Bachelor's degree in Finance, Accounting, Economics, Data Analytics, Sustainability, or a related field 2+ years of experience in 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 Advanced proficiency in Excel, including pivot tables and formulas Experience with data analysis tools such as Smartsheet, Power BI, Tableau, or similar platforms High attention to detail with strong analytical and problem-solving skills Desired Skills: Experience supporting sustainability, energy management, or ESG reporting initiatives Familiarity with utility tariffs, rate structures, and regulatory concepts Experience with utility or energy management software Exposure to GHG accounting frameworks, including Scope 1, Scope 2, and utility-related Scope 3 emissions Ability to translate complex data into clear, executive-ready insights Strong data visualization and storytelling skills Show more Show less