Hybrid GHG Data Analyst — Sustainability & Databricks

Jones Lang LaSalle Incorporated; Boston (MA); Hybrid; USD 134,000 - 179,000; Full time

Benefits offered by this job

401(k) plan with matching company

Comprehensive Medical, Dental & Vision

Paid parental leave at 100%

Paid Time Off and Company Holidays

Early access to earned wages through '

Early access to earned wages through a

Daily Pay option

Job summary

JLL's Sustainability Team in Boston seeks a Data Analyst to support greenhouse gas emissions quantification, data management, and audit compliance. This role will transition calculations from Excel/Power Query to Python/SQL in Databricks and build scalable data pipelines for automated workflows.

The ideal candidate has hands-on GHG experience, strong Excel skills, and proficiency in Python and SQL, plus excellent collaboration with stakeholders across functions.

Qualifications

• Bachelor's or Master's degree in environmental science, sustainability, data analytics, engineering, computer science, or related field.
• 1-3 years of professional experience in ESG, sustainability, or environmental data management.
• Hands-on experience performing greenhouse gas emissions calculations.
• Strong proficiency in Excel with Power Query to build complex calculation workbooks.
• Professional experience with Python and SQL.
• Experience building data pipelines within Databricks or similar platform.
• Data quality control, validation, and workflow coordination across data sources.
• Strong communication and time management in a fast-paced environment.

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.
• Conduct quality assurance checks on emissions calculations and datasets.
• Perform greenhouse gas emissions calculations across Scope 1, 2, and 3 categories.
• Research and apply GHG calculation methodologies as needed.
• Support the continued evolution of GHG calculation methodologies from Excel/Power Query to Python and SQL-based code in Databricks.
• Build and maintain data pipelines within the enterprise data platform to support automated calculation workflows.
• Translate calculation logic into Python and SQL, ensuring accuracy and consistency with existing methodologies.
• Test and validate migrated calculations against legacy Excel outputs.
• Track data collection progress and manage internal workflow coordination.
• Support audit compliance by organizing documentation and maintaining records.
• Assist with ad hoc internal data requests and reporting requirements.
• Manage workstream trackers and ensure timely delivery of operational tasks.
• Communicate and engage effectively with various internal stakeholders.
• Collaborate on client emissions data improvement initiatives (Scope 3 Category 11).
• Identify data quality issues and support resolution across stakeholders.

Skills

GHG quantification

Excel/Power Query

Python

SQL

Data pipelines

Communication

Collaboration

Education

Bachelor's or Master's degree

Tools

Databricks

Job description

JLL's Sustainability Team in Boston seeks a Data Analyst to support greenhouse gas emissions quantification, data management, and audit compliance. This role will transition calculations from Excel/Power Query to Python/SQL in Databricks and build scalable data pipelines for automated workflows.

The ideal candidate has hands-on GHG experience, strong Excel skills, and proficiency in Python and SQL, plus excellent collaboration with stakeholders across functions.