Senior Oracle Programmer 20

Ariel Partners; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Ariel Partners is seeking an experienced IT consultant to support full life cycle applications development across multiple platforms, with a focus on data warehouse environments. The role involves designing system specifications, creating data models, and delivering OBIEE-based dashboards and reports for state systems such as NYS Welfare Management and Medicaid processing.

Ideal candidates will guide technical teams, analyze large datasets, and communicate complex concepts clearly in English.

Qualifications

• Develop test plans and analyze large data volumes.
• Guide technical teams using business knowledge.
• Experience with NYS Welfare/Medicaid systems and NYCWAY in a technical/analytical role.
• Excellent analytical and testing skills with clear English communication.
• Lead design of program specs and software solutions; snowflake data modeling.

Responsibilities

• Develop system design specifications.
• Prepare design documents meeting system and security requirements.
• Design databases, security and software configurations.
• Create data models and metadata definitions.
• Develop system documentation and user instructions.
• Collaborate with managers, senior programmers, and product staff to plan implementations.
• Test programs and data, and design reports and dashboards.
• Architect, analyze, deploy RPD in OBIEE environments.
• Assist support staff with usability and business issues.
• Engage with customers and legacy developers to clarify feature intent.

Skills

Test plan development

Data testing

Lead design of software specs

Analytical thinking

Clear English communication

Tools

OBIEE 12c

Oracle Portal

RPD Design

Dashboards

Job description

PROJECT DESCRIPTION

DSS has a constant increased need for the provision of full systems life cycle applications development on various computer platforms, including a variety of client eligibility and recertification systems, employment/work engagement services, claims systems, etc., that are critical to the operation and functioning of DSS programs, requiring periodic refinements to maintain the applications at optimum service levels. Having a project portfolio which properly reflects the user’s business needs and DSS’ workload is crucial. Therefore, there is a need for IT consulting resources for the expanding responsibilities at DSS.

Tasks & Duties

• Develop system design specifications
• Develops and prepares documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.
• Develops specifications for databases, security, and software configurations.
• Develops structured diagrams for data and logical models.
• Develop system documentation
• Develops 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 belong to sources used in data warehouse and create change request.
• Perform System Design/Development
• Work with staff (e.g, managers, senior programmers, support staff, product manager) to plan program implementation, enhancements and changes
• Test programing 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, 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
• Perform Testing/Evaluation
• Tests programs and systems.
• Test system changes during release.
• Assist in quality assurance and defining testing strategy and risks.

MANDATORY SKILLS/EXPERIENCE

Note: Candidates who do not have the mandatory skills will not be considered

• 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.

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.