Senior Oracle PL/SQL Consultant — Onsite Data Warehouse

Sligo Software Solutions; Village of Menands (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Sligo Software Solutions seeks a senior Oracle SQL/OBIEE professional to support the NYWIC DataMart and MIS-EBT reporting. You will design, test, and optimize SQL queries against the NYWIC production schema and collaborate with program staff and the vendor to ensure accurate reporting.

Responsibilities include building reusable SQL libraries, assisting with data mappings, and reviewing test scripts for UAT, delivering reliable data insights to administrators and regulators.

Qualifications

• 12+ years of experience across the software development lifecycle.
• Onsite work only; able to work 100% in office.

Responsibilities

• Develop, test and execute Oracle SQL queries against the NYWIC production schema.
• Maintain a library of reusable SQL queries with parameters for recurring requests.
• Assist program staff in understanding NYWIC data structures and requirements.
• Develop ad-hoc queries within the OBIEE environment per guidelines.
• Collaborate with NYWIC Datamart team, program staff and vendor on data mappings.
• Participate in regression test reviews and support user acceptance testing.
• Support ITS and Program managers to ensure policy compliance.

Skills

Oracle SQL

PL/SQL

Data analysis

Documentation

Communication

Education

Bachelor's Degree in IT or related field

Tools

OBIEE

Job description

Sligo Software Solutions seeks a senior Oracle SQL/OBIEE professional to support the NYWIC DataMart and MIS-EBT reporting. You will design, test, and optimize SQL queries against the NYWIC production schema and collaborate with program staff and the vendor to ensure accurate reporting.

Responsibilities include building reusable SQL libraries, assisting with data mappings, and reviewing test scripts for UAT, delivering reliable data insights to administrators and regulators.