Sustainability Data Analyst

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 empowers you to shape a brighter way.

Our 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 peopleand empowering them tothrive, 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.

Sustainability Data Analyst

Location: Boston-based (hybrid, 2 days a week on-site)

Team: Sustainability Team

Reports to: Senior Director, Sustainability Team

What 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 Processing

• 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

Methodology Transition to Code-Based Environment

• 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 JLL's 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
• Capability to see where additional process or other data improvements will improve our calculation or data management approach

Operations & Documentation

• 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

Data Quality & Improvement

• Collaborate on JLL client emissions data improvement initiatives (Scope 3 Category 11) in preparation for expanded audit scope
• Identify data quality issues and support resolution efforts across internal stakeholders

Required Qualifications

• Education: Bachelor's or Master's degree in environmental science, sustainability, data analytics, engineering, computer science, or related field
• Experience: 1-3 years of professional experience in ESG, sustainability, or environmental data management
• GHG 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 workbooks
• Coding Skills: Professional experience with Python and SQL
• Enterprise Data Pipelines: Demonstrated experience building and maintaining data pipelines within Databricks or a comparable enterprise data platform
• Data Management: Proven ability to handle data quality control, validation, and workflow coordination across multiple data sources
• Collaboration & Communication: Strong communication and time management skills with ability to manage multiple concurrent workstreams in a fast-paced environment

Preferred Qualifications

• Direct experience with Databricks
• Experience transitioning analytical workflows from Excel to code-based environments
• Experience with audit processes and documentation requirements
• Exposure to Scope 3 emissions quantification and data improvement approaches, particularly client-related emissions (Category 11)
• Knowledge of Workiva or similar ESG reporting platforms

What Success Looks Like

First 90 Days

• Assist in data processing and preparation for emissions quantification workflows
• Replicate, maintain, and update Excel-based calculation workbooks independently
• Successfully execute calculations for straightforward emissions categories during the first quantification cycle
• Demonstrate effective coordination and administrative support across data workflows

6-12 Months

• Take ownership of multiple emissions categories and calculation processes
• Contribute meaningfully to the calculation transition to Databricks
• Support client emissions data improvement initiatives
• Execute reliably during high-volume reporting periods

Who Thrives in This Role

We're looking for someone who:

• Executes reliably during high-volume reporting periods and can prioritize effectively across multiple workstreams
• Communicates proactively about challenges, progress, and ideas with the team
• Works effectively in a distributed team environment and is comfortable collaborating remotely across different locations and time zones
• Takes ownership of operational tasks and delivers high-quality work with minimal supervision once trained
• Works collaboratively in a transparent, team-oriented environment

Why Join JLL's Sustainability Team?

• Impactful work: Contribute to JLL's corporate sustainability goals and expanding ESG regulatory compliance
• Technical growth: Hands-on opportunity to build expertise in Databricks and modern data engineering practices
• Exciting challenge: Play a key role in improving client emissions data quality-a high-priority initiative heading into expanded audit scope
• Collaborative culture: Work with a lean, expert team with strong technical leadership

This 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 year

Location: On-site -Boston, MA

Personalized benefits that support personal well-being and growth:

• 401(k) plan with matching company contributions
• Comprehensive Medical, Dental & Vision Care
• Paid parental leave at 100% of salary
• Paid Time Off and Company Holidays
• Early access to earned wages through Daily Pay

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:

Jones Lang LaSalle ("JLL"), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL's recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.

For more information about how JLL processes your personal data, please view our Candidate Privacy Statement.

For additional details please see our career site pages for each country.

For candidates in the United States, please see a full copy of our Equal Employment Opportunity policy here.

Jones Lang LaSalle ("JLL") is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process - including the online application and/or overall selection process - you may email us at [e-mail]. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us page > I want to work for JLL.

Pursuant to the Arizona Civil Rights Act, criminal convictions are not an absolute bar to employment.

Pursuant to Illinois Law, applicants are not obligated to disclose sealed or expunged records of conviction or arrest.

Pursuant to Columbia, SC ordinance, this position is subject to a background check for any convictions directly related to its duties and responsibilities. Only job-related convictions will be considered and will not automatically disqualify the candidate.

California Residents only

If you are a California resident as defined in the California Consumer Privacy Act (CCPA) please view our Supplemental Privacy Statement which describes your rights and disclosures about your personal information.If you are viewing this on a mobile device you may want to view the CCPA version on a larger device.

Pursuant to the Los Angeles Fair Chance Initiative for Hiring Ordinance, JLL will consider for employment all qualified Applicants, including those with Criminal Histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Accepting applications on an ongoing basis until candidate identified.