Data Warehouse Architect

Techridge, Inc.
Lansing, United States of America
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 166K

Job location

Lansing, United States of America

Tech stack

Azure
Business Software
Cloud Computing
Databases
ETL
Data Mining
Data Recovery
Data Warehousing
Decision Support Systems
Disaster Recovery
Performance Tuning
Teradata
Performance Monitor
Patch Management

Job description

Description: The Enterprise Data Warehouse (EDW) service offered by DTMB provides customers with the ability to conduct high performance analytics, data mining activities, and enhanced decision support capabilities. Currently, the EDW service employs Teradata technology.

This position will serve as a platform administrator for the EDW, consisting of 3 distinct platforms (Production, Development/Disaster Recovery, and Test). The EDW provides enterprise data warehousing services to executive branch department as well as the State Court Administrator Offices statewide. A total of 7 departments are supported, with a user base of over 10,000 and 40 Terabytes of data. This position researches and coordinates long term EDW strategies with all current and potential users, DTMB management and vendor personnel. This position defines the technical planning, implementation plan, and delivery of the EDW platform services and supporting technologies to meet the State of Michigan's business requirements and objectives. This includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management. This position is responsible for providing operating system guidance along with EDW security expertise for the systems as well as advising the Agencies on disaster recovery planning strategies related to the EDW and their business applications. The position is also responsible for platform performance monitoring and resolving performance issues. This position provides direct technical expertise to department DBAs and specialists across the enterprise.

Requirements

· Candidate must be available for Onsite from Day 1, Tue/Wed mandatory, may transition to 5 days onsite)

· Interview Process: Vendor required to upload screenshot picture of candidate if interview is requested.

· Must be able to work onsite Tuesday & Wednesday each week (8 hours per day).

· Must be willing to transition to 5 days onsite if required (no remote-only option).

Max rate is $80/hrs all inclusive on Corp to Corp

Top Skills & Years of Experience:

  • Teradata database
  • Teradata Tools and Utilities (TTU)
  • Teradata backup & recovery
  • Performance tuning and resource optimization
  • Extract Transform Load (ETL)

Preferred Skills:

  • Cloud computing fundamentals, resource allocation, networking, preferably MS Azure
  • Audits & security plans
  • Federal requirements - NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

Apply for this position