Job Description
Key Accountabilities:
Key Performance Indicator (KPI) - develops custom performance programs to assess contractor performance. Scores are used to compare and incentivize contractors.
• Manage and develop the system to track and report on contractor performance.
• Most of our KPI programs are currently utilizing an Oracle Database accessed by SQL using Excel VBA for data collection and creating reports. We are on a road map to transfer the KPI programs from Excel to Alteryx and Tableau.
• Manage KPI process, including monitoring and reviewing inputs and producing monthly reports.
• Create the database structure, data input interfaces and the reports using an Oracle database, SQL and Excel VBA automation for older programs and develop new solutions in Alteryx and Tableau.
Storm Management - When planning for significant events, the team is responsible for procuring and processing external crews brought in to aid in the restoration. A home grown application has been developed to facilitate this process.
• Become the owner of the Storm Management System. System uses an Oracle database, SQL and Excel VBA
• Become the expert of the Storm Management System both as a developer and as a user. Continue to evolve the tools to support the Storm contract management process as it is improved.
• Troubleshoot issues during storm events and provide solutions in a potentially high stressful environment
• Support Securing Resources team during major weather events in New York & New England. Responsibilities could include procuring, processing, or tracking contractor crews.
• Develop job aids and provide training
• Storm support is required 365 days a year and may involve weekend and holiday work as needed.
Qualifications
Knowledge & Experience Requirements:
• Expert Excel user including VBA programming
• Expert in SQL
• Expert in Alteryx
• Expert in Tableau
• Experience in creating database structures, user interfaces and complex reports
• Experience in developing complex Excel tools
Capability Requirements:
• Analytical Thinking: Ability to leverage and analyze data to identify critical information, develop hypothesis and make actionable recommendations
• Information Seeking: Establishes the facts by digging deeper, asking probing questions and challenging initial responses from different sources
• Impact and Influence: Uses direct persuasion to influence others, using basic data, logic or a solid business case
• Understanding Others: Understands what a customer is saying, their needs and concerns, even if the customer is not very clear, and can provide appropriate responses to develop positive customer relations
• Teamwork and Collaboration: Values learning from team members and other colleagues' input and expertise, actively engaging them in conversation to develop innovative business solutions to enhance the end-to-end customer experience
• Drive for Results: Sets and strives to meet challenging, but realistic service efficiency goals to improve the overall customer experience
Additional Information
