Primary Responsibilities:
- Analyze and develop complex SQL supporting data warehouse downstream reporting and analytics
- Analysis of current business processes and systems, and documenting requirements for new processes and systems
- Work with internal team and customer on business documentation and updates
- Assist with user acceptance testing, including defect reporting and follow up. Help with development of test scenarios and acceptance criteria
- Help with developing presentations for internal team or for the customer. Solicit input from others and pull information together to create a professional presentation.
- Work with team to document updates needed for Operations Guide
- Assist with analysis of Medicaid enrollment, provider and claims data, and document requirements, use cases
- Assist with identifying and documenting data anomalies and collaborate with cross functional teams for effective resolution
- Share use cases to data analysts for profiling, review results and infer compliance to Medicaid / CMS processes and guidelines
- Ability to juggle multiple priorities and ensure availability to questions and clarifications from data analysts
- Positive attitude and willingness to jump in and help where needed
Required Qualifications:
- 7+ years of healthcare business analysis experience supporting business initiatives through data analysis, writing business requirements and user acceptance testing of various systems
- 4+ years of experience working with State Medicaid and CHIP agencies including federal reporting (CMS 64/21, TMSIS, PERM)
- 5+ years of experience in writing SQL
- Proven ability to lead communication (written and verbal) at the customer leadership level
- Knowledge of health insurance, HMO and managed care principles including Medicaid and Medicare regulation
- Effective organizational, analytical, time management, problem-solving, and multi-tasking skills, and habits; ability to complete assignments under tight deadlines with little/no direct supervision
- Bachelor’s degree in related field
Preferred Qualifications:
- 5+ Years of experience in Informatica PowerCenter creating extracts
- Knowledge of data integration, software enhancements/planning and agile methodologies
- Experience with using Azure DevOps, SharePoint, MS Project, Visio