Job ID: NC-582681 (96890211)
OWB/ODI Developer with ETL, data modeling/warehouse, BI, BO, BIRT, PL/SQL and government experience
Location: Raleigh NC (DHHS)
Duration: 12 months
Interview: In-person or webcam
Positions: 1 (1/2)
Skill Required / Desired Amount of Experience
Experience programming and design of large scale web based distributed systems. Required 7 Years
Knowledge of Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI). Required 7 Years
Experience with SQL scripting and Relational Database modeling.. Required 7 Years
Experience with structured system development methodologies. Required 7 Years
Good communication skills both oral and written and ability to maintain effective working relationships with end users and staff. Required 7 Years
Knowledge of Business Intelligence tools such as Business Objects or BIRT Highly desired 7 Years
Data Warehouse experience Highly desired 5 Years
Previous experience working with State government. Highly desired
Strong experience with SQL and PL/SQL coding. Required 7 Years
The NC Department of Health and Human Services seeks a contractor to assist with the design and implementation of NC Families Accessing Services through Technology (NC FAST). The resource 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.
The resource 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. The resource will be responsible for status reporting to the NC FAST Project Manager and for adhering to DHHS policies and procedures.