Business Intelligence Analyst/Developer

Job Description

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.

About the Role

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 state hospital facilities; and promote and protect the state public health.

Responsibilities

• Work closely with internal data management staff to identify scope of programming to update and update progress.
• Work with internal program staff to facilitate introductions with data owners and work team meetings.
• 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, ETLs, system and database management processes, data quality, security, queries, reporting environment.
• 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 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 strategic goals.
• 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/ Python 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.

Requirements

• 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 strategy.

Skills

• SAS programming language.
• Experience using Jupyter Notebooks.
• Data Warehousing.
• Good communication skills.