Data Analyst

Title: Data Analyst III
Location; Columbia, SC (Onsite 3x per week)
Duration: 12 months

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
• Creates and analyzes reports to support operations.
• Ensures correctness of analysis, and reports findings in a concise manner to senior management.
• Directly responsible for accuracy of data as financial and operational decisions are made based on the data provided.
• 30% Generates internal and external reports to support management in determining productivity and efficiencies of programs or operational processes.
• Revises existing reports and develops new reports based on changing methodologies.
• 30% Analyzes reports to ensure accuracy and quality. Tracks and verifies all reporting statistics.
• 20% Communicates and trains employees and managers on the complex database programs used to generate analytical data.
• 20% Designs, codes, and maintains complex database programs for the extraction and analysis of data to support financial and operational decisions.

Required Technologies:

• Strong SQL knowledge
• PowerBI
• Microsoft Excel

Preferred Technologies:

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

Required Education:

• Bachelor''s degree in Statistics, Computer Science, Mathematics, Business, Healthcare, or other related field. Degree Equivalency: 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:

• 4 Years Research and analysis experience.

Preferred Work Experience:

• 6 Years-Research and analysis experience.

Required Skills and Abilities:

• Strong organizational, customer service, communications, and analytical skills.
• Advanced experience using complex mathematical calculations and understand mathematical and statistical concepts.
• Knowledge of relevant computer support systems.
• Ability to train subordinate staff including provide assistance/guidance to staff in design/execution of reporting needs.
• Proven experience with report writing and technical requirements analysis, data and business process modeling/mapping, and methodology development.
• Strong understanding of relational database structures, theories, principles, and practices.

Required Software and Other Tools:

• Advanced knowledge of Microsoft Office.
• Knowledge of programming languages across various software platforms, using DB2, SQL, and/or relational databases.
• 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.
• Knowledge of the healthcare delivery system.

Preferred Software and Other Tools:

• SAS experience.

Work environment:

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