Curam Reports Developer

Curam Reports DeveloperNC 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.RequirementsStrong understanding of relational databases (including tables, views, indexes, table spaces, users, grants)Strong experiences in design, build, and manage data warehouses5 or more years Oracle PL/SQLStrong 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 workersStrong working knowledge of Build data analytics solutions using Azure Synapse serverless SQL poolsDemonstrated 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 CloudExperience configuring, designing, developing and testing dash boards using Power BILead and mentor other reporting developers in data integration efforts, utilizing ETL design patterns, error handling and configurationsRequired / Desired SkillsExperience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI)Experience programming and design of large scale web based distributed systems - Required - 5 - YearsExperience with SQL scripting and Relational Database modeling - Required - 5 - YearsExperience with structured system development methodologies - Required - 5 - YearsAbility to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options. - RequiredAbility to organize, prioritize, and follow complex and/or detailed technical procedures. - RequiredPrefer experience with Business Intelligence tools such as Business Objects or BIRT - Highly desired - 2 - YearsPrefer Data Warehouse experience - Highly desired - 2 - YearsExperience with the Cúram product. - Highly desired - 4 - YearsStrong SQL Skill