Title: Data Analyst II
Duration: 12 Months
Location: Columbia, SC
Hybrid - Onsite 3x per week

Duties:

• Day to day
  • There is a development and recurring or operational focus for the analyst.
  • The development work is consultative, customer-facing, and requires understanding I/S business processes.
  • Work involves facilitating meetings, gathering and documenting requirements, interacting with management and multiple teams to complete work, designing and developing a solution, and presenting outcomes to customers.
  • This work requires a technical focus as well as a business perspective and consultative mindset.
  • The recurring or operational work is recurring, repeatable tasks and includes one-time ad-hoc requests.
  • Recurring reports and data entry are well defined and are as automated as possible.
  • Recurring work is reviewed annually at a minimum to ensure it continues to meet business needs.
  • This work requires knowledge of reporting and data tools and communication with customers.
  • The operations focuses on timeliness, accuracy, consistency, and providing the key customer insights and analysis to help with business needs and decisions
• Analyzes data for creation of statistical reports used for program or process evaluation. Responsible for maintaining databases and extracting data for analysis.
• Runs and reviews reports, analyzing results in support of operational functions.
• 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.
• 35% 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.
• 25% 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.

Required Technologies:

• SQL knowledge
• PowerBI
• Microsoft Excel

Preferred Technologies:

• Tableau
• Power Automate
• Python
• GitHub
• MS Access

Required Skills and Abilities:

• Strong organizational, customer service, communications, and analytical skills.
• Ability to use complex mathematical calculations.
• Advanced knowledge of mathematical and statistical concepts.
• Knowledge of relevant computer support systems.
• Knowledge of programming languages across various software platforms, using DB2, SQL, and/or relational databases.
• Ability to analyze data results, determine the source of aberrant statistics, and resolve data issues.

Required Software and Tools:

• Microsoft Office.
• Knowledge of tools such as Visual Basic and Macros useful in automating reporting processes.

Preferred Skills and Abilities:

• Computer programming skills.
• Negotiation or persuasion skills.
• Knowledge of ICD9/CPT4 coding.

Preferred Software and Other Tools:

• SAS experience.

Work Environment:

• Typical office environment. Some travel between buildings and out of town.

Required Education: Bachelor's degree in Statistics, Computer Science, Mathematics, Business, Healthcare, or related field or 2 year degree in Computer Science, Business or related field and 2 years of reporting and data analysis work experience OR 4 years reporting and data analysis experience.

Required Work Experience: 2 Years Research and analysis experience.

Preferred Work Experience: 4 Years-Research and analysis experience. 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 30.00/daily.