PS Sr Consultant (II)-US/CAN
Teradata 56 reviews - Seattle, WA

This job posting is no longer available on Teradata. Find similar jobs:Ps Senior Consultant jobs - Teradata jobs




As the global leader in data warehousing and analytic technologies, Teradata solutions make smart companies smarter. Teradata gives companies the people, technology, innovation and a world-class network of customers and partners enabling them to gain competitive advantage to master their markets. With Teradata, the smartest wins. Learn more at

Teradata Technical Lead

Job Category: Postsales

Location: Seattle/Virtual

Job Requisition:

Tech Lead Retail West

Job Summary :
Lead Technical delivery teams throughout full development lifecycle of Teradata Implementations. This position is hands on design, development and optimization of Teradata implementations. Advises on the implementation and maintenance of the database environment for the Manufacturing Industry. Primary function is to monitor and advise on a Teradata database environment, including runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities in relationship to use of Business Intelligence (BI) Tool Suites and other Teradata Manufacturing Solutions. Major tools include Teradata Manager, Teradata Query Manager, and Teradata's Priority Scheduler. Maintains user tables and permissions. Major BI Suites include MircoStrategy, Cognos, Business Objects, MicroSoft Analytic Services, Hyperion Essbase and Brio, etc. Trains Client DBAs on administering Client-specific solutions.

Additional skills include high level designing of the processes and integration for extract, cleanse, transform, and load. Must have the ability to understand the overall requirements and integrate them into the design. This individual may have design skills in one particular area, such as designing the extract of data from the source system, or may be proficient in designing the load routine or may have the skills to design all areas of ECTL. In cases where an ECTL tool is used, must be knowledgeable in these tools to match the design with the features the tool has to offer. Provides efficient design and construction of systems and subsystems to extract, condition, and load data from operational systems and other sources into a defined physical data model, according to business and technical requirements. The ECTL designer also provides thought leadership in the selection and implementation of data transformation tools required to satisfy business and technical requirements.

Key Responsibilities :
  • Data Warehouse Implementation Lead
  • Business Intelligence application tuning within the Teradata environment experience required
  • LDM for reporting and analytics experience required
  • Physical database design and tuning preferred
  • Bulk loading of source data and source data conditioning.
  • Database security and diagnostic maintenance.
  • Distributed database management and control.
  • Database user security and permissions.
  • Evaluation and utilization of software products to assist in the management of data.
  • Diagnosis of problems and resolution for application software.
  • Measurement of DBMS performance and tuning; diagnosis of problems.
  • Modification of system-level configuration to optimize performance.
  • Interface with SQL developers for performance and data access requirements.
  • Development of standards and procedures for the BI/DBMS environment.
  • Consultation with system administrator regarding O/S - DBMS requirements.
  • Regularly scheduled verification procedures and error correction.
  • Monitoring errors.
  • Interface with system stewards to gather requirements.
  • Define data element requirements including history, timeliness and frequency of data.
  • Define volume and timing requirements.
  • Design the ECTL interface including technology choices.
  • Define server process requirements.
  • Design, develop, and test processes for extracting data from legacy systems or production databases.
  • Design, develop, and test processes for validating and conditioning data prior to loading into a data

  • Design, develop, and test processes for loading initial data into a data warehouse.
  • Design, develop, and test processes for loading cyclical data into a data warehouse.
  • Participate in performance, integration, and system testing.
Skills & Attributes


  • Strong presentation skills
  • Strong facilitation skills with executive-level leaders
General business knowledge in a wide range of industries

  • Hands-on experience applying modeling techniques to actual business solutions
  • Experience in designing, developing, and implementing relational databases
  • Experience in designing, developing and implementing Business Intelligence tools
  • Coaching - Provide timely guidance and feedback to help others strengthen specific knowledge and
skill areas needed to accomplish a task or solve a problem.

  • Business Needs Analysis - Ability to define the client's requirements within the context of their

  • Ability to assess the opportunities, benefits, risks, and success factors of a potential solution.
  • Decision-Making - Ability to use logical sound judgment and experience to determine the appropriate
course of action based on scenario, procedures, and guidelines, for a given situation.

  • Problem-Solving - Gather and use information needed to develop effective solutions to difficult
problems or situations.

  • Facilitation and Meeting Management - Guide the activities of an individual, group, or team toward a
desired result or outcome. Drive consensus and team ownership of decisions.

  • Influencing Others - Ability to assert ideas and persuade others to commit action.
  • Conflict Management and Negotiation - Ability to come to sound agreements with counterparts in
business or organizational situations where there is disagreement or differences in interest.

  • System/Technology Integration - Ability to identify and bring together a variety of technologies to
deliver a complete information system that supports operational and management objectives.

  • Testing a Data Warehouse - Ability to prepare for, administer, and validate the results of unit, vendor,
component integration, system acceptance, deployment readiness, and user acceptance testing to

ensure conformance to business, functional, and quality requirements


Basic Qualifications


BA Degree in Business Administration and or Business Information Systems or 10 + years of equivalent work experience

5 + years of Teradata and Data Warehouse experience required

Hands-on general or management experience in a number of business disciplines such as consulting services, marketing and sales, project management, information technology, financial management, business operations, and software development, with proven ability to develop and integrate plans.

  • Solid understanding of current data warehousing topics. BA or BS in Business or Computer Science.
Must travel up to 80% in a virtual environment

Preferred Qualifications


Retail experience preferred.

Experience in working in a Systems Integrator/ Big 4Consulting Firm with a proven track record of driving demand in solutions and services is a plus.







Primary Location


Americas-United States-Washington-Seattle



Global Field Operations

About this company
56 reviews
Teradata is a global leader in analytic data platforms, marketing and analytic applications, and consulting services. We help organizations...