Back to Jobs search

Application Systems - Hybrid

MSys Inc. • Salem, OR • 3d ago

Job summary:

Title:

Location:

Salem, OR, United States

Length and terms:

Long term - W2 or C2C

Position created on 08/14/2025 08:44 pm

Job description:

Interview Type: SkypeHybridmust be local OR***

Description:

Background and Scope of Project:

HAL is a Medicaid analytical and reporting SQL data mart solution and data 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 Oregons 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, and.

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.

In spring 2025, MADI has launched a HAL solution modernization project to convert the HAL ETL code from SAS to SQL, as well as to analyze, identify, develop, test and implement other improvements to the HAL data solution. This project has the following objectives:

Reprogramming, testing and implementing HAL ETL code, currently written in legacy SAS language, into SQL language, to prepare HAL for receiving ETL data from the new DSSURS environment hosted in AWS and for the future migration of HAL to the OHA ODE (Oregon Data Environment) cloud Azure environment (NOTE: The migration to the ODE cloud, expected to occur in the next 1-2 years, is out of scope for this project and will require working with OIS and other OHA teams)

Programming, testing and delivering other programming enhancements or programming work items related to HAL architecture, dataflows, tables, views, queries, reports, and ETL logic, including:

Updating Medicaid claim data reports used predominantly by the Office of Actuarial and Financial Analysis (OAFA) team for rate capitation analyses or to reflect updates in Medicaid national coding standards

Performing other coding improvements needed by OAFA team users and other HAL users to improve analytical value and capabilities of HAL system data or to reflect changes in Medicaid eligibility, enrolment, benefits, programs, 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:

Perform analysis of HAL data system as needed, which may include 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.

Work with OHA project team members (PM, BAs, DBAs, data analysts, architects), HAL management and HAL users to identify/ determine business/technical requirements.

Gather and document detailed system, data and integration requirements for HAL system improvements (e.g. changes to ETL code, business rules, HAL tables, new or updated OHG Medicaid claim code grouping categories, etc.)

Design, develop and implement new ETL code/ packages.

Migrate existing ETL process built in legacy SAS coding to Microsoft Structured Query Language ("SQL") stack and Python language/ stored procedures, by:

Working with various program areas and business teams to make code as modular as possible.

Reviewing and analyzing existing ETL SAS programming code to update to new SQL language/ procedures

Developing new SQL stack / stored procedures programming code to create new ETL processes.

Test, troubleshoot and implement the new ETL code in the HAL test and production environments.

Required Skills:

SQL programming language (7-10+ years of experience)

Microsoft SQL Server (7-10+ years of experience)

Python programming language (7-10+ years of experience)

Advanced data analysis skills (4-6 years of experience)

Microsoft Office (4-6 years of experience)

Experience using Microsoft DevOps, GIT or other code management tools

Contact the recruiter working on this position:

The recruiter working on this position is Fazal(Shaji Team) Uddin

His/her contact number is +(1) (703) 4684697 His/her contact email is fazal@msysinc.com

Our recruiters will be more than happy to help you to get this contract.

Similar Jobs

Environmental Restoration Subject Matter Expert

Noblis • Salem, OR • 25min ago

Responsibilities Environmental Restoration Subject Matter Expert The mission of the Department of Defense (DoD) Strategic Environmental Research and Development Program (SERDP) and the Environmental Security Technology C...

25min ago

Go to Apply

Senior Business Intelligence Engineer

Humana • Salem, OR • 19h ago

IT & Engineering

Become a part of our caring community and help us put health first The Senior Business Intelligence Engineer solves complex business problems and issues using data from internal and external sources to provide insight to...

19h ago

Go to Apply

Senior Manager, CaaS Sales (Crypto as a Service)-Payments

Coinbase • Salem, OR • 23h ago

Management & Administrative

Ready to be pushed beyond what you think you're capable of? At Coinbase, our mission is to increase economic freedom in the world. It's a massive, ambitious opportunity that demands the best of us, every day, as we build...

23h ago

Go to Apply

Senior Manager, CaaS Sales (Crypto as a Service)-Financial Institutions

Coinbase • Salem, OR • 1d ago

Finance, Accounting & Banking

1d ago

Go to Apply

Cyber Security Manager

Amentum • Salem, OR • 1d ago

Management & Administrative

Please note this position is based on Contract Award and is located on the island of Diego Garcia. Facility-Related Control System (FRCS) Cybersecurity Manager The Contractor shall provide a FRCS Cybersecurity Manager to...

1d ago

Go to Apply

Connect Care Medical Assistant

Intermountain Health • Salem, OR • 1d ago

Hospital & Medical

Job Description: A Medical Assistant II performs routine clerical and clinical tasks within the clinic, assisting Physicians and other licensed providers to provide quality patient care efficiently and cost effectively....

1d ago

Go to Apply

Security Engineer - Nashville/Austin (Relo availabile)

Oracle • Salem, OR • 1d ago

IT & Engineering

Job Description We offer unique opportunities for smart, hands-on security engineers with the expertise and passion to solve difficult architecture, engineering, and process problems.? Our customers run their businesses...

1d ago

Go to Apply

NLP & LLM Data Scientist - Healthcare & Life Sciences

Norstella • Salem, OR • 1d ago

Hospital & Medical

NLP & LLM Data Scientist - Healthcare & Life Sciences Company: Norstella Location: Remote, United States Date Posted: Aug 17, 2025 Employment Type: Full Time Job ID: R-1387 Description About Norstella At Norstell...

1d ago

Go to Apply

Operations Manager (Cosmetology & Barber)

PSI Services • Salem, OR • 1d ago

Management & Administrative

Description Title: Operations Manager (Cosmetology and Barber) Location: Remote-US Salary: Up to $95k/annually ?About PSI Join Us at PSI - Where You Belong, Grow, and Thrive! At PSI, we believe that people achieve their...

1d ago

Go to Apply

HIM ROI Analyst II

Intermountain Health • Salem, OR • 1d ago

Job Description: Supports the HIM Release of Information program through the facilitation of ROI-related processes and workflows designed to ensure the complete, accurate, timely and compliant release of information. The...

1d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.