Teradata Solution Lead-5

Plano, Texas 75023 Posted March 29th, 2026
Looking for more job opportunities? Click here!



Job Type: Full Time


Job Category: IT


Job Description


**Role: Teradata Solution Lead****Location: Seattle, WA / St. Louis, MO / Plano, TX / Dallas, TX / Houston, TX (Day 1 onsite)****FTE only** **Job Description****Must Have Technical/Functional Skills*** **Design Scalable Data Warehousing Solutions using Teradata.**
* **Develop and maintain normalized (3NF) and dimensional models.**
* **Optimize physical models and fine tune queries for performance.**
* **Design and develop Tera Data ETL jobs and data pipeline.**
* **Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.**
* **Extracting data from various data sources, transforming, and loading it into target systems.**
* **Ensuring data quality, integrity, and consistency across different systems.**
* **Developing and maintaining data warehouses, data lakes and data mart architecture.**
* **Optimizing ETL processes for performance, scalability and reliability.**
* **SQL proficiency (intermediate skill level minimum).**
* **Ability to manage Teradata/SQL Server/ Oracle database migration including code migration, data loads and server retirements.**
* **Troubleshooting and resolving data integration issues.**
* **Solid skills with writing/translating SQL queries and SQL data validation.**
* **Performance tuning of SQL queries.**
* **Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment.**
* **Understanding and implementing job schedules, dependencies, and workflows within Autosys.**
* **Analyzing and resolving issues with Autosys jobs and processes**

**Roles \& Responsibilities*** **Lead and optimize Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.**
* **Lead and actively participate in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.**
* **Provide technical leadership and guidance to team members, fostering a collaborative and supportive team culture.**
* **Lead the planning, solution design and implementation, ensuring alignment with program objectives and timeline**
* **Engage in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues.**
* **Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering to the code promotion process.**
* **Contributed to the development and maintenance of documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing Change Requests**
* **Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction.**
* **Collaborate with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows.**

**Generic Managerial Skills, If any*** **Strong technical expertise in legacy application modernization, including proficiency in ETL, Solution frameworks and technologies.**
* **Excellent communication skills, with the ability to manage business expectation efficiently**

* **Detail\-oriented with solid problem\-solving and analytical abilities**


Required Skills


DATA TECH LEAD

ITSM SUPPORT LEAD

LEAD DATA ENGINEER