The NC Department of Health and Human Services seeks contractor (approx. 12 months) to assist with the design and implementation of NC Families Accessing Services through Technology (NC FAST) reports using Cúram Software, Inc. products. 

The selected candidate will:

•

Analyze and identify reporting requirements for NC FAST Case Management System reports

•

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

•

Enhance existing reports to ensure that solutions continue to meet business needs

•

Possess understanding of underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues

Other duties include but are not limited to:

•

Gathering and documenting requirements for new reports and changes to existing reports

•

Extraction or collection of data for performing queries and writing reports

•

Developing and analyzing operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies.

Develop appropriate diagnostic and/or tracking data via reports and dashboard these include but are not limited to:

•

Report queries

•

Report layouts

•

Any necessary supporting data structures

•

Extract transformation load required to populate the data structure.

This person will be responsible for status reporting to the NC FAST Project Manager and for adhering to DHHS policies and procedures.

 

Contractor Must meet the following requirements:

•

Minimum three (3) or more years 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 Business Intelligence tools such as Business Objects or BIRT 

•

Experience with structured system development methodologies

•

Excellent communication skills both oral and written

•

Ability to maintain effective working relationships with end users and staff. 

Preferred Experience:

•