Internship Excel Vba Programmer Jobs in Massachusetts

About Huxley Banking & Financial Services

Our purpose is twofold:

• To help clients achieve their business goals by connecting the best talent with the best employers
• To enable candidates to achieve their career goals by matching them with the best employers in their desired field.

Our clients include some of the world's best known banks, insurance companies, fund managers, brokerage firms, accountancy and consulting firms, and other financial institutions. We help them to identify, attract and recruit the business critical talent they need. And we connect professionals with some of the industry's best opportunities to enable them to achieve their career goals.

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.

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

All your information will be kept confidential according to EEO guidelines.