• Shift 1

• 8:00 AM

5:00 PM Regular Day Yes Type Category Qualification Description Competency Required Skills Database Data Analysis Proficient (4-6 Years) Yes Skills Database Data Warehousing Proficient (4-6 Years) No Skills Database Microsoft SQL Server Advanced (7-9 Years) Yes Skills Languages SQL Advanced (7-9 Years) Yes Skills Others Python Advanced (7-9 Years) Yes Skills Others SAS Advanced (7-9 Years) No Skills Others Communication skills both verbal and written Proficient (4-6 Years) Yes Skills Tools MicrosoftOffice Proficient (4-6 Years) Yes Remote work/Telecommuting will be contingent upon the key person providing their own adequate office equipment and connectivity.

• PLEASE READ BEFORE SUBMITTING PROPOSAL: The contract will begin with full-time hours in July and possibly August 2026 and will shift to part-time thereafter until the end date or 1,040 hour limit is reached. The contract may not exceed 1,040 total hours.
• To determine proposal bid, please use the following calculation: Rate x 1040 = $Bid
• Bids higher than the maximum rate for Business Intelligence Analyst/Developer will be declined.
• The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Client (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 state hospital facilities; and promote and protect the state public health.
• 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.
• Contractor's Key Person under this WOC will closely with internal data management staff to identify scope of programming to update and update progress.
• Contractor's Key Person 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 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 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, and.
• Office of Health Analytics' reporting teams, who access Medicaid enrollment and claims data for the development of different enrollmen