NC FAST OM Reports Developer

NC FAST requires a reports developer to analyze and identify reporting requirements for NC FAST Operations and Maintenance activities.

The NC Department of Health and Human Services seeks contractor to assist with the design and implementation of NC Families Accessing Services through Technology (NC FAST) reports using C ram Software Inc. products. Employee will analyze and identify reporting requirements for NC FAST Case Management System reports and develop recommendations to effectively report data of mid to high level complexity 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 needs. Employee must understand the underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards. These include but are not limited to: report queries report layouts any necessary supporting data structures and Extract Transformation Load required to populate the data structure. Duties also include gathering and documenting requirements for new reports and changes to existing reports extraction or collection of data for performing queries and writing reports and developing and analyzing operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies. Employee will be responsible for status reporting to the NC FAST Project Manager and for adhering to DHHS policies and procedures.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience in using Oracle Oracle Utilities ETL toolsRequired5YearsExperience with PL/SQL scripting and Relational Database modelingRequired5YearsExperience with structured system development methodologiesRequired5YearsAbility to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options.Required5YearsAbility to organize prioritize and follow complex and/or detailed technical procedures.Required5YearsExperience with Business Intelligence tools such as Business Objects or BIRT Required5YearsExperience with Agile (Scrum Kanban or SAFe) developmentHighly desired2YearsData Warehouse experienceHighly desired2YearsExperience with developing dashboards with Power BI and Azure SynapseHighly desired2YearsFamiliarity with Amazon RedShift & TableauDesired2YearsExperience with Dell Boomi Desired2YearsC ram experience Desired2Years
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 completed on site at the clients discretion. Do you accept this requirementQuestion5Some local travel may be required in the performance of the work. Do you accept this requirementQuestion6Please 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 may not be considered. Do you accept this requirementQuestion8Please list candidates email address HERE that will be used when submitting ERTR.Question9Please 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 confirmQuestion10Please provide candidates current location (City and State) NOT a Yes or No responseQuestion11Please list all the certifications candidate has around ORACLE Power BI Synapse Agile and others.