Data Analyst, Customer Success

As a Data Analyst at Cambio, you will:

• Perform comprehensive data quality assurance and validation on large-scale utility and building performance datasets across multi-asset portfolios
• Write and optimize SQL queries to extract, join, validate, and analyze data from internal production databases
• Use Python to clean, normalize, validate, and analyze time-series utility data and identify anomalies, gaps, and inconsistencies
• Transform raw, unstructured data from utilities, building systems, and third-party providers into standardized, analytics-ready datasets

You'll ensure the integrity of emissions data that powers AI-driven retrofit recommendations and portfolio-level decarbonization strategies, enabling identification of 15%+ energy savings through Cambio's platform and reducing portfolio data gaps by 25% or more.

Required qualifications:

• 2+ years of experience in data analytics, accounting, finance, or related quantitative field
• Advanced SQL skills including complex queries with joins, CTEs, window functions, aggregations, and data validation logic
• Python proficiency for data analysis and transformation (e.g., pandas) with ability to write validation scripts
• Advanced Excel skills for data manipulation, validation, complex formulas, and building analytical models

Compensation consists of cash, equity and benefits. Base pay for NY/SF based candidates is $100,000-105,000 annually. The organization is a mission-oriented climate startup with partners and investors including Y Combinator, Google, the U.S. Department of Energy, Stanford University and Fifth Wall.

Cambio is a software platform for world-class real estate decarbonization that helps commercial real estate owners and tenants bring their real estate portfolios to net-zero using a powerful suite of software tools and AI-based recommendations. Their mission is to take the real estate industry into the climate action era.