Remote - Data Warehouse ETL SAS DI Developer

Hi

Please find my direct client job requirement for your consideration.

Title: Data Warehouse ETL SAS DI Developer

Location: Remote

Duration : 12 months

Job Description:

DHHS is seeking a Senior-level contractor for extract, transformation, and load (ETL) development and reporting for a data warehouse application with a back end of Oracle.

Complete Description:

The NC DHHS Application Portfolio Management Office (APMO) Client Services Data Warehouse (CSDW) Division of Child Development (DCDEE) Developer will provide advanced lead technical support and ETL development activities for data integration activities and reporting.  The position requires experience in systems development tools and techniques, SQL development and scripting.  The DCDEE Developer will utilize both business process and information technology (IT) background to analyze business processes and determine automation conversion activities. The individual will be a key player to support the current backlog and future data warehouse reporting needs for DCDEE.   

The DCDEE Developer will work with existing CSDW staff to support the ETL and reporting needs for DCDEE.  Duties include:

•          Collaborate with CSDW staff on supporting and completing the existing backlog and future enhancements. 

•          Support process owners for DCDEE related issues and monitor project progress. 

•          Complete regular process reviews with CSDW team members on changes needed to existing and future processes.

•          Complete modifications to existing DCDEE ETL and reporting processes within set controls and meeting all the compliance requirements.

•          Support the CSDW team on any other DCDEE project related deliverables.

The DCDEE Developer should have the following qualifications:

•          Understand the concepts, best practices, and functions to support a data warehouse driven reporting solution.

•          Have strong SAS Data Integration Studio (SAS DI) skills. (Must have)

•          Have strong experience with Unix scripting.  (Must have)

•          Have strong Oracle SQL/PL SQL skills. (Must have)

•          Have experience with Boomi and API technologies.  (Nice to have.)

•          Have experience with SAP Business Objects Webi reporting tool.  (Nice to have.)

•          Have an IT background with a well-rounded understanding of all aspects of business process with analytical and proactive problem-solving skills. 

•          Be a Team Player, enthusiastic to understand complex business processes and perform under pressure.

•          Proven ability to work in a multi-disciplinary and fast paced environment.

•          Detail oriented and ability to learn and work independently as well as in a team environment.

Required / Desired Skills