Cloud Computing, Data Management, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Disaster Recovery, Ecosystems, Identify Issues, Medicaid, Microsoft Windows Azure, NCR Teradata, Operating Systems, Performance Analysis, Performance Management, Performance Tuning/Optimization, Problem Solving Skills, Release Management/Engineering, Security Auditing, Software Patches, Strategic Planning, Systems Administration/Management, Testing, U.S. National Institute of Standards and Technology (NIST), Vendor/Supplier Management
Data Warehouse Architect
Location: Lansing, MI (Hybrid)
Duration: 12 Months
Job Summary:
Seeking for a Data Warehouse Architect to manage and optimize our Enterprise Data Warehouse (EDW) built on the Teradata ecosystem. The position involves platform administration for Production, Development/Disaster Recovery, and Test environments, supporting over 10,000 users and managing 40 Terabytes of data. You will define technical planning, implementation, and delivery strategies while ensuring high performance and security standards.
Responsibilities:
- Coordinate long-term EDW strategies with users, management, and vendors.
- Define technical planning and implementation for EDW platform services.
- Manage vendor communication, troubleshooting, and release/patch management.
- Provide operating system guidance and EDW security expertise.
- Advise on disaster recovery planning strategies.
- Monitor platform performance and resolve issues.
- Offer technical expertise to department DBAs and specialists.
Must-Have Skills:
- 8 years of experience with Teradata database
- Teradata Tools and Utilities (TTU)
- Teradata backup & recovery
- Performance tuning and resource optimization
- Extract Transform Load (ETL)
Preferred Skills:
- Cloud computing fundamentals, preferably MS Azure
- Audits & security plans
- Familiarity with federal requirements – NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.