Hybrid SQL Developer - Oracle/OBIEE Data Mart

VGroup Inc; Village of Menands (NY); Hybrid; USD 90,000 - 150,000; Part time

Job summary

VGroup Inc. is seeking a Software Developer for the NYWIC DataMart project in Menands, NY. This contract role supports the NYWIC MIS-EBT system with a .NET/Oracle-based platform and an emphasis on Oracle SQL, OBIEE, and data reporting.

Responsibilities include building and validating SQL queries, developing ad-hoc reports, and collaborating with DOH staff and vendors to map data. 40-hour weeks, hybrid on-site work in Menands.

Qualifications

• 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL.
• 84 months of experience meeting 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 of experience creating software documentation including functional specifications and technical specifications.
• 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance.
• 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 is required.

Responsibilities

• Develop, test and execute Oracle SQL queries against 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 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.

Skills

Oracle PL/SQL

SQL Queries

OBIEE

Business Requirements Elicitation

Software Specifications

Performance Tuning

Test Script Development

User Documentation

Education

Bachelor's Degree in Information Technology or related field

Tools

Oracle Database

OBIEE / Oracle BI

Job description

VGroup Inc. is seeking a Software Developer for the NYWIC DataMart project in Menands, NY. This contract role supports the NYWIC MIS-EBT system with a .NET/Oracle-based platform and an emphasis on Oracle SQL, OBIEE, and data reporting.

Responsibilities include building and validating SQL queries, developing ad-hoc reports, and collaborating with DOH staff and vendors to map data. 40-hour weeks, hybrid on-site work in Menands.