Overview
Skills
Job Details
Job Title: NC FAST Medicaid Reports Dev (779769) in RTP, Durham, NC - Hybrid
Duration: initial 6 Months+
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
Strong understanding of relational databases (including tables, views, indexes, table spaces, users, 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 the 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.
Skill | Required / Desired | Amount of Experience | No of years of experience you have |
Experience in programming and design of large-scale web-based distributed systems | Required | 5 Years | |
Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI), | Required | 5 Years | |
Experience with SQL scripting and Relational Database modeling | Required | 5 Years | |
Experience with structured system development methodologies | Required | 5 Years | |
Ability to develop relationships/partnerships with customers by responding to needs and exhibiting a 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 | 2 Years | |
Prefer Data Warehouse experience | Highly desired | 2 Years | |
Experience with the Cram product. | Highly desired | 4 Years | |
Strong SQL Skills | Highly desired | 2 Years | |
Q1: 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? (Yes/No) | |||
Q2: All work will be completed onsite at the manager's discretion. Do you accept this requirement? (Yes/No) | |||
Q3: Local candidates are preferred. Please note the candidate's current city and state. |