Position Details
Position: Data Warehouse Architect 3
Location: Lansing, Michigan (Hybrid)
Duration: 12 Months (Possible Extension)
Top Skills & Experience
8+ years of experience with Teradata Database
Strong experience with Teradata Tools and Utilities (TTU)
Experience in Teradata Backup & Recovery
Expertise in Performance Tuning and Resource Optimization
Experience with Extract, Transform, Load (ETL)
Excellent written and verbal communication skills
Work Arrangement
Interview: Virtual via Microsoft Teams (video). Candidates should use a laptop and be prepared to share their screen if requested.
Hybrid Schedule: Onsite two days per week from Day 1 (currently Tuesdays and Wednesdays; subject to change).
Location Requirement: Local candidates only. Candidates must reside within one hour of Lansing, Michigan at the time of submission.
Remote Work: Remote-only candidates will not be considered.
Job Description
The organization maintains an enterprise data warehouse built on the Teradata ecosystem and is seeking an experienced Data Warehouse Architect to administer, support, and optimize the enterprise data warehouse environment.
Required Experience (8+ Years)
Teradata Database Administration
Teradata upgrades, provisioning, and software maintenance
Scripting using BASH, Perl, Python, and Glink
Teradata ecosystem health monitoring
Teradata node management
Teradata Viewpoint Administration
Teradata Tools and Utilities (TTU)
Platform Service Intelligent Monitoring (PSIM) Administration
Teradata vendor upgrades
Teradata workload management
Teradata backup and recovery
Performance tuning and resource optimization
ETL (Extract, Transform, Load)
Unix/Linux administration
Cloud computing fundamentals, networking, and resource allocation (Microsoft Azure preferred)
Statistics and performance analysis
Security planning and audit support
Experience with federal compliance standards such as NIST 800-53, IRS Publication 1075, SSA, Medicaid, or similar regulatory requirements
Responsibilities
Administer and maintain enterprise data warehouse platforms across Production, Development/Disaster Recovery, and Test environments.
Monitor platform health, availability, and overall system performance.
Perform platform upgrades, patching, maintenance, and capacity planning.
Coordinate with vendors for issue resolution, upgrades, and product support.
Troubleshoot complex platform and database issues.
Optimize workload management and system resource utilization.
Develop long-term platform strategies and implementation plans.
Provide disaster recovery planning guidance and operational support.
Maintain platform security and ensure compliance with organizational and regulatory standards.
Support enterprise database administrators and technical teams with platform expertise.
Monitor and resolve performance bottlenecks.
Document configurations, procedures, and operational best practices.
Required Technical Skills
Teradata Database
Teradata Viewpoint
Teradata TTU
PSIM
ETL
BASH
Perl
Python
Unix/Linux
Microsoft Azure (preferred)
Performance Tuning
Backup & Recovery
Workload Management
Security & Compliance
Disaster Recovery
Statistics & Performance Analysis
Additional Notes
Candidates should have strong communication and documentation skills.
Resumes should ideally be limited to 4–5 pages.
Candidates should be available to work in a hybrid environment and meet onsite requirements.

Teradata Data Warehouse Architect (Hybrid - Lansing MI)

Similar Other Jobs

Associate Director of HR Technology - HR Data Platform

Senior Clinical Data Manager

Implementation Financial Data Manager - Nationwide, US

EMR Architect - Data

AI Architect

Data Center Development Manager