Business Intelligence Analyst

Remote: Business Intelligence Analyst/Developer Healthcare Experience with Medicaid and strong ETL (Extract, Transform, Load) _ Salem, OR

Location: Remote / Salem, OR

Duration: 17 Months

Required: Candidates must have recent Healthcare experience with Medicaid and a strong ETL (Extract, Transform, Load) background.

Important: Recent hands-on experience in both Medicaid and ETL is mandatory. Resumes that do not clearly demonstrate these required qualifications will not be considered for submission.

Visa : USC , GC , GC EAD , H4EAD

OIS/OHA are seeking a Business Intelligence Analyst/ Developer with expertise in SQL and Python programming to help modernize the ETL processes for a reporting data mart named HAL (Health Analytics Library). This work anticipates development and conversion of ETL pipelines, data tables and data processes and delivery of other HAL code updates in the current HAL on-premise environment, in which OHA currently ingests ETL data from the DSSURS data environment hosted in AWS cloud, but will also require continuity as OHA is preparing for the future migration of HAL to the OHA ODE (Oregon Data Environment) cloud Azure environment

.

ct: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 (OH

A).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 DSSU

RS.
Description for a Business Intelligence Analyst/Develo

per:Qualificati ons: Bachelor’s degree in finance, math, or data science. Hands-on knowledge of database tools SQL. Knowledge of programming languages like Python, Java, and R. Excel, Agile, Data modeling, Data analytics, Data mining, Data visualization. Familiarity with analytical tools like SAS, Hadoop, Spark, Hive, and Pig that may assist businesses in developing a solid BI stra

tegyDuties and Responsibilities: Extraction and analysis of company information, primarily financial, personal, expense, and revenue reports. Writing data collection and processing procedures. Ensuring that data is being correctly gathered, stored, and analyzed. Reporting data findings to management. Continually monitor data collection. Develop methodologies to improve data analy

sis.Description: Extraction and analysis of company information, primarily financial, personal, expense, and revenue reports. Writing data collection and processing procedures. Ensuring that data is being correctly gathered, stored, and analyzed. Reporting data findings to management. Continually monitor data collection. Develop methodologies to improve data analysis. Bachelor’s degree in finance, math, or data science. Hands-on knowledge of database tools SQL. Knowledge of programming languages like Python, Java, and R. Excel, Agile, Data modeling, Data analytics, Data mining, Data visualization. Familiarity with analytical tools like SAS, Hadoop, Spark, Hive, and Pig that may assist businesses in developing a solid BI strat

egy.

• 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 pro
• ducts.In 2025, the HPA MADI unit 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 sol

ution.

• ectives:Reprogramming, testing and implementing HAL ETL code, currently written in legacy SAS language, into SQL/ Python 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 OH
• A teams)Programming, testing and delivering other programming enhancements or programming work items related to HAL architecture, dataflows, tables, views, queries, reports, and ETL logic, in
• cluding:Updating Medicaid claim data tables and 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 s
• tandardsPerforming 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 re

sources.
Contractor’s Key Pers

• on 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 env
• ironment.Work with OHA project team members (PM, BAs, DBAs, data analysts, architects), HAL management and HAL users to identify/ determine business/technical requ
• irements.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 categori
• es, etc.)Design, develop and implement data pipelines using ETL processes and SQL tables that extract, transform, and load data into a HAL Medicaid data system/ datamart that helps the organization reach its strategi
• c goals..Migrate existing ETL process built in legacy SAS coding to Microsoft Structured Query Language (“SQL”) stack and Python language/ stored proced
• ures, 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/ Python language/ p
• roceduresDeveloping new SQL stack / stored procedures programming code to create new ETL p
• rocesses.Test, troubleshoot and implement the new ETL code in the HAL test and production envi

ronments.
Required skills and e

• xperience:SQL programmin
• g languagePython programmin
• g languageAdvanced data analys
• is skills.Experience using Microsoft DevOps, GIT, or other code managem

ent tools.
In addition, the ideal candidate will have skills and exp

• erience in:SAS programmi
• ng languageExperience using Jupyte
• r NotebooksData
• WarehousingGood communica