Hybrid Sustainability Data Analyst: GHG, Python/SQL

US AMR-Jones Lang LaSalle Americas, Inc.; Boston (MA); Hybrid; USD 134,000 - 179,000; Full time

Benefits offered by this job

401(k)

Medical, Dental & Vision Care

Paid parental leave

Paid Time Off

Daily Pay

Job summary

JLL’s Corporate Sustainability team seeks a specialist to quantify GHG emissions, support audit readiness, and modernize data pipelines. This hybrid Boston role shifts calculation work from Excel and Power Query toward Python and SQL in Databricks, building reliable pipelines to automate workflows and improve emissions data quality. Location: Boston, MA, hybrid (2 days on-site).

Compensation: USD 134,200 - 179,450 per year. Schedule: Full-time. Experience: 1+ year.

Qualifications

• Bachelor’s or Master’s degree required in a relevant field such as environmental science, sustainability, data analytics, engineering, or computer science.
• 1+ year of professional experience in ESG, sustainability, or environmental data management.
• Hands-on experience performing greenhouse gas emissions calculations (real estate or corporate emissions preferred).
• Strong proficiency in Excel with ability to build and maintain complex Power Query calculation workbooks.
• Professional experience with Python and SQL; experience building data pipelines in Databricks or similar platform.

Responsibilities

• Maintain and update Excel-based calculation workbooks using Power Query across reporting cycles.
• Process, validate, and move data through quantification workflows from collection to final calculations.
• Run quality assurance checks on emissions calculations and datasets.
• Perform GHG emissions calculations across Scope 1, 2, and 3 categories.
• Research and apply GHG calculation methodologies as needed.
• Translate calculation logic into Python and SQL, ensuring consistency with existing methodologies.
• Test and validate migrated calculations against legacy Excel outputs.
• Track data collection progress and coordinate internal workflows; manage workstream trackers.

Skills

ESG familiarity

Sustainability

Data analytics

Data quality control

Project coordination

Communication skills

Time management

Education

Bachelor’s or Master’s degree in environmental science, sustainability, data analytics, engineering, computer science, or related field

Tools

Databricks

Excel

Power Query

Python

SQL

Job description

JLL’s Corporate Sustainability team seeks a specialist to quantify GHG emissions, support audit readiness, and modernize data pipelines. This hybrid Boston role shifts calculation work from Excel and Power Query toward Python and SQL in Databricks, building reliable pipelines to automate workflows and improve emissions data quality. Location: Boston, MA, hybrid (2 days on-site).

Compensation: USD 134,200 - 179,450 per year. Schedule: Full-time. Experience: 1+ year.