Oracle and Data Warehousing experience - North Carolina –Dept of Health and Human Services

Description:

*** Task Order 1 of 3 ***

The Department of Health and Human Services (DHHS) is seeking to fill a short term (approx. 12 month) contractor assignment for a Curam Reports Developer to assist with design and development of components to support required reports for North Carolina's Health Benefit Exchange (HBE) within NC Families Accessing Services through Technology (NC FAST) Program using Cúram Software. Position will analyze and identify reporting requirements for NC FAST HBE reports and develop recommendations to effectively report data of mid to high level complexity related to varied business metrics and for designing, coding, testing, debugging, and documenting reporting solutions, while enhancing existing reports to ensure that solutions continue to meet business needs. The selected candidate must understand the underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards.

These include but are not limited to: report queries, report layouts, any necessary supporting data structures, and Extract Transformation Load required to populate the data structure.

Duties also include gathering and documenting requirements for new reports, extraction or collection of data for performing queries and writing reports, and developing and analyzing operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies.

The selected candidate will be responsible for status reporting to the NC FAST Project Manager and for adhering to DHHS policies and procedures.

Knowledge, Skills, and Abilities Requirements:

Required:
• Minimum three (3) years of experience programming and design of large scale web based distributed systems
• Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI), SQL scripting and Relational Database modeling
• Experience with structured system development methodologies
• Good communication skills, both oral and written, and ability to maintain effective working relationships with end users and staff.

Highly Preferred:
• Experience with Business Intelligence tools such as Business Objects or BIRT
• Experience with Data Warehouse
• Experience with Cúram V6

Other Requirements:

All work must be performed on State premises.
Some local travel may be required.

*** NO PHONE CALLS PLEASE - Vendors will be contacted if an applicant interview is desired.

Evaluation Criteria:

1. Hourly Rate
2. Applicable Skills and Experience
3. Interview Evaluation