Programming Analyst
Job Responsibilities:
Programming Analysts are responsible for an array of data organizing, processing, and analyzing activities. Programming Analysts are expected to interact extensively with internal and external client team members to understand project requirements, outline analytic plans, conduct analyses, and provide back clear findings and results of work. Database size and complexity are contingent upon the type of information available and analytic objectives. Project databases range from several thousand to million plus record files. Data tables often have between 50 and 2,500 data fields. Databases are predominantly created for one-time, specific project use and ad hoc analyses.
An individual in this position will:
- Work with the project team to understand available data resources and develop an analytic plan
- Input, match and/or merge data inputs from a variety of sources into SQL, Excel, SPSS or other analysis ready formats
- Mine, manipulate and analyze data using SQL and other programs
- Utilize VBA with Excel to automate repetitive analytic processes and/or prepare worksheets for client
- Reformat and/or extract data needed to perform statistical modeling
- Drive large dataset project specific analytics
- Prepare drafts of conclusions and contribute to formulation of recommendations in assigned project areas
- Report to Partners and Managing Consultants during the course of an engagement
- Work simultaneously on multiple client engagements
Job Requirements:
- Candidates must have a strong academic record with an advanced degree in computer science or information technology or related quantitative discipline such as management and decision sciences, operations research, statistics or economics
- Strong database experience covering design, creation and analysis is essential
- SQL Server or other relational database manipulation expertise
- Demonstrated ability to code using Microsoft Excel and VBA
- Experience with statistical packages, e.g., SPSS, SAS or STATA
- Experience desired in using ADO to integrate Excel programs with external data sets
- Excellent interpersonal skills and ability to analyze and solve complex problems
- Must be able to communicate complex ideas effectively (both verbally and in writing), work well on teams demonstrating leadership qualities, and handle multiple commitments and frequent deadlines
- The ideal candidate would have a genuine passion for applying innovative analytics to solve real-world business problems
Return to Job Listings