Business Analyst III

High School Diploma/GED required.
Bachelor degree preferred or relevant experience in lieu of degree.
Minimum of seven (7) years’ experience in an operational role, or analytical role.
Experience in writing advance SQL queries
Experience on creating SSRS reports and SSIS Packages
Experience of Tableau and expertise with other data visualization tools
Knowledge of Healthcare industry required – Preferably in Medicare, Medicaid and Dual SNP Program.
Knowledge of Project Management methodologies

Responsible for conducting research and root cause analysis for customers with the goal of recommending and implementing new processes and solutions to operational deficiencies.
Resolves issues and improves operational performance on a cross-functional/departmental basis.
Design and develop SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems.
Creates data visualizations in Tableau, designs dashboards, and extracts insights from data sets.
Create and maintain database documentation.
Translate business requirements and assist IT with the development of technical specifications.
Investigate service related issues to identify root cause of issues; identify and communicate business needs assessments as necessary.
Lead or participate in internal and external project workgroup(s) and presentations.
Conduct User Acceptance Testing (UAT) for projects, implementations, system fixes and enhancements, etc.
Prepare materials for internal and external audit activities; review audit findings/reports for accuracy and completeness. If appropriate, formulate rebuttal and/or corrective action steps.
Perform other relevant tasks as assigned by management.