Data Analytics & Reporting Analyst

Con Edison; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

Consolidated Edison Company of New York, Inc. (Con Edison) is seeking a Data Analytics Analyst to provide analytical, technical, and administrative support to the Gas Distribution Engineering Organization in New York City.

The role requires independent work, strong SQL, Power BI, and Python skills, and willingness to travel to service territory sites. You will develop dashboards, automate data processes, validate data quality, and partner with stakeholders to translate business needs into

Qualifications

• . Bachelor's Degree and 2 years of work experience in operations, IT, data analytics, or related experience.
• . Associate's Degree and 4 years of work experience in IT, data analytics, operations, or related experience.
• . High School Diploma/GED and 5 years of work experience in IT, data analytics, operations, or related experience.
• . Strong SQL skills, including the ability to develop, optimize, and troubleshoot complex queries for data extraction and analysis.
• . Experience developing and maintaining dashboards using Power BI or similar enterprise reporting tools.
• . Experience with Python or similar tools to support data transformation, automation, validation, and analysis.
• . Strong understanding of upstream and downstream data flows and the ability to analyze data across interconnected systems.
• . Demonstrated ability to gather, interpret, and translate business requirements into technical solutions and reporting outputs.

Responsibilities

• Interact with business and technical stakeholders across multiple organizations to understand data needs, and support reporting requirements.
• Analyze data across multiple systems to identify trends, inconsistencies, and data quality issues, and provide recommendations to improve processes and data reliability.
• Develop and maintain SQL queries to extract, validate, and analyze data across multiple data sources.
• Develop, maintain, and optimize reporting solutions, including dashboards, queries, and data extracts, to support operational and strategic decision-making and monitor key performance metrics.
• Develop and maintain Python-based processes to support data transformation, automation, validation, and analysis.
• Perform data validation, reconciliation, and root cause analysis to resolve discrepancies and improve accuracy across enterprise systems.

Skills

SQL

Power BI

Python

Data analytics

Data governance

Dashboards

Data transformation

Reporting

Stakeholder communication

Attention to detail

Education

Bachelor's Degree

Associate's Degree

High School Diploma/GED

Tools

Power BI

SQL Server

Python

Job description

Consolidated Edison Company of New York, Inc. (Con Edison) is seeking a Data Analytics Analyst to provide analytical, technical, and administrative support to the Gas Distribution Engineering Organization in New York City.

The role requires independent work, strong SQL, Power BI, and Python skills, and willingness to travel to service territory sites. You will develop dashboards, automate data processes, validate data quality, and partner with stakeholders to translate business needs into