About this role
PROJECT DESCRIPTION: Enterprise Data Warehouse enables hundreds of primarily non-technical business users across HRA, in OMB and in the HHS Connect agencies to retrieve client and case data on demand. The EDW contains 13+ TB of data from multiple HRA and NYS systems which can be used for current and/or historical and/or multi-source for ad-hoc querying, via reports, and transactional system interfaces.
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.
• Develop functional specifications and system design specifications.
• Work with functional leads to transforming and developing new requirements into existing Enterprise Data Warehouse design and implementation.
• Develop system documentation
• Develops business-friendly descriptions for database elements and values 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 implementation, enhancements and changes.
• Test and analyze resulting data.
• Install, configure, intergrade, administer, deploy, and support of Oracle Fusion Middleware product. This includes maintaining and upgrading the WebLogic Server and OFM component like Oracle Portal, OBIEE, OID, and OAM in Solaris Environment.
• 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 5 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.
• 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
• Configuring Interactive Dashboards with drill-down capabilities using Filters and Dashboard Prompts, Agent, catalog object, OBIEE Security Setup groups, access privileges
• Upgrade and maintain specification plan, design documents, concept of operations, implementation of software solutions.
• WebLogic/OBIEE and Fusion Middleware Administration, OBIEE 12c Development, Administration, SSO, OAM, integration of OID with AD, Oracle Portal, Report server, and development
• Working in a large three tier data warehouse environment
• Writing SQL and OBIEE 12c in an Oracle 19c or later environment.
If you are interested in getting more information about this opportunity, please contact Irina Rozenberg
[email protected] at your earliest convenience.
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.
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?