Job Description
Job ID: 161027
Job Title: Data Warehouse Architect
Location: Lansing, MI (Local Candidates Only)
Client: State of Michigan
Visa: H1B, H4 EAD, GC, GC EAD, USC
Rate: $80/hr c2c
Job Description:
We are seeking an experienced Data Warehouse Architect with 8+ years of hands-on Teradata experience to support the State of Michigan's Enterprise Data Warehouse (EDW). The ideal candidate will be responsible for administering, maintaining, and optimizing Teradata platforms while ensuring high availability, performance, security, and compliance.
Required Skills:
8+ years of experience with Teradata Database Administration
Expertise in Teradata upgrades, provisioning, patching, and software maintenance
Strong scripting skills in BASH, Perl, Python, and Glink
Experience with Teradata Viewpoint, TTU, PSIM, node management, and workload management
Hands-on experience in backup & recovery, performance tuning, and resource optimization
Strong knowledge of ETL processes and Unix/Linux administration
Understanding of Cloud Computing (preferably Microsoft Azure)
Experience with statistics, audits, and security planning
Knowledge of compliance standards such as NIST 800-53, IRS Pub 1075, SSA, and Medicaid
Excellent troubleshooting, vendor coordination, and disaster recovery planning skills
Responsibilities:
Administer and support the Enterprise Data Warehouse (Production, DR, and Test environments)
Monitor platform health, performance, and security
Perform upgrades, patch management, and vendor coordination
Optimize Teradata workloads and system performance
Support backup, recovery, and disaster recovery planning
Provide technical guidance to DBAs and enterprise teams
Ensure compliance with State and Federal security standards
Collaborate with stakeholders to enhance EDW services and architecture
Job Tags
H1b, Local area
Similar Jobs
L3Harris Technologies
L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do. Our employees are unified in a shared dedication to our customers' mission and quest for professional growth. L3Harris provides an inclusive, engaging environment...
SeatGeek
...reproductive health services ~ Gender-affirming care support program ~$500 per year for wellness expenses ~ Subscriptions to Headspace (meditation), Headspace Care (therapy), and One Medical ~$120 per month to spend on tickets to live events ~ Annual...
Catholic Charities of the Archdiocese of Newark
Catholic Charities of the Archdiocese of Newark is one of New Jerseys largest non-profit social service agencies with programs and facilities serving Bergen, Essex, Hudson, and Union counties. We are currently seeking a Full-Time Supportive Visitation Specialist ...
Confidential
...Job Overview TLC Nursing Associates, Inc. is seeking a dedicated Emergency Medical Technician (EMT) for travel assignments in various healthcare facilities. The ideal candidate will provide pre-hospital emergency medical care, respond to emergency calls, and transport...
Barnes Place
...Dietary Aide- Part Time- 11am-7pm About LakeHouse Senior Living: LakeHouse Senior Living, proudly part of the Discovery Senior Living family of operating companies, manages care- and lifestyle-focused senior living communities in Indiana, Illinois, Wisconsin, Pennsylvania...