Senior Oracle PL/SQL Data Warehouse Lead (Onsite)

Sligo Software Solutions Inc.; City of Albany (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Sligo Software Solutions Inc. in New York State seeks an experienced Oracle/OBIEE professional to support NYWIC DataMart and reporting.

You will develop and validate Oracle SQL queries against production NYWIC schemas, create reusable query libraries, and help staff translate business needs into data solutions. Collaborate with the NYWIC Datamart team, program staff, and ITS to document data mappings, assist in ad-hoc reporting, and contribute to regression testing and UAT.

Qualifications

• 12+ years of experience across all software development life cycle phases.
• Proven experience with Oracle PL/SQL and Oracle databases.
• Experience with OBIEE and Oracle Reports.
• Strong documentation and reporting capabilities.
• Experience onsite and stakeholder collaboration.

Responsibilities

• Develop, test and execute Oracle SQL queries against the Production NYWIC database schema for validation and data analysis.
• Develop and maintain a library of SQL queries for recurring requests with different parameters.
• Assist program staff in understanding NYWIC data structures for report requirements.
• Assist in developing ad-hoc queries in the NYWIC Datamart OBIEE system as needed.
• Build a knowledgebase of system data mappings between NYWIC application and the Datamart.
• Participate in review/documentation of regression test scripts for UAT.
• Provide general support for UAT efforts.
• Collaborate with ITS and Program managers to ensure adherence to policies and procedures.

Skills

SQL queries

Stored procedures

Oracle PL/SQL

Data analysis

Documentation

Education

Bachelor's Degree in Information Technology or related field

Tools

OBIEE

Oracle Reports

Oracle Database

Data Warehousing

Job description

Sligo Software Solutions Inc. in New York State seeks an experienced Oracle/OBIEE professional to support NYWIC DataMart and reporting.

You will develop and validate Oracle SQL queries against production NYWIC schemas, create reusable query libraries, and help staff translate business needs into data solutions. Collaborate with the NYWIC Datamart team, program staff, and ITS to document data mappings, assist in ad-hoc reporting, and contribute to regression testing and UAT.