*Role:* Oracle Reports/ Data Warehouse Developer
*Start Date:* 04/15/2024
*End Date:* 03/10/2025
*Location: *Durham, NC
*Interview type: *Webcam Interview Only
*Complete Description:*
*Medicaid Reports Dev Required Skills:*
* Experience 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 Experience with structured system development methodologies Required 5 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 2 Years
* Prefer Data Warehouse experience Highly desired 2 Years
* Experience with the Cúram product.
Highly desired 4 Years
* Strong SQL Skill Highly desired 2 Years
*Medicaid Reports Dev Essential Duties & Responsibilities:*
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.
Job Types: Contract, Temporary
Salary: $52.
94 - $60.
00 per hour
Schedule:
* Monday to Friday
Application Question(s):
* This is a W2 role, are you okay with that?
Experience:
* Relational Database modeling: 5 years (Preferred)
* Cúram product: 4 years (Preferred)
* Data warehouse: 3 years (Preferred)
Ability to Relocate:
* Durham, NC: Relocate before starting work (Required)
Work Location: In person