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
|