Hybrid/Local BO/BIRT/Oracle ETL Developer

NC FAST requires the services of a report developer to provide business and systems analysis, modeling, design, and programming for FNS and SNAP reports development and maintenance operations using ORACLE, and PL\SQL programming technologies.

The NC Department of Health and Human Services seeks a contractor to assist with implementation and maintenance of data extracts, ETL batch jobs, and reports, for NC Families Accessing Services through Technology (NC FAST) using Cram Software product and Oracle. The selected candidate will analyze and identify reporting requirements for NC FAST Case Management System reports and implement recommendations to effectively report data of mid to high level complexity. This is related to varied business metrics and for designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, while enhancing existing data extracts and reports to ensure that solutions continue to meet business needs.

Experience in using Oracle, Oracle Utilities, ETL tools Required 5 Years Experience with PL/SQL scripting and Relational Database modeling. Required 5 Years Experience with structured system development methodologies Required 5 Years Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options. Required 5 Years Ability to organize, prioritize, and follow complex and/or detailed technical procedures. Required 5 Years Experience with Business Intelligence tools such as Business Objects or BIRT Required 5 Years Experience with Agile (Scrum, Kanban, or SAFe) development Required 2 Years Data Warehouse experience Required 2 Years Experience with developing dashboards with Power BI and Azure Synapse Highly desired 2 Years Familiarity with Amazon RedShift & Tableau Desired 2 Years