The North Carolina Department of Health and Human Services seeks a senior ETL and reports developer to support implementation and maintenance of data extracts, ETL batch jobs, and reports for NC FAST, using the Cúram Software product and Oracle. The role involves business and systems analysis, modeling, design, and programming for FNS/SNAP reporting operations. The developer will analyze reporting requirements for the NC FAST Case Management System and implement recommendations for reports involving business metrics of mid to high complexity. Work includes designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, as well as enhancing existing extracts and reports to meet ongoing business needs. The role requires understanding underlying database sources and translating business requirements into analysis of operational issues and appropriate diagnostic or tracking data through reports and dashboards. Duties include gathering and documenting requirements for new and changed extracts and reports; developing complex queries against large tables containing CLOB/XML data, supporting data structures, and report layouts; and writing effective SQL queries that perform well against large tables. The developer will also analyze existing queries and reports, investigate and resolve issues, extract data, develop and analyze operational performance metrics, and help ensure extract quality and integrity through validation and audit strategies. The position includes responsibility for 24x7 on-call support on a rotation. The role is described as a 12-month contract, located remotely with an expectation of being local to Raleigh, NC and attending onsite once a month or quarterly.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Career Level
Senior
Education Level
No Education Listed