Job ID: NC-521150 (96390425)
OWB/ODI ETL Developer with SQL, data modeling, BO/BIRT, data warehouse/DW, Curam and government experience
Location: Raleigh NC (DHHS)
Duration: 12 months
Skill Required / Desired Amount of Experience
Experience programming and design of large scale web based distributed systems. Required 5 Years
Experience using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI). Required 5 Years
Experience with SQL scripting and Relational Database modeling.. Required 5 Years
Experience with structured system development methodologies. Required 5 Years
Good communication skills both oral and written and ability to maintain effective working relationships with end users and staff. Required
Experience with Business Intelligence tools such as Business Objects or BIRT Highly desired 5 Years
Data Warehouse experience Highly desired 2 Years
Cúram experience Highly desired 2 Years
Previous experience working with State government. Highly desired
The NC Department of Health and Human Services seeks contractor to assist with the design and implementation of NC Families Accessing Services through Technology (NC FAST) reports using Cúram Software, Inc. products. Employee will analyze and identify reporting requirements for NC FAST Case Management System 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. Employee 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 and changes to existing 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. Employee will be responsible for status reporting to the NC FAST Project Manager and for adhering to DHHS policies and procedures.