SAS Developer with data model/marts/discovery/capture/profiling/warehousing, ETL and Healthcare/medical/pharmacy/insurance/government experience

IN001560

 

SAS Developer with data model/marts/discovery/capture/profiling/warehousing, ETL and Healthcare/medical/pharmacy/insurance/government experience

Location: Raleigh, NC

Duration: 6 months

Positions: 1

Description:

North Carolina’s Department of the State Treasurer is seeking to fill a short term (approx.. 6 month) contractor assignment. The selected candidate will perform as a member of a project team and will work with a Business Analyst to develop Extract, Transform, and Load (ETL) SAS programs to extract data from our operational data 

sources and load into designated reporting data marts for Business Intelligence(BI) reporting. 

Responsibilities & Duties:

•Design and implement the dimensional data model for our medical, pharmacy and eligibility data files using SAS datasets

•Create and update the system design documentation for the data marts

•Perform in-depth data discovery to validate source data integrity constraints

•Develop change data capture processing

•Perform in-depth data profiling

•Develop specific exception handling processes

 

Required:

•Ability to work with business analyst and users to gather requirements and interpret these requirements into technical specifications

•In-depth understanding of dimensional modeling concepts

•In-depth understanding of the data warehousing life cycle

•Extensive SAS programming knowledge

•Excellent verbal and written communication skills

•Bachelor’s in computer science

•Minimum of (4) Four years of ETL and Data architecture experience working with large data sets

•Minimum of (3) Three years of SAS programming experience utilizing Base SAS

•General knowledge of SAS statistical functions

Preferred:

•Healthcare insurance industry knowledge 

•Strong understanding of healthcare claims processing

Posted via email from innoSoul's posterous