Previous Job
Joint Use Analyst
Ref No.: 18-02741
Location: Rochester, New York
Position Type:Contract
Start Date / End Date: 03/05/2018 to 02/02/2019
Title: Reporting Analyst
Job ID: 18-02726
Location: Rochester, NY 14649
Duration: 12 months
Contract Type:  Hourly Contract Position (w2 only)
  • NYSEG/RGE Joint Use of Plant department is responsible for issuing weekly reports (s) that are sent to the public service commission and internal/external stakeholders tracking the progress of processing Joint Use Pole Applications.
  • The reporting tracks a 3-year project effort in New York called NY Broadband for All as well as normal course of business processing activities.
  • Reporting responsibilities require the candidate to combine data from several reporting sources into a master Excel spreadsheet.
  • Scrubbing and Analyzing data to assure it is accurate and structured according to reporting needs.
  • From the master report several additional reports are developed and passed to external and internal stakeholders on a repetitive weekly basis.
  • The candidate will also be responsible to work with the various stakeholders in reconciling our reported data against their reported data to assure the parties are reflecting current and accurate status in the Pole Application process. 
Required Skills and Experience
  • Resource experienced (highly skilled) in Excel
  • Must have 5 years’ related experience
  • Highly skilled in Excel tools including Vlookup, Macros, If statements and Pivot Tables
  • Experienced using MS Access
  • Resource experienced with developing productivity measurement reports including datagathering, data analysis, report development (Excel) and report issuance
  • Preference if they have a background in the Utility Business (Joint Use of Plant ideal)
  • Level of comfort working with IT to examine opportunities to further automate reporting
  • Ability to work with Internal/External stakeholders to reconcile stakeholders reports against ours
  • Providing Report Status on work out calls with New York State Public Service Commission and internal/external Stakeholders.
Direct: : (732) 272 0296  Email:
Sourabh Agrawal | Lead - Talent Acquisition
Direct: (732) 272 0301| Email: