Business Systems Consultant

Role:Business Systems Consultant

Duration:11Months Location:Hybrid

Tasks: .Provide project management support, such as writing project status and other written reports and presentations covering analysis and recommendations for agency project team/ project governance committee, communication materials, etc. Lead and perform HAL data system analysis and evaluation work, including: .interviewing system users and system management teams to inquire about system issues and gaps .reviewing documentation and analyzing current HAL system/ environment, including data models, schemas and tables, data dictionaries, ETL’s, system and database management processes, data quality, security, queries, reporting environment, etc. .documenting existing data/system architecture, data flows, description of schemas, tables and fields .identifying and describing current issues and areas for improvement, .providing or developing system improvement reports and recommendations. .documenting, prioritizing, and presenting improvement recommendations, .developing a strategic roadmap for data system improvement efforts. .Work with OHA project team members (PM, BAs, DBAs, data analysts, architects) and HAL users to determine business/technical requirements, evaluate and recommend specific data design options .Gather and document detailed system, data and integration requirements for HAL system improvements (e.g. changes to business rules, ETL code, HAL tables, new or updated OHG Medicaid claim code grouping categories, etc.) .Develop test cases, scripts and test datasets. .Perform system/ data testing, analyze and document test results. .Develop or update data management standards and processes, to inform business area system improvement and deployment activities, and train OHA staff in the application and use of these standards and processes. .Organize, develop and update system, process and training materials to help educate HAL users about data management best practices and usage of BI tools to analyze and report data stored in HAL.

Required skills and experience: ·Excellent written/ oral communication skills. .Advanced data analysis skills. .Analytical problem-solving skills. .Working knowledge of SDLC. .Proficient in the use of Microsoft Office suite tools.

In addition, the ideal candidate will have skills and experience in: Knowledge of Medicaid administrative data and eligibility requirements. Knowledge of project management principles. Business analysis techniques, especially in gathering and documenting business and technical requirements. Project management tools like Smartsheet. Attention to detail.