Data Analyst - Strategic Planning

The 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.

• 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.
• Produce and maintain comprehensive documentation for data lineage, assumptions, refresh schedules, and usage guidelines.
• Experience in processing, manipulating, and analyzing large data sets to extract and organize information in a clear and comprehensive manner.
• Perform Emergency/Storm Duty as needed. Fieldwork and traveling on nights, weekends, or holidays required.

• Bachelor's Degree and 3 years of related work experience or
• Master's Degree and 2 years of related work experience

• Master's Degree and 2 years of related work experience

• Expert proficiency in tools such as MS SQL /PostgreSQL, Python (i.e. complex joins, performance tuning, reusable objects), required.
• Strong understanding of data governance, metric definition, and version of truth management, required.
• Advanced Power BI development: data modeling, DAX, performance optimization, enterprise publishing, required.
• Proven experience owning production analytics products used by leadership. Design, develop and implement database systems based on requirements, required.
• Experience working in large enterprise or regulated environments, required.
• Participate in GIS database design and architecture discussions, Evaluate existing database and recommend improvements for performance efficiency, preferred.
• Work experience with Oracle Analytics Cloud OAC, preferred.
• Work experience with Power Apps, Power Automate & Informatica, preferred.
• Exposure to GIS or spatial datasets for Utility, infrastructure, or asset intensive industry experience (planning, forecasting, load analysis, preferred.

• Demonstrated analytical skills
• Demonstrated problem solving skills
• Demonstrated written communication skills
• Strong written and verbal communication skills
• Instills commitment to organizational goals
• Well organized, detail oriented and flexible to handle multiple assignments
• Must be proficient in Microsoft Office including Word, Excel, Outlook and PowerPoint, etc.
• Quickly troubleshoots and resolves problems

• Driver's License Required

• The selected candidate will be assigned a System Emergency Assignment (i.e., an emergency response role) and will be expected to work non-business hours during emergencies, which may include nights, weekends, and holidays.
• Must be able and willing to travel as needed.
• Must be able to provide off hours support as required.

Mission Statement:

Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) employees are required to follow health, safety, and environmental policies, EEO, Standards of Business Conduct, and all other applicable company policy and procedures. We all share a responsibility to advance the company’s mission by excelling at our three corporate priorities – safety of our people and the public, operational excellence in all that we do, and ensuring the best possible customer experience.

Benefits:

We are dedicated to supporting the physical, mental, and financial health of our employees and their families. This commitment extends beyond the workplace to foster personal growth and holistic wellbeing. Our life-changing rewards package includes:

• Rich medical & pharmacy benefits, including vision benefits
• Dental benefits
• Health Savings Accounts
• Health Care and Dependent Care Flexible Spending Accounts
• 401(k) with robust matching
• Employer paid Pension Plan
• Employee Stock Purchase Plan with a generous matching contribution
• State of the art Employee Assistance Program
• Paid Parental Leave
• Generous paid time off plus paid holidays
• Family support: emergency backup child, & elder care assistance
• Social responsibility and volunteer opportunities
• Employee discount program
• Commuter Benefits
• Culture of growth and learning: career development; tuition reimbursement; recognition program
• Life and Long-Term Disability Benefits

*Please be aware that some benefits may not apply to provisional or part-time job titles.

EEO Statement:

Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) are equal opportunity employers. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of the individual’s actual or perceived disability, protected veteran status, race, color, creed, religion, sex, age, national origin, gender, gender identity, gender expression, genetic information, marital status, sexual orientation, citizenship, domestic violence victim status, or any other actual or perceived status protected by law.

Technical Difficulty Statement:

For technical issues, please contact us at [email protected]