Climate Resilience Data Analyst / Senior Data Analyst
Smart Surfaces Coalition · New York, NY / Washington, DC (Hybrid)
Overview
The Climate Resilience Data Analyst / Senior Data Analyst is a core member of SSC’s Data Team, working under the direct supervision of the Data Project Manager. This role is responsible for maintaining, developing, and refining SSC’s Excel-based Benefit-Cost Analysis (BCA) model, which underpins SSC’s Benefit-Cost Analysis Tool (BCAT), project implementation platform, and organization-wide impact quantification.
The analyst will process, analyze, and visualize data across a wide range of economic and environmental domains, including urban heat exposure, stormwater management, health and air quality, urban forestry, building energy efficiency, renewable energy, construction materials, and carbon sequestration.
Success in this role requires both technical rigor and strong soft skills: the ability to translate complex analysis into clear insights for technical and non-technical audiences, manage multiple priorities under tight deadlines, thrive in a fast-paced start-up environment, and act as a self-starter who takes initiative, works independently with creativity and sound judgment, and collaborates closely with senior leadership.
Job Responsibilities
Under the direct supervision of the Data Project Manager, the Data Analyst will:
- Maintain and refine SSC’s Excel-based Benefit-Cost Analysis (BCA) model to support city partnerships and scaling to new geographies, both domestically and internationally, including analyses across geographies, time periods, and custom scenarios.
- Extract, process, and analyze data from third-party platforms, building systems and frameworks to ensure smooth data integration.
- Develop clear, well-documented analyses and visualizations for team members, partners, and stakeholders.
- Collaborate with senior staff on reports, memos, and presentations for internal and external audiences.
- Support development of SSC’s digital tools (Benefit-Cost Analysis Tool, Decision Support Tool) by working closely with the Data Project Manager to define data requirements, coordinate with external data partners, and ensure smooth integration of model inputs/outputs.
- Contribute to UI/UX discussions to ensure tools are intuitive, transparent, and technically sound.
- Research and design new quantification pathways for climate, health, energy, water, and economic impacts in both U.S. and international contexts.
- Incorporate ongoing research on Smart Surfaces costs, performance, and availability into the BCA model.
- Benchmark SSC’s modeling against peer-reviewed literature and industry standards to ensure methodological rigor.
Required Qualifications
- Bachelor’s degree in economics, environmental/climate science, engineering, geography, public health, data science, or related field.
- 2+ years of relevant paid work experience (or Master’s degree + 1 year) developing and managing complex databases, conducting quantitative research, statistical/computational analysis, and data visualization.
- Advanced proficiency in Microsoft Excel, including complex formulas, arrays, and macros; ability to build, refine, and troubleshoot large-scale models.
- Experience analyzing, cleaning, and visualizing data in Python or R.
- Subject matter expertise in one or more relevant areas such as energy efficiency, renewable energy systems, climate modeling, hydrology, heat mapping, or epidemiological modeling.
- Excellent written and verbal communication skills; able to present complex findings clearly to technical and non-technical audiences.
- Strong interpersonal skills with the ability to collaborate across teams and work effectively under the direct supervision of the Data Project Manager and with senior leadership.
- Strong time management skills and ability to thrive in a hybrid work environment.
- Demonstrated ownership and accountability for deliverables in a fast-paced, collaborative setting.
- Demonstrated creativity, independent judgment, and problem-solving ability in research and analysis.
- Demonstrated ability to scope ambiguous projects, manage competing priorities, and deliver high-quality results under tight deadlines.
- Strong attention to detail, particularly with economic concepts such as unit conversions, discount rates, and nominal vs. real dollars.
- Experience reviewing, synthesizing, and applying findings from peer-reviewed literature.
Preferred Qualifications
- Experience using GIS tools (QGIS, ArcGIS, StoryMaps) for spatial analysis of urban land cover and surface characteristics.
- Experience designing and managing structured databases (including SQL) to support large analytical models.
- Familiarity with environmental tools and models such as i-Tree, PVWatts, RSMeans, SWMM, BenMAP, and EIA dashboards.
Please email the following materials to Shallon Hartke ([email protected]):
- CV/Resume including a list and contacts for 3-4 references
- Cover letter describing relevant experience and interest in SSC’s mission
- 2–3 work samples that highlight the following:
- Excel: An analytic workbook demonstrating advanced modeling or data processing skills
- Technical writing with data visualization: A report, memo, or similar document that clearly explains analysis and includes charts/figures
- Python or R scripting (optional but strongly encouraged): A script or notebook that demonstrates coding and data analysis ability
Immediate availability to begin training is preferred. Applications will be reviewed on a rolling basis.