What are the responsibilities and job description for the Application Systems Analyst/Programmer IV - 12 Months Contract - Salem, OR - Hybrid position at Lorven Technologies?
Our client seeks an Application Systems Analyst / Programmer IV for a Contract project in Salem, OR - Hybrid . Below is the detailed requirement
Job Title : Application Systems Analyst / Programmer IV
Location : Salem, OR - Hybrid
Duration : 12 Months Contract
Description
The Client is 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.
The programmer will work with internal program staff to facilitate introductions with data owners and work team meetings.
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 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 :
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Application Systems Analyst/Programmer IV - 12 Months Contract - Salem, OR - Hybrid?
Sign up to receive alerts about other jobs on the Application Systems Analyst/Programmer IV - 12 Months Contract - Salem, OR - Hybrid career path by checking the boxes next to the positions that interest you.
Not the job you're looking for? Here are some other Application Systems Analyst/Programmer IV - 12 Months Contract - Salem, OR - Hybrid jobs in the Salem, OR area that may be a better fit.
We don't have any other Application Systems Analyst/Programmer IV - 12 Months Contract - Salem, OR - Hybrid jobs in the Salem, OR area right now.
