NC FAST Medicaid Reports Dev

NC FAST requires the services of a Curam Reports Developer to assist with reports development activities for NC FAST Medicaid Projects

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) reports. The primary purpose of this position is to coordinate analysis and identification of reporting requirements for NC FAST Case Management System reports used by internal and external customers to make decisions that can have a significant impact on the effectiveness and accuracy in the administration of the programs. The Reports Developer is responsible for developing 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. The Reports Developer must understand the underlying data sources (databases) as well as interpret the requirements being provided by the business in order to review and analyze operational issues and devise the best way to 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 review of the work of others to gather and document requirements for new reports and changes to existing reports extraction or collection of data for performing queries and writing reports and to develop and analyze operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies. This position will also work in developing user friendly dashboards using Tableau.

The ideal candidate for this position demonstrates technical knowledge which may include but is not limited to using Oracle Oracle Utilities ETL tools PL/SQL and Relational Database modeling as well as good experience with Power BI Business Objects or BIRT and experience with structured system development methodologies. Knowledge of Curam software and/or AWS cloud would be an advantage for the candidate. Good communication skills both oral and written and ability to maintain effective working relationships with end users and staff.

Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience programming and design of large scale web based distributed systems Required5YearsExperience in using Oracle Oracle Utilities ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI)Required5YearsExperience with SQL scripting and Relational Database modelingRequired5YearsExperience with Experience with structured system development methodologiesRequired5YearsAbility to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options.Required0Ability to organize prioritize and follow complex and/or detailed technical procedures.Required0Prefer experience with Business Intelligence tools such as Business Objects or BIRT Highly desired2YearsPrefer Data Warehouse experienceHighly desired2YearsExperience with the C ram product.Highly desired4YearsStrong SQL Skill Highly 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 requirementQuestion2Please list candidates email address HERE that will be used when submitting ERTR. Question3Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment. Question4Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement Question5Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement Question6Candidates submitted above the rate of XX90.00 may not be considered. Do you accept this requirementQuestion7All work will be completed onsite at the managers discretion. Do you accept this requirementQuestion8Local candidates are preferred. Please note the candidates current city and state.