Sr Analyst - Gas Integrity Management

Socket.dev; New York (NY); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health benefits

401(k) with matching

Pension plan

Job summary

Consolidated Edison Company of New York, Inc. is seeking a Sr. Analyst to analyze gas distribution system risk and implement data governance across Gas Operations.

You will provide data access for ad-hoc reporting, perform geo-spatial queries with GIS, and develop insights from SQL-driven data analysis. The role emphasizes data quality, metadata management, and presenting engineering findings to varied leadership levels, with cross-functional collaboration across PSC, NYC OEM, FDNY, and

Qualifications

• Bachelor's Degree and 3 years' experience in gas, electric, steam or data analysis.
• Experience in statistical data trending and/or data analysis.
• Experience creating PowerBI dashboards, required.
• Familiarity with database structures, preferred.
• Experience with SQL, preferred.
• Experience with a programming language such as Python for data analysis, preferred.
• Must be proficient in Microsoft Office including Word, Excel, Outlook and PowerPoint, etc.

Responsibilities

• Plan, manage and implement Gas Engineering's Integrity Management programs, coordinating with vendors.
• Prepare and improve routine data reporting for all four operating areas.
• Assist data access for ad-hoc reporting and analyze gas system performance via data analytics and trending.
• Drive continuous improvement by providing feedback to data owners and the Data Governance Office.
• Own metadata management, data catalog, glossary, and quality rules; ensure standards with new assets.

Skills

Data Analytics

Data Governance

SQL

GIS

PowerBI

Python

Statistical analysis

Communication

Education

Bachelor's Degree in Engineering or Computer Science

Tools

SQL

PowerBI

Python

GIS

Excel

Job description

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.

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 [e-mail]