Senior Teradata Data Warehouse Architect | ETL & Production

InstantServe LLC; Lansing (MI); On-site; USD 110,000 - 160,000; Full time

Job summary

InstantServe LLC is seeking a Data Warehouse Architect to lead Teradata-based data warehousing initiatives. This senior role focuses on architecture, ETL integration, batch processing, Linux security, data quality, and production support.

You will troubleshoot production issues, manage change control, and collaborate with developers, stakeholders, and vendors to ensure robust data solutions.

Qualifications

• 3+ years hands-on Teradata experience required.
• Experience in enterprise Data Warehouse environments.
• Strong ETL and data integration troubleshooting.
• Excellent English communication and stakeholder skills.
• Ability to work independently and as part of a team.
• Knowledge of Linux security is a plus.

Responsibilities

• Support enterprise Data Warehouse, ETL, batch processing, and scheduling environments.
• Troubleshoot complex production issues and provide advanced technical support.
• Manage Teradata security, user access, Linux security, and elevated-access reviews.
• Handle code/DDL promotions, change management, build and release activities.
• Support data integration from multiple source systems and ensure data quality.
• Perform data profiling, validation, cleansing, and standardization.
• Monitor system performance and support upgrades, patches, backup, and disaster recovery.
• Maintain technical documentation and conduct architecture reviews and audits.
• Work with developers, leadership, business stakeholders, State teams, and vendors.
• Provide technical guidance and training to development teams.

Skills

Teradata

ETL integration

Troubleshooting

Data quality

Analytical thinking

English communication

Independent / collaborative

Tools

Linux

Scheduling framework

Teradata security tooling

Job description

InstantServe LLC is seeking a Data Warehouse Architect to lead Teradata-based data warehousing initiatives. This senior role focuses on architecture, ETL integration, batch processing, Linux security, data quality, and production support.

You will troubleshoot production issues, manage change control, and collaborate with developers, stakeholders, and vendors to ensure robust data solutions.