Senior Oracle Programmer ( Only Consultant working with NYC DSS/HRA)

About the role

Senior Oracle Programmer role in Brooklyn, NY, working with NYC DSS/HRA on a long-term engagement. This position is for consultants only.

Responsibilities

• Develop system design specifications and prepare documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.
• Develop specifications for databases, security, and software configurations.
• Develop structured diagrams for data and logical models.
• Develop system documentation, including business-friendly descriptions for database elements and explanations of the use of the elements in the legacy systems.
• Confer with staff and users to identify and document system requirements.
• Read documents belonging to sources used in the data warehouse and create change requests.
• Work with staff (e.g., managers, senior programmers, support staff, product manager) to plan program implementation, enhancements, and changes.
• Test programming scripts and test and analyze resulting data.
• Design reports, screen layouts, and user instructions to support the requirements of the business.
• Architect, analyze, design, develop, administer, and deploy all layers of RPD.
• Provide assistance to technical support staff in the resolution of usability and business-related issues.
• Frequently contact customers and legacy system developers as required to clarify the intent of a new feature or to resolve a problem.
• Test programs and systems.
• Test system changes during release.
• Assist in quality assurance and defining testing strategy and risks.

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 reports.
• 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.
• Participating in the intake of data from both internal and outside sources.
• Expert knowledge of OBIEE 12c, Oracle Portal, Report server, and development.