Senior Oracle Programmer

Delan Associates, Inc; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Delan Associates, Inc. is seeking a data warehouse/OBIEE specialist with at least four years of experience to lead design, analysis, and implementation of software solutions.

You will guide technical teams, analyze complex data sets, and create interactive dashboards within a large three-tier data warehouse. The role requires strong English communication, experience with NYS Welfare or Medicaid systems, and expertise in data modeling and reporting using OBIEE 12c.

Qualifications

• Develop and execute test plans for large data volumes.
• Apply business knowledge to guide technical teams.
• Experience with NYS Welfare Management System or NYS Medicaid/ NYCWAY in technical/analytical roles.
• Communicate complex technical concepts clearly in spoken and written English.

Responsibilities

• Lead design of program specifications and implementation of software solutions.
• Oversee requirements analysis, data modeling, and dashboard design.
• Work within a large three-tier data warehouse environment and extend data marts.

Skills

Test planning

Business analysis

NYS welfare systems

Technical communication

Requirements & design

OBIEE 12c

Data warehouse

Data modeling

Data intake

Tools

OBIEE

Job description

Required Skills

A minimum of 4 years of experience with the following skill sets:

• Developing test plans and analyzing and testing large volumes of data
• Using business knowledge to guide a technical team.
• Experience with the NYS Welfare Management System and/or NYS Medicaid Claims Processing System and/or NYCWAY in a technical/analytical capacity
• Excellent analytical and testing skills and the ability to communicate complex technical concepts in clear, non- technical oral and written English
• Leading the design of program specifications and the implementation of software solutions, requirement analysis, design, snowflake data modeling, interactive Dashboard design and complex ad hoc queries and report.
• The OBIEE Analysis, Agent and Dashboards, including RPD Design and Deployment, Catalog Management and security.
• Working in a large three tier data warehouse environment
• Design and extension of data marts, metadata, and data models. Participate in the intake of data from both internal and outside sources.
• Expert knowledge of OBIEE 12c, Oracle Portal, Report server and development.