Data Analytics & Reporting Analyst (SQL/Python)

Consolidated Edison Company of New York; New York (NY); Presencial; USD 85 000 - 110 000; Tempo integral

Resumo da oferta

Consolidated Edison Company of New York is seeking an Analyst to provide analytical, technical, statistical and administrative support to the Gas Distribution Engineering Organization. The candidate must be able to work independently as well as in teams and will travel to various locations throughout the Con Edison service territory.

Responsibilities include data analysis, SQL development, dashboarding with Power BI, Python-based data processing, and ensuring data quality across enterprise

Qualificações

• Experience in data analytics, data governance, database management, or a related field, required.
• Strong SQL skills, including developing, optimizing, and troubleshooting complex queries for data extraction and analysis, required.
• Experience developing and maintaining dashboards using Power BI or similar enterprise reporting tools, required.
• Experience with Python or similar tools to support data transformation, automation, validation, and analysis, required.
• Strong understanding of upstream and downstream data flows and the ability to analyze data across interconnected systems, required.
• Strong analytical, organizational, and problem-solving skills with a high level of attention to detail and commitment to data accuracy, required.
• Ability to work independently, manage multiple priorities, and adapt to evolving business and data requirements, required.
• Demonstrated ability to gather, interpret, and translate business requirements into technical solutions and reporting outputs, required.
• Demonstrated curiosity, initiative and willingness to learn new technologies, systems, and business processes, preferred.

Responsabilidades

• Interact with business and technical stakeholders to understand data needs and reporting requirements.
• Analyze data across multiple systems to identify trends, inconsistencies, and data quality issues and provide recommendations to improve processes.
• Develop and maintain SQL queries to extract, validate, and analyze data across multiple data sources.
• Develop, maintain, and optimize reporting solutions, including dashboards and data extracts, to support decision-making and monitor KPIs.
• Develop 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.
• Support data quality initiatives, document business rules, and improve usability of reporting outputs.

Conhecimentos

SQL

Power BI

Python

Data analytics

Data governance

Database management

Reporting

Formação académica

Bachelor's Degree

Associate's Degree

High School Diploma/GED

Ferramentas

Power BI

SQL

Python

Descrição da oferta de emprego

Consolidated Edison Company of New York is seeking an Analyst to provide analytical, technical, statistical and administrative support to the Gas Distribution Engineering Organization. The candidate must be able to work independently as well as in teams and will travel to various locations throughout the Con Edison service territory.

Responsibilities include data analysis, SQL development, dashboarding with Power BI, Python-based data processing, and ensuring data quality across enterprise