What are the responsibilities and job description for the Business Systems Consultant IV --- HYBRID -- Salem, OR, USA position at Nexpro Technologies Inc?
Job Description
Job Description
Business Systems Consultant IV :
OIS / OHA are seeking an experienced Business Systems Consultant with expertise in data system analysis and evaluation and advanced communication skills to provide project management support, data system evaluation and improvement support, including the documentation of improvement recommendations, business and technical requirements and test cases, and delivery of testing support in accordance with business, data security and regulatory requirements.
Background and scope of project :
HAL is a Medicaid analytical and reporting SQL database solution and environment managed by the MADI (Medicaid Analytics and Data Integration) Unit housed within the Office of Health Information Technology and Analytics Infrastructure, that exists within the Health Policy and Analytics (HPA) Division of the Oregon Health Authority (OHA).
Medicaid administrative data is primarily made up of 1) medical claims submitted by health providers and Coordinated Care Organizations (CCOs) to receive payment for health services delivered to patients enrolled in Oregon's Medicaid program, which is known as the Oregon Health Plan (OHP) and 2) Medicaid enrollment data from the OHA / ODHS ONE eligibility system. The raw transactional data are stored in Oregon’s Medicaid Management & Information System (MMIS). HA analysts typically access these data through a MMIS data warehouse solution called Decision Support and Surveillance Utilization Review System (DSSURS), or in the Health Analytics Library (HAL), where the raw Medicaid enrollment and utilization / claim data are packaged differently into easier to analyze categories and groups for analysis. These analytical value-added elements are not present in DSSURS.
HAL contains Medicaid enrolment and claims data that is accessed by two main sets of users :
- OHA’s Office of Actuarial and Financial Analysis (OAFA) team users, who use the data for setting of per-capita rates of reimbursement of health care services provided by Coordinated Care Organization (CCO’s) to Oregon’s Medicaid population, and various other financial analyses.
- Office of Health Analytics’ reporting teams, who access Medicaid enrollment and claims data for the development of different enrollment and utilization analytical and data visualization products.
The HPA MADI unit wants to launch a HAL modernization project to analyze, identify and make improvements to the HAL analysis and reporting database solution. This project has the following objectives :
o Updating claim data grouping categories used predominantly by the Office of Actuarial and Financial Analysis (OAFA) team for rate capitation analyses, to reflect updates Medicaid national coding standards.
o Performing other coding improvements needed by OAFA team users and other HAL users to improve analytical value and capabilities of HAL data or reflect changes in Medicaid eligibility, program, beneficiary and claim administrative coding– these types of improvements have accumulated over time and have reached a point in which they require a focused project and dedicated resources.
Tasks :
Contractor’s Key Person shall work with various OHA program areas and business teams and OIS staff as needed performing the following tasks :
o interviewing system users and system management teams to inquire about system issues and gaps,
o 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.
o documenting existing data / system architecture, data flows, description of schemas, tables and fields
o identifying and describing current issues and areas for improvement,
o providing or developing system improvement reports and recommendations.
o documenting, prioritizing, and presenting improvement recommendations,
o developing a strategic roadmap for data system improvement efforts.
Required skills and experience :
In addition, the ideal candidate will have skills and experience in :
Company Description
NexPro Technologies offers robust, responsive and value-driven IT consulting and placement services.
Company Description
NexPro Technologies offers robust, responsive and value-driven IT consulting and placement services.
