Application Systems Analyst/Programmer IV

Job Title : Application Systems Analyst / Programmer IV

Job # : 11124-25

Location : Oregon, Remote if have own equipment and internet

Length : 10 months or 1,040 work hours

We 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.

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 our 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 :

• Our 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

o Performing other coding improvements needed by OAFA team users and other HAL users to improve analytical value and capabilities of HAL data or reflect changes in Medicaid eligibility, program, 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 our project team members (PM, Client, 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 language / stored procedures, by :

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

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

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

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

Required skills and experience :

SQL programming

Advanced data analysis skills.

Experience using Microsoft DevOps or other code management tools.

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

Experience with SAS data management.

Good communication skills

Covendis rate card description for an Application Systems Analysis / Programmer IV :

Full-time professional work experience in Information Technology.

Substitutions :

Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.)

Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years.

Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.)

Two (2) years of work experience as an Application Systems Analysis / Programming-Specialist; Application Systems Analysis / Programming-Intermediate; Application Developer-Senior may substitute for all of the required experience.

Pre-Employment Requirement

All employment offers are contingent upon successful completion of our pre-employment screening that may include drug testing, background / criminal check, and if applicable, must meet eligibility requirements for access to classified information.

APR Staffing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

About APR Staffing

APR Staffing was born from the merger of two well-respected technical staffing firms in Portland. ieSolutions, founded in 2002, enjoyed an impressive reputation as one of the largest locally-owned and most respected technical staffing companies. Professional Resource Group, aka Data Resource Group, founded in 2009, also earned regional acclaim for being a fast-growing and highly-motivated professional staffing agency. Both companies have been recent award winners for the Portland Business Journal's Fastest-Growing Private Companies. The two firms, now as APR Staffing, make for one of the fastest-growing and most-respected professional and technical staffing companies in Oregon and Southwest Washington.

Collaborating with our customers, we augment their workforce with technical and administrative professionals. We provide only high-caliber, professional-grade resources throughout the Pacific Northwest.