Data Analyst III

Job Title-: Data Analyst III Duration-: 12 months Location-: Columbia, SC (Onsite 3x per week) Schedule: 8:30am to 5pm with a 30 minute lunch or 8 to 5 with an hour lunch - Potential OT. This would be an exception, not a standard. Job Description: Duties: 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. 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 The Team: I/S Business Analysis Department (aka I/S BAD) The team size is around 10 team members. The team is extremely collaborative, working together to design and build cohesive solutions for our customers. 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. Job Requirement: 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 Technologies: Strong SQL knowledge, PowerBI, Microsoft Excel Preferred Technologies: Tableau, Power Automate, Python, GitHub, MS Access