Application Support-SAS, PL/SQL

Location: Albany, NY
Date Posted: 02-04-2013

Position:          Application Support-SAS, PL/SQL
Location:          Albany, NY
Duration:          24+ months
Rate:                Open
Interview:         Phone
# Positions: 1
Position Description/Responsibilities:
This position will support Psychiatric Services Clinical Knowledge Enhancement System (PSYCKES) application using SAS, PL/SQL and various other programming tools.  This individual will be expected to provide expertise in the following activities:

  • Maintain and enhance the existing PSYCKES applications. Review business requirement documents developed by the Analysis team. Review and interpret the SAS code which was used to analyze newly proposed indicators. Use the logic in the SAS code as the basis for development of new PL/SQL processes which will load data to the PSYCKES Datamart.
  • Develop new Extraction, Transformation and Load (ETL) processes in consultation with the data warehouse group. Optimize ETL processes to minimize load time. Structure data to conform to the PSYCKES architecture. Collaborate with the evaluation groups to ensure that the data are modeled as needed to support the existing PSYCKES applications and other reporting requirements. Review existing ETL processes to determine if further optimization can be achieved and review latest techniques for ongoing performance tuning.
  • Develop analytical processes to examine both source and target data to improve data quality and integrity. Create an executive dashboard to display metrics on data quality from the various data sources. Design high level reports which track data quality over time by data source and type. Provide drill-down capabilities so managers can implement initiatives to improve the quality and completeness of those data.
  • Develop usage tracking reports which will be used to (i) assess which portions of the application are under-utilized, and (ii) support statistical analysis of the impact of usage on fiscal and clinical outcomes.
  • Research national best practices for data modeling, interoperability, security, and data sharing. Use that knowledge to propose architectures and application programming interfaces which support national Electronic Health Record (EHR) and Regional Health Information Organization (RHIO) efforts.

Position Requirements/Technical Skills:
Mandatory Requirements:

5 to 7 years experience in the usage and support of a collection of development platforms, technical architectures, or business applications and products that run on those platforms, beyond that of a Programmer. 
The following Requested(Desirable) Qualifications are not mandatory and candidates that do not fit all of the following,  are still strongly  encouraged to apply.

  1. 60 Months Demonstrated work experience with base SAS skills as well as statistical expertise.
  2. 60 Months Demonstrated work experience with Oracle 10G/11G.
  3. 48 Months Demonstrated work experience with PL/SQL.
  4. 48 Months Demonstrated work experience interpreting and analyzing complex business requirements and building the logic within an application's code to meet those requirements.
  5. 24 Months Demonstrated work experience with Health Care data such as Medicaid, Pharmacy, and HIPPA protected.
  6. 24 Months Demonstrated work experience with large administrative data sets ( > 10 million rows).
  7. 24 Months Experience using data cleansing techniques and familiarity with ETL Data Warehouse processes.
  8. BA/BS Degree.

Sam Merigala
DEW Softech, Inc
302-763-1DEW X101
877-DEW-9566 (F)
this job portal is powered by CATS