Application Systems Analyst/Programmer –Remote

Generis Tek Inc; Salem (OR); Remote; USD 70,000 - 110,000; Full time

Job summary

An innovative firm is seeking a talented Application Systems Analyst/Programmer to join their remote team. This role is pivotal in modernizing the ETL process for the Health Analytics Library, ensuring the seamless migration of data to Azure cloud servers. You'll collaborate with internal data management staff and program teams to enhance data logic and improve analytical capabilities. If you are passionate about data analysis and programming, this is an exciting opportunity to make a meaningful impact in the healthcare sector while working in a supportive and dynamic environment.

Qualifications

• Mid-Senior level role requiring SQL programming and advanced data analysis skills.
• Experience with SAS data management is a plus.

Responsibilities

• Analyze and improve HAL data system and ETL processes.
• Collaborate with project team to gather system and data requirements.

Skills

SQL programming

Advanced data analysis skills

Experience using MS DevOps

Tools

MS DevOps

SAS

Job description

Direct message the job poster from Generis Tek Inc

Building Teams that shape Generis Tek's future

Please contact: To discuss this amazing opportunity, reach out to our Talent Acquisition Specialist Abhinav Chakraborty at email address [e-mail] can be reached on # 630-576-1925.

We have Contract role Application Systems Analyst/Programmer – Remote for our Salem OR. Please let me know if you or any of your friends would be interested in this position.

Location: Remote 100%

Project Duration: 10+ Months

Job Summary:

The Office of Information Services (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 client facilities; and promote and protect client health.

OIS/OHA are seeking a SQL programmer to help modernize our ETL process for a reporting data mart named HAL (Health Analytics Library). This work anticipates the 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 work with internal data management staff to identify the 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 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 enrollment 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 per-capita rates of reimbursement for health care services provided by Coordinated Care Organizations (CCOs) 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:

• Analyzing the existing HAL database solution and environment, identifying any refinements or rework to HAL architecture, dataflows, governance or management processes, and developing a roadmap for HAL future state.
• Reprogramming HAL ETL code, currently written in legacy SAS language, into SQL language, to prepare HAL for migrating to the OHA ODE (Oregon Data Environment) cloud Azure environment (NOTE: The migration to the 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).
• Gathering and documenting requirements, developing and testing other improvements to the HAL data logic, including:
• Updating claim data grouping categories used predominantly by the Office of Actuarial and Financial Analysis (OAFA) team for rate capitation analyses, to reflect updates to 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 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:

• 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 MS Structured Query Language (“SQL”) stack 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 and experience:

• SQL programming
• Advanced data analysis skills.
• Experience using MS DevOps or other code management tools.

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

• Experience with SAS data management.

Seniority level: Mid-Senior level

Employment type: Contract

Job function: Information Technology

Industries: IT Services and IT Consulting