Apply on Employer Site

Cambio · 1 day ago

Data Analyst, Customer Success

San Francisco, CA

Full-time

Onsite

Entry, Mid Level

$100K/yr - $105K/yr

2+ years exp

Cambio is a software platform focused on real estate decarbonization, aiming to help commercial real estate owners and tenants achieve net-zero emissions. The Data Analyst will be responsible for data validation, transformation, and quality assurance for large-scale datasets, working closely with product and engineering teams to ensure high-integrity data for analytics and reporting.

GreenTechPollution ControlReal EstateSoftware

No H1B

Responsibilities

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

Implement and execute data anomaly detection workflows, leveraging both internal tools and custom SQL/Python logic

Partner closely with product and engineering teams to improve ETL processes and harden data pipelines

Build and maintain complex Excel models and spreadsheets for data manipulation, analysis, and validation workflows

Create and populate data templates for sustainability reporting frameworks including GRESB, TCFD, and CDP

Qualification

SQLPythonData validationExcelData analysisAnalytical problem-solvingCarbon dataCollaborative team player

Required

Strong quantitative background: 2+ years of experience in data analytics, accounting, finance, or related quantitative field

Advanced SQL skills: Comfortable writing complex queries involving joins, CTEs, window functions, aggregations, and data validation logic

Python proficiency: Experience using Python for data analysis and transformation (e.g., pandas). Ability to write scripts to validate datasets and automate repeatable checks

Advanced Excel skills required: You are highly proficient in Excel with experience in data manipulation, validation, complex formulas, and building analytical models. You are willing to roll up your sleeves to work with large, unstructured, and inconsistent datasets

Data-obsessed: You are meticulous and thrive when surrounded by numbers. You have a sharp eye for detail and can spot inconsistencies and anomalies in complex datasets

Analytical problem-solving: To you, cleaning and validating messy data is an exciting puzzle to solve. You have the ability to think creatively when addressing data quality challenges

Collaborative team player: You work effectively with engineering and product teams to troubleshoot technical issues and improve data workflows

Must be based out of our New York or San Francisco hub

Have US work authorization

We are in office 3-4 days per week