Sustainability Data Analyst

Sustainability Data AnalystOur people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you've got deep experience in commercial real estate, skilled trades or technology, or you're looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.Location: Boston-based (hybrid, 2 days a week on-site) Team: Sustainability Team Reports to: Senior Director, Sustainability TeamWhat this job involves - JLL's Corporate Sustainability team is seeking a Data Analyst to support greenhouse gas emissions quantification, data management, and audit compliance operations. This role will play a critical execution-focused function, maintaining existing calculations while supporting the team's transition of GHG calculation methodologies from Excel/Power Query to a code-based environment in Databricks.The ideal candidate combines hands-on GHG quantification experience with strong Excel/Power Query skills, Python and SQL proficiency, and experience building data pipelines within an enterprise system. This is an opportunity to contribute to JLL's expanding ESG reporting requirements and help build scalable, automated data systems for corporate sustainability. This candidate also needs strong communication and collaboration skills with demonstrated proficiency.What is your day-to-day?Calculation Maintenance & Data ProcessingMaintain and update Excel-based calculation workbooks using Power Query across reporting cyclesProcess, validate, and move data through quantification workflows from collection to final calculationsConduct quality assurance checks on emissions calculations and datasetsPerform greenhouse gas emissions calculations across Scope 1, 2, and 3 categoriesResearch and apply GHG calculation methodologies as neededMethodology Transition to Code-Based EnvironmentSupport the continued evolution of GHG calculation methodologies from Excel/Power Query to Python and SQL-based code in DatabricksBuild and maintain data pipelines within JLL's enterprise data platform to support automated calculation workflowsTranslate calculation logic into Python and SQL, ensuring accuracy and consistency with existing methodologiesTest and validate migrated calculations against legacy Excel outputsCapability to see where additional process or other data improvements will improve our calculation or data management approachOperations & DocumentationTrack data collection progress and manage internal workflow coordinationSupport audit compliance by organizing documentation and maintaining recordsAssist with ad hoc internal data requests and reporting requirementsManage workstream trackers and ensure timely delivery of operational tasksCommunicate and engage effectively with various internal stakeholdersData Quality & ImprovementCollaborate on JLL client emissions data improvement initiatives (Scope 3 Category 11) in preparation for expanded audit scopeIdentify data quality issues and support resolution efforts across internal stakeholdersRequired QualificationsEducation: Bachelor's or Master's degree in environmental science, sustainability, data analytics, engineering, computer science, or related fieldExperience: 1-3 years of professional experience in ESG, sustainability, or environmental data managementGHG Quantification: Hands-on experience performing greenhouse gas emissions calculations (industry-specific experience in real estate or corporate emissions preferred)Excel & Power Query: Strong proficiency in Excel with demonstrated ability to build and maintain complex Power Query-based calculation workbooksCoding Skills: Professional experience with Python and SQLEnterprise Data Pipelines: Demonstrated experience building and maintaining data pipelines within Databricks or a comparable enterprise data platformData Management: Proven ability to handle data quality control, validation, and workflow coordination across multiple data sourcesCollaboration & Communication: Strong communication and time management skills with ability to manage multiple concurrent workstreams in a fast-paced environmentPreferred QualificationsDirect experience with DatabricksExperience transitioning analytical workflows from Excel to code-based environmentsExperience with audit processes and documentation requirementsExposure to Scope 3 emissions quantification and data improvement approaches, particularly client-related emissions (Category 11)Knowledge of Workiva or similar ESG reporting platformsWhat Success Looks LikeFirst 90 DaysAssist in data processing and preparation for emissions quantification workflowsReplicate, maintain, and update Excel-based calculation workbooks independentlySuccessfully execute calculations for straightforward emissions categories during the first quantification cycleDemonstrate effective coordination and administrative support across data workflows6-12 MonthsTake ownership of multiple emissions categories and calculation processesContribute meaningfully to the calculation transition to DatabricksSupport client emissions data improvement initiativesExecute reliably during high-volume reporting periodsWho Thrives in This RoleWe're looking for someone who:Executes reliably during high-volume reporting periods and can prioritize effectively across multiple workstreamsCommunicates proactively about challenges, progress, and ideas with the teamWorks effectively in a distributed team environment and is comfortable collaborating remotely across different locations and time zonesTakes ownership of operational tasks and delivers high-quality work with minimal supervision once trainedWorks collaboratively in a transparent, team-oriented environmentWhy Join JLL's Sustainability Team?Impactful work: Contribute to JLL's corporate sustainability goals and expanding ESG regulatory complianceTechnical growth: Hands-on opportunity to build expertise in Databricks and modern data engineering practicesExciting challenge: Play a key role in improving client emissions data quality—a high-priority initiative heading into expanded audit scopeCollaborative culture: Work with a lean, expert team with strong technical leadershipThis position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship.Expected compensation for this position:134,200.00 – 179,450.00 USD per yearFinal compensation packages are determined by various considerations including but not limited to candidate qualifications, location, market conditions, and internal considerations.Location:On-site –Boston, MAIf this job description resonates with you, we encourage you to apply, even if you don't meet all the requirements. We're interested in getting to know you and what you bring to the table!Personalized benefits that support personal well-being and growth:JLL recognizes the impact that the workplace can have on your wellness, so we offer a supportive culture and comprehensive benefits package that prioritizes mental, physical and emotional health. Some of these benefits include:401(k) plan with matching company contributionsComprehensive Medical, Dental & Vision CarePaid parental leave at 100% of salaryPaid Time Off and Company HolidaysEarly access to earned wages through Daily Pay