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)
SkillRequired / DesiredAmountof Experience
Experience and proficiency with Oracle SQL and PL SQL against an Oracle 12c databaseRequired3Years
Experience producing reports and interacting with executive managementRequired3Years
Experience in data architecture and enterprise architectureRequired3Years
Experience working in Data Warehousing, Archiving, and ModelingRequired5Years
Experience creating documentation to support conceptual and technical design workRequired3Years
Ability to apply the Business Process Model of an organizationRequired
Strong organizational skills and ability to present relationships between dataRequired3Years
Strong written communication skills are necessaryRequired3Years
Understanding of the Curam Data ModelHighly desired3Years
Ability to act as a liaison between state agencies for technical reportsRequired
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.
NC_Resume_Template-NW-586032.doc