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:
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.
|