Sustainability Data Analytics Engineer in City of Westminster

Great Yellow makes landscape regeneration investable and scalable. We envision a future where regenerative land‑use is the norm, delivering measurable environmental recovery, resilient food systems, and long‑term economic value. Great Yellow exists to create a clear, practical pathway to making this future a reality. Today, the way we use and manage land is pushing natural and economic systems to a breaking point. Fragile food supply chains, degraded ecosystems, rising climate risk and failing infrastructure are driving real and growing costs for communities and the economy. By rethinking how we work with land and value nature, we can create landscapes that provide clean water, abundant nature, stable production, and long‑term security. Great Yellow works to drive this transformation, moving beyond extractive models to unlock economic and ecological regeneration.

We work with:

• Land Managers of ambitious nature recovery projects to plan and deliver ambitious, landscape‑scale transformation
• Project Investors seeking opportunities to generate robust, risk‑adjusted returns alongside verified environmental impact
• Buyers of ecosystem services seeking high‑integrity, high‑impact natural capital solutions to strengthen resilience and reduce nature‑related risks
• And many other partners and specialists in the restoration journey

Role Overview

Sustainability Data Analytics Engineers are a new kind of role at Great Yellow: part data engineer, part climate analyst, part investment modeller. You’ll sit at the intersection of our nature restoration projects and our investor clients, doing the hands‑on, technical work of turning large, complex environmental datasets into the models that drive real investment decisions. This is a deliberately senior position. We’re building a data capability that pulls information from across our projects — fire risk, water quality, spatial ecology, biodiversity metrics, ESG indicators — aggregates it in our own systems, and synthesises it into a clear picture that Great Yellow and our clients can act on. You’ll shape how that data is accessed, stored, structured, and ultimately used.

Concretely, you’ll work with large‑scale environmental and geospatial datasets, overlaying and cross‑referencing them to surface insight — mapping ecological data against fire risk layers to identify what reduces exposure, combining spatial and financial data to support an investor’s due diligence, building the analytical models that turn raw data into confident capital allocation. You’ll look at what data works and what doesn’t, and paint the picture that helps our clients invest. Working closely alongside our Data Analyst, you’ll collaborate with product and commercial teams and help shape the data products that will drive Great Yellow’s next phase of growth.

About you

• You write SQL fluently — complex queries, optimisation, working across large and messy datasets. This is a daily tool, not an occasional one.
• You’re able to write SQL, analyse data sets, and use them in models.
• Python: you’re comfortable using it for data manipulation, pipeline development, and analysis (Pandas, NumPy, or similar).
• You build things, not just analyse them.
• Experience with data analytics platforms like Power BI, Tableau, or equivalent — building dashboards and reports, not just viewing them.
• Working knowledge of cloud data platforms (AWS, Google Cloud — BigQuery, Redshift, S3, or similar) for storage, processing, and analytics at scale.
• Fluent with spatial and geospatial data: coordinate systems, spatial joins, map‑based analysis.
• You know your way around a spatial dataset.
• You’ve done heavy data analytics: aggregating, transforming, and deriving insight from high‑volume, multi‑source datasets. This isn’t a reporting role.
• You can take data from multiple domains — ecology, finance, climate risk — and bring them together into coherent, unified analytical outputs.
• This person will shape the data.
• You know how to shape raw data into well‑structured models and maintain data dictionaries that keep everything consistent and traceable.
• You understand general ESG data frameworks and can adapt to ecology, biodiversity, and climate‑specific datasets.
• You don’t need to be an ecologist, but you need to be comfortable in that world.
• You could be a climate scientist, an environmental data specialist, or a data engineer who’s spent time in sustainability — what matters is that you can understand the data and know what to do with it.
• You can hold your own in a room with an ecologist and a finance analyst alike.
• This is a senior role. You’re comfortable operating independently, making data architecture decisions, and communicating findings to both technical and commercial stakeholders.
• You have a product mindset — you see beyond analysis and think about how data capabilities can be productised and drive revenue.
• You’re able to influence future product direction.
• You’re energised by ambiguity. We’re building something new, and the shape of this role will evolve as we grow.

Nice to Have

• GIS experience: proficiency with GIS tools (QGIS, ArcGIS, or equivalent) for advanced spatial analysis and mapping.
• True ecology data experience: direct work with ecological survey data, habitat condition assessments, species monitoring, or biodiversity net gain (BNG) metrics.
• Academic or professional background in climate science or environmental modelling.
• Experience with Great Yellow’s internal tools and platforms (details available on request).
• Ability to productise — a revenue mindset that can help turn Great Yellow’s data capabilities into scalable products.

Benefits

Our culture is built on three principles: All for the Hive (shared leadership and collaboration), Shameless Ambition (raise the bar, speak directly), and Design the Future (think big, learn by doing, own it). Be part of an innovative scale‑up that’s breaking new ground in finance and nature restoration — making landscape regeneration investable and scalable. Engage in meaningful work with the potential to make a lasting impact on the planet. Work alongside a passionate and diverse team in an environment that values flexibility, collaboration, autonomy, and growth. We’re big believers in flexibility — work where you do your best thinking — but we also value getting together in our office to share ideas (and tea/coffee).