Oracle Developer/Data Architect with PL/SQL, Date Warehouse, Archiving, Data Modeling and Curam Data Model experience

Job ID: NC-586032 (91160213)

Oracle Developer/Data Architect with PL/SQL, Date Warehouse, Archiving, Data Modeling and Curam Data Model experience

Location: Raleigh NC (DHHS)
Duration: 12 months
Interview: In-person or webcam
Positions: 1 (1/2)

Skill Required / Desired Amount of Experience
Experience and proficiency with Oracle SQL and PL SQL against an Oracle 12c database Required 3 Years
Experience producing reports and interacting with executive management Required 3 Years
Experience in data architecture and enterprise architecture Required 3 Years
Experience working in Data Warehousing, Archiving, and Modeling Required 5 Years
Experience creating documentation to support conceptual and technical design work Required 3 Years
Ability to apply the Business Process Model of an organization Required
Strong organizational skills and ability to present relationships between data Required 3 Years
Strong written communication skills are necessary Required 3 Years
Understanding of the Curam Data Model Highly desired 3 Years
Ability to act as a liaison between state agencies for technical reports Required

The Department of Health and Human Services (DHHS) requires a Data Engineer on the Oracle Database Platform to support the development and implementation of North Carolina Families Accessing Services through Technology (NC FAST). Primary responsibilities include technical oversight and development of the redesign of the Data Warehouse reporting environment based on the Cúram application schema. This position is expected to provide Oracle development technical support for other team members and serve as a mentor. Identifying and refining data requirements, database design, database migration planning, construction of configurable ETL frameworks, and ensuring adherence to defined development standards. In addition to reporting duties, this position also works closely with the NC FAST Quality Control (QC) team to assist in all data related matters when audits and evaluations requiring reports are needed. This QC assignment will require face to face meetings with State and Federal auditors where requirements are gathered, and reporting data is explained. Business requirements must be interpreted into logical queries and written to provide the data for reports that are provided for the audits. Requirements and design documentation must be created and maintained as part of this reporting and QC work.



Leave a Reply

Your email address will not be published. Required fields are marked *

17 − 16 =

%d bloggers like this: