DescriptionThe Strategic Planning organization at Con Edison is seeking a Data Analyst (2H) to serve as the departments lead for planning and scenario forecasting data products. This role is responsible for end-to-end ownership of critical datasets, dashboards, reporting tools, and for partnering with ETS organization to integrate departmental data with enterprise-wide platforms. In this role, you will help manage data used to analyze electrification trends, emerging technologies, and policy impacts that shape long term investment strategies aligned with CLCPA goals and the Companys clean energy transition. You will develop and maintain datasets, dashboards, and analytical tools that provide critical insights to senior leadership and cross functional partners.
The Data Analyst will operate with a high degree of autonomy, defining data requirements, establishing data quality standards, and delivering analytics products that are relied upon by senior leadership and cross functional teams. This role emphasizes data governance, integration, and scalability, ensuring that planning analytics are accurate, well documented, and aligned with enterprise architecture and reporting standards.
The ideal candidate brings strong analytical skills, experience working with large datasets, and proficiency in tools such as SQL, Python, or Power BI. You must be able to translate complex findings into clear, actionable insights. Familiarity with utility planning, energy policy, or electrification modeling is preferred but not required.
ResponsibilitiesCore Responsibilities
- Serve as steward of Strategic Planning data assets, including datasets, metrics, dashboards, and recurring executive reporting. Support scenario modeling, decarbonization pathways, and long-term investment evaluations consistent with CLCPA goals.
- Lead planning analytics initiatives from concept through production, including prioritization, requirements, delivery, and lifecycle management.
- Develop advanced dashboards and analytical tools (primarily Power BI) that support planning, forecasting, and performance assessment.
- Develop, maintain, and enhance datasets, data pipelines, and analytical tools that support long range electric system planning.
- Produce clear dashboards, reports, and visualizations that translate complex data into actionable insights for senior leadership.
- Conduct rigorous data validation and quality assurance to ensure accuracy, consistency, and reliability of analytical outputs.
- Write, optimize, and maintain complex SQL queries and reusable database objects supporting analytics and automation.
- Present analytical findings to cross functional partners and leadership, clearly communicating implications for strategic decision making.
- Produc