VBA Programming Analyst

VBA Programming Analysts (Tools Analysts) contribute significantly to the success of our research deliverables by designing and maintaining databases, automating data analysis and reporting, and building Web-based tools that integrate our data and the results of our analysis into the daily workflow of executives at the world’s leading corporations and not-for-profit institutions.

Responsibilities Include:

• Design and maintain databases in Excel and SPSS.
• Manipulate SPSS, Excel, and other programs to produce customized data queries, analysis, and reports.
• Analyze and interpret data using Excel and SPSS and represent findings through charts and CEB-quality graphics.
• Manage relationships between CEB and various technical and non technical vendors.
• Troubleshoot/debug, update, and maintain existing data tools.
• Conceptualize and develop Web-based interfaces with the ability to pull and display information from various databases.
• Present findings to senior managers and train others on the use of data tools.
• Support the team through other tasks as needed.

The Ideal Candidate Will Possess:

• A background in database statistics, data management, statistical research, system study, and programming/documentation
• Advanced knowledge of Microsoft Excel including proficiency in building macros and using VBA programming
• Experience with statistical packages (SPSS, SAS, STATA, etc.) and familiarity with SPSS automation preferred
• Proficiency in basic statistical concepts (regression analysis, factor analysis, significance testing, etc.)
• Competency in Microsoft Visual Basic for Applications (VBA): 2+ years experience with VBA required
• Familiarity with Web application design (C#, MS.Net, Page Maker, HTML)
• Knowledge of technical documentation standards (Unified Modeling Language)
• High proficiency in distilling massive amounts of data into important relevance for senior managers
• Excellent communication skills, including the ability to generate reports using Power Point and other software packages
• Strong project management and time management skills combined with a very high attention to detail
• Ability to work either independently or in a team environment
• Exceptional performance in undergraduate academics or graduate studies
• 2-6 years post undergraduate experience, or related experience