What are the responsibilities and job description for the Application Systems Analyst/Programmer IV position at V R Della Infotech Inc?
Job Description
Job Description
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 state hospital facilities; and promote and protect the state public health.
OIS / OHA 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 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 enrolment 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 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 :
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 :
In addition, the ideal candidate will have skills and experience in :
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.
Covendis rate card rates for an Application Systems Analysis / Programmer IV :
Minimum BR
Maximum BR
Our primary criteria are the qualifications and experience of the proposed key person. Please propose your strongest candidate, at a rate less than or equal to the maximum.
Interviews will be conducted via MS Teams. Interview times will reflect Pacific Standard Time.
Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate.
This position is approved for remote / hybrid / onsite work.
Onsite / Remote onboarding will be required for the first day.
The selected key person could potentially telecommute, as agreed to between the Agency Authorized Representative and the key person. Any decision to allow telecommuting is made with the understanding that decision will be re-evaluated by the Agency Authorized Representative on a regular basis. The key person should be available to work onsite within a reasonable timeframe.
Telecommuting will be contingent upon the key person providing his / her own adequate computer, monitor(s), Internet connection, and telephone, and be readily available during normal working hours via phone, email or instant message applications. Access to Agency systems will be provided via VPN or similar software. No hardware or additional software will be provided at the key person's home site or his / her PC.
For Services that are agreed to occur remotely that those Services will only be completed by the Key Person resourced for the Project and all work must be performed in the United States of America. Remote engagement requires Key Person to have consistent access and / or clarity for : high speed internet, cellular phone / landline phone, web camera and microphone.
OIS / ODHS operates on standard business days (Monday - Friday, 8 AM 5 PM, Pacific Standard Time, except for State of Oregon holidays and business closures) and Key Person must be available to engage with OIS / ODHS as agreed upon with OIS management.
Location Requirements
Candidate must be local or willing to commute or relocate.
No preference
Additional Location Details (City, State) :
Remote work / Telecommuting will be contingent upon the key person providing their own adequate office equipment and connectivity.
Requisition Custom Selections
Please upload the required document to the comment section of the proposal
Examples of prior work product
Relevant to the Services and Deliverables described in this Opportunity (maximum five pages).
Summary of Key Person(s) qualifications and experience
providing the requested or similar services . If Key Person(s) are the Proposer's sub-contractors, identify the sub-contracting firm and the percentage of work that will be sub-contracted out.
Description of Supplier's (organization) experience
of relevant functional business areas or programs and processes as cited in the description of this program / work in Oregon, or similar programs and process knowledge from other states.
Resumes of Key Person(s)
proposed to perform work as described in this Opportunity, including their education and work experience.
3) Supplier (Organization) References
References must be clients for whom your organization has performed similar work within the last three (3) years . Where possible, clients listed for reference should be state or local Oregon government agencies or health and human services organizations in other states . Include the client's company name, address, and contact person with telephone and email address for the contact person. The contact person must be someone who was directly involved in the work and is qualified to evaluate Proposer's performance.
3) References for each proposed Key Person
References must be for similar work performed within the last three (3) years. Where possible, clients listed for reference should be state or local Oregon government agencies or health and human services organizations in other states . Include the client's company name, address, and contact person with telephone and email address for the contact person. The contact person must be someone who was directly involved in the work and is qualified to evaluate the performance of the Key Person(s).
Background Verification
Minimum Verification Requirements
Please have the candidate complete the required form upon selection. The form is located on the dashboard.
Qualification RequiredSkillsDatabaseData AnalysisProficient (4-6 Years)YesSkillsDatabaseData WarehousingProficient (4-6 Years)NoSkillsDatabaseMicrosoft SQL ServerAdvanced (7-9 Years)YesSkillsLanguagesSQLAdvanced (7-9 Years)NoSkillsOthersCommunication skills both verbal and writtenProficient (4-6 Years)YesSkillsToolsMicrosoftOfficeProficient (4-6 Years)Yes
