Title: Data Analyst III
Location:
Columbia, SC
Partially Onsite (Typical onsite Tues/Thurs, remote M,W,F)
Duration: 12 + Months
Job Description:
Team Name:
BAD team (Business Analysis Department)
Day To Day:
- This person will be developing new tools that support the business of I/S. They will be meeting with customers to understand the business needs and gather requirements, propose a solution, develop the needed solution, test, present to customers, communicate the new tool to the business including training and presenting, maintenance tools as needed.
The Team:
- With this position, we will be a team of 8. Half are part of developing new tools and reports and the other half work on the recurring reporting. They still work together a lot because some of the recurring work is being replaced by tools/dashboards that the development side is building. The team really likes collaborating with each other to complete the work. We have a lot of big projects happening this year and they are high focus for the business. We are shifting the way we provide information to management so that it is more real-time and self-serve.
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.
Required Skills and Abilities:
- PowerBI, Tableau, SQL, MS Access, MS Excel
- 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.
Nice To Have:
Preferred Software and Other Tools:
- SAS experience. Work environment: Typical office environment. Some travel between buildings and out of town.
IS 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.
Soft Skills :
- This person will need to be able to clearly communicate (written and verbally) with all levels of management. They will need to be able to understand processes, data logic, business logic, and be able to put requirements into written form. They will need to be able to connect the dots between processes and understand the big picture. They will need to be critical thinkers and problem solvers. They will need to be curious and take initiative to dig into things. They will need to be team oriented and willing to work with the team following the correct procedures. They need to be willing to listen.
|