Knowledge Builders Inc. · Albany, NY

Salary
Posted
Jul 12, 2026
Location
Albany, NY
Last confirmed open
Jul 21, 2026

What this job asks for AI summary

A senior data modeling role supporting a statewide public nutrition program's enterprise data warehouse. The primary work involves designing and maintaining conceptual, logical, and physical data models — including star and snowflake schemas — while also providing backup support for ETL pipelines built in Informatica and OBIEE-based reporting. The position suits a seasoned database architect with deep Oracle and dimensional modeling experience who can also mentor teammates and engage in requirements gathering.

Senior level · 7+ years · Albany-Schenectady-Troy, NY · Bachelor's required · Contract

Must have (7)
star schema or Snowflake SchemaErwin · 84+ yrsOracle · 84+ yrsSQL · 84+ yrsOBIEE · 72+ yrsInformatica · 48+ yrsETL · 48+ yrs

“or” means any one of them counts — you don't need all of them.

We read this from the posting text with AI. Skim the description below before ruling yourself out.

How this req sits in the market our data

Roughly 1 people in the Albany-Schenectady-Troy, NY area plausibly meet what this posting asks for (database architects). range 1–1

Applicant volume Light — Few people clear these requirements, so an application that does clear them gets looked at. Worth applying to even if you miss a nice-to-have.

What won't set you apart
SQL90%Erwin72%ETL62%Oracle42%

Most people in this occupation already list these. Still required — just not what gets you shortlisted.

What the occupation pays Median $111,121 (middle half $90,119–$148,178).

Estimated from BLS employment for this occupation and area, per-skill prevalence across our listing corpus, and published wage benchmarks — as of Jul 28, 2026. It is a model, not a headcount.

Why we read it this way (8)

The posting is a New York State government contract engagement (NYWIC/WIC program); the location is inferred as Albany, NY (NYS DOH headquarters) based on the statewide program context, though no city is explicitly stated.

The mandatory qualification calls for 84+ months (7+ years) of expert-level Database Architect experience, which drives the overall years minimum to 7.

All 'Requested Qualifications' are listed under a formal qualifications section with specific month counts and firm language, so they are treated as hard gates. The 24-month OBIEE RPD development and data governance items carry the shortest tenure requirement and are the weakest gates in the list; they are marked preferred to reflect that they read more as depth-of-experience differentiators than rejection criteria, given the primary role focus is data modeling.

The posting explicitly requires a Bachelor's degree in an IT field with no 'or equivalent experience' escape clause.

Employment type is inferred as Contract based on the staffing/resource-request framing ('the resource will serve as backup'), NYS LATS timecard reference, and project/program structure — no direct statement of full-time permanent employment is made.

No compensation figures are provided.

Ignored 3 non-technology phrase(s) as skills (responsibilities/concepts, not named tools): dimensional data modeling, OBIEE RPD development, data governance.

Posting is for a contract engagement — the market benchmarks below price full-time roles, so read the comp comparison with that in mind.

Read the full posting

The employer publishes the full description on their own site — read it there ↗. Or sign in to read it here — it's free, and it also lets you track this application.

Apply

Apply on employer site ↗