Application Systems Analyst / Programmer IV

Please contact : To discuss this amazing opportunity, reach out to our Talent Acquisition Specialist Abhinav Chakraborty at email address Abhinav.Chakraborty@generistek.com can be reached on # 630-576-1925.

We have Contract role Application Systems Analyst / Programmer -Remote f or our Salem OR. Please let me know if you or any of your friends would be interested in this position.

Position Details :

Application Systems Analyst / Programmer -Remote-Salem OR

Location : Remote 100%

Project Duration : 10+ Month

Job Summary :

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food, and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and / or developmental disabilities; process claims and benefits; manage provider licensing and client facilities; and promote and protect the Client health.

OIS / OHA are seeking a SQL programmer to help modernize our ETL process for a reporting data mart names HAL (Health Analytics Library). This work anticipates development of an ETL that will have continuity as we move data marts into the Azure cloud-based servers from on-prem VM servers.

Contractor's Key Person under this WOC will closely with internal data management staff to identify scope of programming to update and update progress.

The programmer will work with internal program staff to facilitate introductions with data owners and work team meetings.

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

Tasks :

Required skills and experience :

In addition, the ideal candidate will have skills and experience in :

To discuss this amazing opportunity, reach out to our Talent Acquisition Specialist Abhinav Chakraborty at email address Abhinav.Chakraborty@generistek.com can be reached on # 630-576-1925.

About generis tek : generis tek is a boutique it / professional staffing based in Chicago land. We offer both contingent labor & permanent placement services to several fortune 500 clients nationwide. Our philosophy is based on delivering long-term value and build lasting relationships with our clients, consultants and employees. Our fundamental success lies in understanding our clients' specific needs and working very closely with our consultants to create a right fit for both sides. We aspire to be our client has most trusted business partner.