We have a position for a Application Systems Analyst/Programmer IV with one of our clients in Salem, OR for an initial contract duration of 10 months. No third party candidates considered for this position.
Please contact at (678) 749-7244
Local Candidates Preferred. Video Interview is mandatory.
The Office of Information Services (OIS) is a shared service provider for the client. OIS provides the technology systems and services that support more than 18,000 client 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.
Client 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.
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 client 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 client 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:
- Woking 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
- 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.