NC FAST Reports Developer

NC FAST requires the services of a Senior Specialist for Curam reports design and development for DCDEEs Subsidy Child Care program and also for NC FAST data deidentification and sub setting solutions.

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). This role analyzes and identifies reporting requirements for NC FAST Case Management System reports and develops 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 reporting solutions while enhancing existing reports to ensure that solutions continue to meet business need based on understanding the underlying data sources (databases) and interpreting requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards. These requirements are used to write complex report queries using big tables report layouts and necessary supporting data structures. Duties also include gathering and documenting requirements for new reports and changes to existing reports analyzing existing complex reports queries analyzing report and query data to fix the Report issues Developing BIRT reports (Business Intelligence Reports) as well as write effective SQL queries with large tables with good performance extraction or collection of data for performing queries writing reports and developing and analyzing operational performance metrics and reports to ensure the quality and integrity of extracts through the use of validation and audit strategies. Acquisition of this resource is essential to timely development of the NC FAST O&M projects. This position needs knowledge on Curam reporting. This position provides help with several USDA reports and helps in developing and executing archival strategies. Also this role needs to enhance and automate several reports. This position should be able to meet dashboard needs of the department using Tableau.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience programming and design of large scale web based distributed systems. Required5YearsKnowledge of Oracle Oracle Utilities ETL tools OEM tools for data deidentification and sub setting.Required5YearsExperience with SQL scripting and Relational Database modeling..Required5YearsExperience with structured system development methodologies.Required5YearsKnowledge of Business Intelligence tools such as Business Objects or BIRT Highly desired5YearsGood communication skills both oral and written and ability to maintain effective working relationships with end users and staff. Required5YearsData Warehouse experienceHighly desired5YearsPrevious experience working with State government. Highly desired0Strong experience with SQL and PL/SQL coding.Required5YearsExperience using Curam software to develop reports.Required5YearsPrevious experience working with State governmentHighly desired3YearsExperience with BitbucketHighly desired1YearsKnowledge with Data analytical tools such as Power BI and TableauDesired0
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirementQuestion2Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced outside the country. Do you accept this requirementQuestion3Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirementQuestion4All work must be performed on State premises once COVID related restrictions are lifted. Do you accept this requirementQuestion5Some local travel may be required in the performance of the work. Do you accept this requirementQuestion6LOOKING FOR IMMEDIATE HIRE: Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates available for the duration of the assignment. Do you accept this requirementQuestion7Candidates submitted above the rate of XX80.00 may not be considered. Do you accept this requirement Question8Please confirm you have thoroughly validated and attest to the accuracy of the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS009440. Do you confirm