Sr Analyst - Gas Integrity Management

Consolidated Edison Company of New York; New York (NY); On-site; USD 90,000 - 140,000; Full time

Job summary

Consolidated Edison Company of New York is seeking a Sr. Analyst to analyze trends related to the gas distribution system risk and implement data governance in Gas Operations. The role supports data access for reporting and analyzes gas system performance using SQL and data analytics.

The successful candidate will apply knowledge of system data and engineering records to answer inquiries and aid business decisions. The Sr.

Qualifications

• Bachelor's Degree and 3 years' experience full-time in gas, electric, steam or data analysis.
• Bachelor's Degree in Engineering or Computer Science with 3 years' experience in data analysis.
• General working knowledge of GIS or mapping systems, required.
• Experience in statistical data trending and/or data analysis, required.
• Experience creating PowerBI dashboards, required.
• Familiarity with database structures, preferred.
• Experience with SQL, preferred.
• Experience with Python for data analysis, preferred.

Responsibilities

• Plan, manage and implement Gas Engineering's Integrity Management programs.
• Prepare and improve routine data reporting mechanisms for all four operating areas.
• Support data access for custom and ad-hoc reporting and analyze gas system performance.
• Drive continuous improvement through feedback to data owners and Data Governance Office.
• Own metadata management and ensure data catalog, glossary, and quality rules are updated.
• Prepare engineering analyses and present to all levels of the organization.
• Utilize prioritization software and datasets to improve gas system performance.
• Perform engineering analysis for operating areas to interpret statistical information.
• Interpret system risk using the DIMP Risk Model.
• Collect and prepare information for submittals to PSC, NYC OEM, FDNY, etc.

Skills

SQL

PowerBI

Python

GIS

Excel

Education

Bachelor's Degree in Engineering or Computer Science

Tools

ArcGIS

Job description

Overview

The Sr. Analyst is responsible for analyzing trends related to the gas distribution system risk and for implementing data governance practices in Gas Operations. The Sr. Analyst will support the department with accessing data for custom and ad-hoc reporting and will analyze gas system performance through data analytics and trending. The successful candidate will be proficient in data analysis and coding, including SQL, to extract, manipulate, and analyze data to provide actionable insights. The Sr. Analyst will apply knowledge of system data and various engineering records to answer inquiries and help make sound business decisions. Additionally, the Sr. Analyst will perform geo-spatial queries using GIS products. The analytics and data governance initiatives will enhance the companys Distribution Integrity Management program and advance data quality across Gas Operations.

Responsibilities

Core Responsibilities

• Plan, manage and implement Gas Engineerings Integrity Management programs. This includes working with the vendor to upgrade and improve the prioritization program and manage the various programs that interact with the risk model.
• Prepare and continuously improve routine data reporting mechanisms for all four operating areas.
• Support the department with accessing data for custom and ad-hoc reporting and will help analyze gas system performance through data analytics and trending.
• Drive the continuous improvement cycle through feedback to data owners and the enterprise Data Governance Office on the effectiveness of Data Governance practice and related policy.
• Own metadata management, ensuring data catalog, glossary, and quality rules are up to date and standards are followed when new assets are added.
• Prepare engineering analysis and present to all levels of the organization.
• Utilize prioritization software and various data sets to recommend modifications and improve gas system performance.
• Perform engineering analysis for operating areas to help interpret statistical information.
• Utilize the DIMP Risk Model to interpret system risk.
• Collect, analyze, and prepare information for submittal to the PSC, NYC OEM, FDNY, Municipalities, etc. regarding engineering studies performed and requested.
• Developing a proactive, customer-centric culture to foster trust and confidence of our customers and improve value for all our stakeholders.
• Perform in-depth data analysis and develop complex SQL queries to extract and manipulate data from various sources.

Qualifications

Required Education/Experience

• Bachelor's Degree and 3 years' experience full-time industry experience in gas, electric, steam or data analysis.

Preferred Education/Experience

• Bachelor's Degree in Engineering or Computer Science and 3 years' experience full-time industry experience in gas, electric, steam or data analysis.

Relevant Work Experience

• General working knowledge of geographic information system and/or mapping system(s), required.
• Experience in statistical data trending and/or data analysis, required.
• Experience creating PowerBI Dashboards, required.
• Familiarity with database structures, preferred.
• Experience with SQL, preferred.
• Familiarity with database structures, preferred.
• Experience with a programming language such as Python for data analysis, preferred.

Skills and Abilities

• Must be proficient in Microsoft Office including Word, Excel, Outlook and PowerPoint, etc.
• Well organized, detail oriented and flexible to handle multiple assignments
• Demonstrates excellent judgment and decision making skills
• Strong written and verbal communication skills

Licenses and Certifications

• Driver's License Required

Physical Demands

• Sit or stand to use a keyboard, mouse, and computer for the duration of the workday

Additional Physical Demands

• 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 within Company service territory, as needed.
• Must be able to participate and travel to industry conferences, as needed.
• Must be able to make fields visits and wear applicable personal protective equipment.