Sustainability Data Analyst

US AMR-Jones Lang LaSalle Americas, Inc.; Boston (MA); Híbrido; USD 134 000 - 179 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

401(k)

Medical, Dental & Vision Care

Paid parental leave

Paid Time Off

Daily Pay

Resumo da oferta

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.

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

ESG familiarity

Sustainability

Data analytics

Data quality control

Project coordination

Communication skills

Time management

Formação académica

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

Ferramentas

Databricks

Excel

Power Query

Python

SQL

Descrição da oferta de emprego

Join JLL’s Corporate Sustainability team and support greenhouse gas (GHG) emissions quantification, audit readiness, and data modernization. This hybrid Boston role helps keep reporting cycles on track while transitioning 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 a week on-site)
Compensation: USD 134,200 - 179,450 per year
Schedule: Full-time
Experience: 1+ year
Education: Bachelor’s or Master’s degree

What You’ll Do

• 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
• Support the evolution of calculation methods from Excel/Power Query to Python and SQL within Databricks
• Build and maintain data pipelines in JLL’s enterprise data platform to enable automated calculation workflows
• 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 to support timely delivery
• Support audit compliance by organizing documentation and maintaining records
• Assist with ad hoc internal data requests and reporting requirements
• Collaborate on JLL client emissions data improvement initiatives, including Scope 3 Category 11, ahead of expanded audit scope
• Identify data quality issues and help drive resolution with internal stakeholders

What You Bring

• 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 (real estate or corporate emissions preferred)
• Strong proficiency in Excel with demonstrated ability to build and maintain complex Power Query calculation workbooks
• Professional experience with Python and SQL
• Demonstrated experience building and maintaining data pipelines within Databricks or a comparable enterprise data platform
• Proven ability to manage data quality control, validation, and workflow coordination across multiple data sources
• Strong communication and time management skills, with the ability to manage multiple concurrent workstreams in a fast‑paced environment

Nice to Have

• 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, especially client‑related emissions (Category 11)
• Knowledge of Workiva or similar ESG reporting platforms

Benefits

• 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
• Daily Pay for early access to earned wages

Authorization to Work

This position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship.