Show more filters
Job Type   /   Job Level
Full-time   /   Junior Executive
Job Location
Albany, NY
A free Jobstore account is required to proceed to the employer site.
Location: Albany, NY (Hybrid – Onsite & Remote)

Contract Duration: 5 years (engagements may extend up to 3 additional years)

Start Date: April 28, 2026

Clearance: Background Investigation Required

Client: New York State Office of the State Comptroller (OSC)

Citizenship Requirement: Must be a U.S. citizen

Position Overview

We are seeking highly skilled IT consultants to support the New York State Office of the State Comptroller’s Data Analytics Initiative and FirstNY Data Warehouse Reporting and Analytics System. These roles will play a key part in enhancing statewide transparency, supporting fraud/waste/abuse detection, improving audit and performance analysis, and modernizing data-driven systems.

Consultants will work within OSC’s Chief Information Officer Division, supporting both current and future data analytics and warehousing needs. Multiple roles will be staffed throughout the contract period.

Key Responsibilities

  • Develop complex reports using Oracle BI Publisher
  • Build dashboards, analyses, and repository objects (RPD) in OBIEE within a MUDE environment
  • Develop ETL processes using tools such as Attunity Compose, Informatica, Talend, Pentaho, or Oracle Data Integrator
  • Develop robust SQL/PLSQL solutions within Oracle environments
  • Model data structures for analytics and reporting
  • Tune SQL queries for performance

Required Qualifications

  • 1+ year Oracle BI Publisher report development using Microsoft Word templates
  • 3+ years OBIEE MUDE experience including RPD, dashboards, and analyses
  • 3+ years ETL development using enterprise ETL tools
  • 5+ years Oracle SQL & PL/SQL development
  • 2+ years SQL performance tuning in Oracle
  • 3+ years data modeling for analytics and reporting
  • Must be available to start April 28, 2026

Benefits

Actual compensation will be determined based on experience and qualifications as well as internal equity and alignment with market data.

At Enlightened, we pride ourselves on offering a comprehensive and industry-competitive benefits package to our full-time employees. Our benefits include:

  • Medical/Dental/Vision Insurance with Health Savings Accounts (HSA)
  • Flexible Spending Accounts (FSA)
  • 401(k) Retirement Plan
  • Paid Holidays, Vacation, & Sick Leave
  • Professional Training & Development Reimbursement

Please note, these benefits are available exclusively to full-time employees of Enlightened.

Equal Opportunity Statement

Enlightened is proud to be an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, disability, or any other federal, state, or local protected class.
A free Jobstore account is required to proceed to the employer site.
Jobs in United States of America   »   Jobs in New York   »   Jobs in Albany   »   Data Warehouse Developer

More jobs

People also search