Description
Position: Data Analyst II
Location: Columbia, SC
Duration: 12+ Months
JOB DESCRIPTION:
- 40% Reviews, extracts and analyzes data to be used in formulation of procedures, processes and other requirements. Provides reports of relevant activity to be used to identify problematic areas and to provide basis for modification and/or elimination of operations issues.
- 30% Coordinates and joins meetings to gather analytical data for root-cause analysis and problem resolution and then compile into a cohesive documents and update access database with data.
- 20% Assists with development of complex analysis and sophisticated data compilation, verification, and interpretations to guide divisional efforts. Performs focused analyses as needed. Creates data search programs to identify pertinent data needed to provide supporting documentation for system or operational enhancements/changes.
- 10% Documents reporting procedures so other staff can run ad hoc reports independently. Designs, codes, and maintains complex database programs for the extraction and analysis of data to support financial and operational decisions.
- Performs other duties as assigned.
WORKING HOURS/CONDITIONS:
- 8:00 AM EST - 5:00 PM EST/Cubicle.
EDUCATION/EQUIVALENCY:
- Bachelor's Degree in Statistics, Computer Science, Mathematics, Business, Healthcare, or related field
- OR 2 year degree in Computer Science, Business + 2 years of reporting and data analysis work experience or related field
- OR extra 4 years reporting and data analysis experience.
CANDIDATE TECHNICAL BACKGROUND:
- Research and Analysis Experience (Required, 2 years).
- Experience with Root Cause Analysis Facilitation.
- Data Analysis Experience.
- Experience communicating with Upper Management.
- Experience with Microsoft Access.
- Experience with Microsoft Excel.
Note: Candidate MUST be very proficient with Excel. Candidate(s) need to have experience manipulating data, experience with pivot tables, SUMIFs, etc)
- Experience with Microsoft Word
- Experience with Microsoft PowerPoint
- Experience with Process Improvement Techniques (Nice To Have)
- Experience with Information Technology Terminology
- Experience with Standard Hardware and Application familiarity
- Excellent Written Communication
- Strong Statistical Background
- Knowledge of ITIL (Nice To Have)
- Microsoft Visio (Nice To Have)
- Experience with SQL or DB2 (Nice To Have)
DAILY JOB RESPONSIBILITIES:
- Will serve on the Problem Management team apart of the strategic ITIL initiative.
- Daily data analysis and communication with System Managers on potential problems their systems may be experiencing.
- Identify problems with Applications or Hardware and facilitate the problem-resolution with system owners to reduce or eliminate the problems.
- Coordinate and join meeting-to-gather analytical data for root-cause and problem resolution and then compile into a cohesive document.
- Update access database and create and manipulate reports in access.