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

North Carolina Families Accessing Services through Technology (NCFAST) is seeking a highly skilled Oracle PL / SQL and Microsoft Azure Synapse developer to provide business and system analysis, modeling, design, developing and maintaining Medicaid reporting solutions and semantic models. This role will work closely with NC FAST internal business team and Medicaid team to develop new reports and maintain the reporting code for some of the enhancements based on the backlog of change requests from the business and help fix some of the defects from the backlog as well.

Requirements

Strong understanding of relational databases (including tables, views, indexes, table spaces, users, grants)

Strong experiences in design, build, and manage data warehouses

5 or more years Oracle PL / SQL

Strong working knowledge Business intelligence and reporting tool (BIRT) and the understanding of the underlying data and tables in IBM Curam framework for the product delivery cases and the financial part to support all kinds of reports for case workers

Strong working knowledge of Build data analytics solutions using Azure Synapse serverless SQL pools

Demonstrated experience with Azure Synapse Analytics, including Synapse pipelines, SQL pools, and Spark pools.

1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud

Experience configuring, designing, developing and testing dash boards using Power BI

Lead and mentor other reporting developers in data integration efforts, utilizing ETL design patterns, error handling and configurations

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

Experience programming and design of large scale web based distributed systems

Required

Years

Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI),

Required

Years

Experience with SQL scripting and Relational Database modeling

Required

Years

Experience with Experience with structured system development methodologies

Required

Years

Ability to develop relationships / partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options.

Required

Ability to organize, prioritize, and follow complex and / or detailed technical procedures.

Required

Prefer experience with Business Intelligence tools such as Business Objects or BIRT

Highly desired

Years

Prefer Data Warehouse experience

Highly desired

Years

Experience with the C ram product.

Highly desired

Years

Strong SQL Skill

Highly desired

Years

Questions

No.

Question

Question1

Absences 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 requirement?

Question2

Please list candidate's email address HERE that will be used when submitting E-RTR.

Question3

Please 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.

Question4

Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?

Question5

Vendor 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?

Question6

Candidates submitted above the rate of - may not be considered. Do you accept this requirement?

Question7

All work will be completed onsite at the manager's discretion. Do you accept this requirement?

Question8

Local candidates are preferred. Please note the candidates current city and state.