Software Analyst (Oracle PL/SQL, Oracle reports, testing scenarios, test scripts, OBIEE)

Company:  MVP Consulting
Location: Menands
Closing Date: 18/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
HBITS-(phone number removed)

Day-to-day tasks may include but are not limited to:

Develop, test and execute Oracle SQL queries against the schema of the Production NYWIC database upon request, for program validation and data analysis

Develop and maintain a library of SQL queries that can be executed on a recurring basis with different parameters, for similar requests

Assist DOH program staff in understanding NYWIC data structures within the NYWIC modules, for developing new report requirements

Assist DOH program staff in developing new ad-hoc queries within the NYWIC Datamart OBIEE system, using defined user guidelines and additional guidance from the NYWIC Datamart team as needed

Work with NYWIC Datamart team members, program staff, and the NYWIC application vendor as needed to develop a knowledgebase of system data mappings between the NYWIC application and the Datamart, for program assistance

Participate in review and/or documentation of regression test scripts for user acceptance testing

Provide general support for user acceptance testing efforts

Work closely with ITS and Program managers to ensure adherence to standard policies and procedures

Software Analyst

Studies the software application domain, prepares software requirements, and specification documents. Liaises between the software users and the software developers. Conveys the demands of software users to the developers. Skills include: working knowledge of software technology; computer programming experience/expertise; general business knowledge; problem solving/reduction skills; interpersonal relation skills; flexibility and adaptability.

Expert 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL

84 months of experience meeting with business staff to elicit business requirements

84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports

84 months creating software documentation including functional specifications and technical specifications

48 months of experience preparing or facilitating the creation of testing scenarios and test scripts

36 months of experience creating user documentation such as user guides or training presentations

36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience

Bachelor's Degree in an Information Technology related field, from an accredited institution.

Apply Now
An error has occurred. This application may no longer respond until reloaded. Reload 🗙