Application Systems Analyst/Program

Role: Application Systems Analyst/Program
Duration:11Months
Location: Hybrid

Description:
.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.
.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 Microsoft 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 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 4 years.
. 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 2 years.
.Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of 2 years. (Proof of certification must accompany application.)
.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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.