Job Description :
Title: Data Analyst
Location: New York, NY 10045
Duration: 6 Months

Responsibilities:
Modify and upgrade an Excel/VBA based Resource Planning Tool.
Fully automate the data processing aspects of the tool including the consolidation of the various contributing data collection spreadsheets into a centralized SQL store.
Automate the integration of external data sources into the main spreadsheet from other Excel spreadsheets or SQL database sources.
Design spreadsheet based reports from the main spreadsheet accessible through macro button controls.

Required Skills:
Building complex VBA scripts to automate Excel spreadsheet processes.
Manipulating data with complex Excel, VBA and SQL Coding.
5+ years advanced experience with MS Excel, VBA and SQL scripting.
Expert level Excel skills (Conditional Formatting, Data Validation Rules, Table Manipulation, Named Ranges, Creating/Modifying connections to external data sources, Workbook/Worksheet/Cell Data Protection)
Expert level Excel VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas)
Advanced SQL skills (SharePoint Development Experience Data Modeling, Database Design/Development)
Developing/Maintaining Stored Procedures
Moderate experience developing web based applications
Knowledge of JavaScript & use of Ventura framework UI Development (Both frontend & backend development) experience would be helpful

Technical Skills:
Excel
VBA
SQL 4. 5.

Preferred Skills:
Building complex VBA scripts to automate Excel spreadsheet processes.
Manipulating data with complex Excel, VBA and SQL Coding.
5+ years advanced experience with MS Excel, VBA and SQL scripting
             

Similar Jobs you may be interested in ..