Sr Analyst - Gas Integrity Management
Con Edison · Bronx, NY · 1 mo ago
On-siteBusiness DevelopmentOther
We need to output HTML fragment with sections for headings that have real content. Use for each section heading. Use
for each section heading. Use - for any list of duties/requirements/benefits. Use
for prose.
We need to parse the posting.
Overview paragraph: "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."
We can put that as a
maybe under an "Overview" heading? The instruction says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't forbid other headings? It says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely we should use those standard headings if content exists. Overview could be "About the role". So we can put Overview content under About the role
as a
.
Responsibilities: The posting has a "Responsibilities" heading with bullet list (Core Responsibilities). We'll extract each bullet as
- . The bullet list includes many sentences separated by periods? Actually they are sentences separated by periods but each bullet is a line starting with a verb. We'll treat each line as a list item.
We need to preserve all substantive information. Let's list them:
- 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.
We'll put these under
Responsibilities
with .
Qualifications: There's "Qualifications" heading with subparts: Required Education/Experience, Preferred Education/Experience, Relevant Work Experience.
We need to decide if we should create a Qualifications section with subpoints? The instruction: Use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have a Qualifications heading and then inside we can have
or
for details. Since there are multiple items, we can use for each bullet.
Let's extract:
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. (duplicate)
- Experience with a programming language such as Python for data analysis, preferred.
We should deduplicate duplicate "Familiarity with database structures, preferred." appears twice; we should keep only one instance.
Skills and Abilities: list.
- 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.
We need to decide which sections to include. We have About the role (Overview), Responsibilities, Qualifications, Skills and Abilities, Licenses and Certifications, Physical Demands (maybe combine Physical Demands and Additional Physical Demands under a heading like "Physical Demands" or "Working Conditions").
We should not create sections like Benefits, Pay, Schedule if not present. There's no mention of benefits, pay, schedule. So we omit those.
We need to ensure we don't include boilerplate like EEO etc. Not present.
Now produce HTML fragment.
Structure:
About the role
Overview text...
Responsibilities
- ...
...
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.
- Experience with a programming language such as Python for data analysis, preferred.
But nesting inside - is okay. Could also just list as separate items without nesting. Simpler: just list each qualification as separate
- with the text.
We'll do:
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.
- Experience with a programming language such as Python for data analysis, preferred.
But that nests a inside - . Acceptable.
Alternatively flatten: list each as separate
- with label.
We'll do flatten for simplicity:
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.
- Relevant Work Experience: Experience in statistical data trending and/or data analysis, required.
- Relevant Work Experience: Experience creating PowerBI Dashboards, required.
- Relevant Work Experience: Familiarity with database structures, preferred.
- Relevant Work Experience: Experience with SQL, preferred.
- Relevant Work Experience: Experience with a programming language such as Python for data analysis, preferred.
That avoids nested lists.
Now Skills and Abilities:
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:
Licenses and Certifications
Driver's License Required
Physical Demands: combine.
Physical Demands
- Sit or stand to use a keyboard, mouse, and computer for the duration of the workday
- 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 field visits and wear applicable personal protective equipment.
Note: "fields visits" typo; we keep as is? The posting says "fields visits". We'll keep exactly: "Must be able to make fields visits and wear applicable personal protective equipment."
Now ensure we didn't miss any substantive info: The overview includes "The Sr. Analyst is responsible for analyzing trends related to the gas distribution system risk and for implementing data governance practices in Gas Operations." etc. We included that.
Check responsibilities: we captured all bullet points. Let's verify each:
1. 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. -> included.
2. Prepare and continuously improve routine data reporting mechanisms for all four operating areas. -> included.
3. Support the department with accessing data for custom and ad-hoc reporting and will help analyze gas system performance through data analytics and trending. -> included.
4. 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. -> included.
5. Own metadata management, ensuring data catalog, glossary, and quality rules are up to date and standards are followed when new assets are added. -> included.
6. Prepare engineering analysis and present to all levels of the organization. -> included.
7. Utilize prioritization software and various
for prose. We need to parse the posting. Overview paragraph: "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." We can put that as a
maybe under an "Overview" heading? The instruction says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't forbid other headings? It says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely we should use those standard headings if content exists. Overview could be "About the role". So we can put Overview content under About the role
as a
About the role
as a. Responsibilities: The posting has a "Responsibilities" heading with bullet list (Core Responsibilities). We'll extract each bullet as
Responsibilities
with- .
Qualifications: There's "Qualifications" heading with subparts: Required Education/Experience, Preferred Education/Experience, Relevant Work Experience.
We need to decide if we should create a Qualifications section with subpoints? The instruction: Use
- ... ...
- 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.
- Experience with a programming language such as Python for data analysis, preferred.
- is okay. Could also just list as separate items without nesting. Simpler: just list each qualification as separate
- with the text.
We'll do:
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.
- Experience with a programming language such as Python for data analysis, preferred.
- inside
- . Acceptable. Alternatively flatten: list each as separate
- with label.
We'll do flatten for simplicity:
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.
- Relevant Work Experience: Experience in statistical data trending and/or data analysis, required.
- Relevant Work Experience: Experience creating PowerBI Dashboards, required.
- Relevant Work Experience: Familiarity with database structures, preferred.
- Relevant Work Experience: Experience with SQL, preferred.
- Relevant Work Experience: 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: combine.Physical Demands
- Sit or stand to use a keyboard, mouse, and computer for the duration of the workday
- 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 field visits and wear applicable personal protective equipment.
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have a Qualifications heading and then inside we can have
or
- for details. Since there are multiple items, we can use
- for each bullet.
Let's extract:
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. (duplicate)
- Experience with a programming language such as Python for data analysis, preferred.
We should deduplicate duplicate "Familiarity with database structures, preferred." appears twice; we should keep only one instance.
Skills and Abilities: list.
- 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.
We need to decide which sections to include. We have About the role (Overview), Responsibilities, Qualifications, Skills and Abilities, Licenses and Certifications, Physical Demands (maybe combine Physical Demands and Additional Physical Demands under a heading like "Physical Demands" or "Working Conditions").
We should not create sections like Benefits, Pay, Schedule if not present. There's no mention of benefits, pay, schedule. So we omit those.
We need to ensure we don't include boilerplate like EEO etc. Not present.
Now produce HTML fragment.
Structure:
About the role
Overview text...
Responsibilities
Qualifications
- inside