Curam Reports Developer

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, development, and maintenance of Medicaid reporting solutions and semantic models. This role will work closely with the NC FAST internal business team and the 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

·Must be a local candidate and be able to come to the office on a need basis

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

·Strong experience in designing, building, and managing data warehouses

·5 or more years of Oracle PL/SQL

·Strong working knowledge of 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 building 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 dashboards using Power BI

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