Data Warehouse Architect at Zenfreed, LLC
Lansing, MI
—
Jul 12, 2026
Lansing, MI
Jul 21, 2026
What this job asks for AI summary
This role involves administering a state government's enterprise data warehouse built on Teradata, spanning three environments (production, development/disaster recovery, and test) that serve over 10,000 users across seven executive branch departments. Day-to-day work covers platform performance monitoring, patch and release management, security and disaster recovery planning, workload management, and providing technical guidance to agency database staff. Suits an experienced Teradata administrator with strong Unix/Linux skills and familiarity with federal compliance frameworks.
Senior level · 8+ years · Remote · Contract
“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 120 people nationally plausibly meet what this posting asks for (database administrators). range 25–180
Applicant volume Moderate — A normal amount of company. The rare requirements below are what will separate a shortlisted application from the rest.
Rare in this occupation — lead with these, and say what you built with them.
Most people in this occupation already list these. Still required — just not what gets you shortlisted.
What the occupation pays Median $106,921 (middle half $81,361–$138,439).
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 (9)
The caller has instructed that this role be treated as fully remote with a national candidate pool. However, the posting itself explicitly and repeatedly states NO REMOTE ONLY OPTION, requires candidates to be located in Michigan within 1 hour of Lansing at time of submission, and mandates onsite presence two days per week from day one. The remote=true flag reflects the caller's override, not the posting's stated terms — recruiters should be aware this conflicts directly with the JD.
The posting is classified as a W2 contract (40 hrs/week, placed through Zenfreed staffing), not a direct full-time hire.
BASH is listed alongside Perl and Python as scripting options under the same requirement; they are captured as alternatives to one another. Glink is listed separately as its own distinct tool.
Cloud computing is listed as a requirement but Azure is called out only as 'preferable' within that requirement; Azure is therefore marked preferred with AWS and GCP as peer alternatives.
Federal compliance frameworks (IRS Pub 1075, SSA, Medicaid) are listed alongside NIST 800-53 in the requirements block; NIST 800-53 is captured as the canonical representative of this gate. The others are context for the same compliance requirement rather than distinct named tools.
SOC confidence is Medium: the role is primarily a Teradata platform/database administrator (15-1242), but the platform-admin and OS-level duties (node management, OS guidance, disaster recovery) also overlap with systems administration (15-1244).
Ignored 1 non-technology phrase(s) as skills (responsibilities/concepts, not named tools): Teradata Tools and Utilities.
Posting is for a contract engagement — the market benchmarks below price full-time roles, so read the comp comparison with that in mind.
Caller marked this a fully-remote role — scored against the national candidate pool.
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.