Data Analyst joining Oscar's Clinical Data Analytics team in Tempe, Arizona. Analyzing performance metrics and insights to support business goals with a hybrid work model.
About the role
- 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.
Benefits
- Cash, equity and benefits
- 3-4 days in office
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Analyst supporting business units with data - driven insights and performance metrics at Oscar Health. Collaborating across departments and delivering analysis to improve healthcare efficiencies.
Data Analyst intern at Ledger, supporting AI initiatives and analytics engineering. Collaborating with teams to transform data into actionable insights for business growth.
Data Analyst supporting supply chain risk management for federal agencies. Focusing on data analysis and mitigation strategies in a collaborative team environment.
Data Analyst supporting threat analysis operations within supply chain risk management program. Focus on identifying vulnerabilities and assessing geopolitical exposure.
Senior Quantitative Analyst validating the Standard Initial Margin Model in investment banking. Involves quantitative validation and risk analysis in a regulated environment.
HR Coordinator & People Analytics Specialist supporting HR operations and managing people analytics reporting. Ensuring data accuracy and handling sensitive employee information with confidentiality.
Data Analyst developing dashboards and reports using Power BI and SQL for strategic insights. Collaborating with business areas to map analytical needs and ensure data quality.
Business Data Analyst II supporting SAS/SQL - based CCAR Y14 reporting solutions at Truist. Ensuring accuracy and regulatory alignment of CCAR Y14 data through reporting enhancements and analysis.
ERP Data Analytics Governance Manager leading data governance and compliance initiatives within SAP S/4HANA transformation project. Collaborating across teams to ensure data integrity and regulatory adherence.