Data Analyst ensuring high-integrity data for climate action at Cambio. Collaborating with engineering and product teams to optimize data processes and reporting.
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.
Requirements
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.
Data-obsessed: You are meticulous and thrive when surrounded by numbers.
Analytical problem-solving: 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.
Experience working with carbon or building data is a bonus, but not required.
Sales Data Analytics & Visualization Developer at Pacific Life supporting sales and marketing through advanced analytics and visualization solutions. Collaborating with internal technology groups for deeper insights and efficiency.
Senior Treasury Quantitative Analyst developing and validating quantitative models for risk management at United Community Bank. Collaborating with teams to enhance decision - making processes.
Data Analyst Intern supporting various projects in the Transportation/Supply Chain organization at CHS. Collaborating with business and IT professionals in a hybrid work environment.
Data Analyst developing innovative BI solutions at Keyrus in Bordeaux. Engaging in exciting projects and collaborating with diverse teams to transform data into actionable insights.
Product Data Analyst monitoring and analyzing product performance at Veepee. Collaborating with product teams and marketing to improve user experience and conversion.
Senior Analytics Manager leading data analytics initiatives to inform strategic decisions at KeyBank. Enhancing client and employee experiences through quantitative and qualitative research.
Data Analyst supporting global energy transition by developing and managing dashboards for diverse data insights. Collaborating across teams to scope and execute data strategies for Aurora's software solutions.
Data Analyst supporting behavioral health initiatives by analyzing data for various programs in Detroit. Involves data collection, reporting, and collaboration with community partners.
Data Analytics and Tracking Specialist working in a cutting - edge AI marketing agency. Collaborating with stakeholders to implement data - driven solutions and optimize marketing performance.
Analyst developing data solutions for Minsait in the Cards/Client Experience Department. Focus on optimizing workflows and increasing efficiency with strong analytical skills.