CBS Corporation Data Warehouse Senior Manager in New York, New York
Data Warehouse Senior Manager
CBS BUSINESS UNIT: CBS Corporate
JOB TYPE: Full-Time Staff
JOB SCHEDULE: Full-Time
JOB LOCATION: New York, NY
CBS Corporation (NYSE: CBS.A and CBS) is a mass media company that creates and distributes industry-leading content across a variety of platforms to audiences around the world. The Company has businesses with origins that date back to the dawn of the broadcasting age as well as new ventures that operate on the leading edge of media. CBS owns the most-watched television network in the U.S. and one of the world’s largest libraries of entertainment content, making its brand - "the Eye" - one of the most recognized in business. The Company’s operations span virtually every field of media and entertainment, including cable, publishing, radio, local TV, film, outdoor advertising, and interactive and socially responsible media. CBS’s businesses include CBS Television Network, The CW (a joint venture between CBS Corporation and Warner Bros. Entertainment), Showtime Networks, CBS Sports Network, TVGN (a joint venture between CBS Corporation and Lionsgate), Smithsonian Networks, Simon & Schuster, CBS Television Stations, CBS Radio, CBS Outdoor, CBS Television Studios, CBS Global Distribution Group (CBS Studios International and CBS Television Distribution), CBS Interactive, CBS Consumer Products, CBS Home Entertainment, CBS Films and CBS EcoMedia.
The Director provides leadership and coordination of all technical aspects of systems development activities required to provide a productive and efficient system that meets business requirements. While supporting a specific development effort, the technical lead is also expected to help the company develop strategic technical directions.
This position is responsible for the management and delivery of the application and process portfolio to one line of business. This position drives the continued evolution, operation, and support of business processes and enabling applications to ensure effective and efficient achievement of business objectives.
Scope of work includes the development and sustainment of a processes/systems integration strategy and plan, and project leadership on major processes/systems efforts (including the development of project scope and expectations, and the coordination of resources from multiple internal and external sources).
Leads the technical architecture and design for a new Data Warehouse.
Initially will be the single resource responsible for construction of all objects necessary within the Data Warehouse.
Interact with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions.
Oversee activities for all assigned projects from planning to delivery and sustaining support to ensure that projects meet established business objectives, time and budget constraints.
Provides scoping and estimating on Data Warehouse activities
Presents technical information in easily understood terms in both verbal and written form
Works closely with fellow IT staff and project management to document standards and procedures for the definition of reference architectures (architecture roadmap)
Interacts and works directly with customer team members on projects and support issues.
Facilitates communication upward and across project teams
Follows change management and problem management processes.
12+ year’s experience in information technology
8+ years of experience in Data Warehouse solutions
8+ years minimum of demonstrable experience in a technical leadership role
8+ year’s experience with ETL tools like Informatica Power Center
Experience with Teradata packages, stored procedures, triggers
Experience with Oracle SQL (DML & DDL), PL/SQL, packages, stored procedures, triggers
Expertise in reviewing business requirements, technical requirements documentation
Expertise in writing high and low level design documentation
Experience in writing re-usable unit test documents
Extensive experience with developing, unit testing, break/fix support of Informatica ETL
Skilled in performance tuning, query plan / explain plan analysis, indexing, table partitioning
Excellent communication skills, both verbal and written
Experience leading technical teams
Familiarity with use of version control / source code management tools
Full SDLC experience
Well organized, detail oriented, ability to multi-task
Excellent time-management, planning and prioritization
Comfortable working with all project stakeholders (business users, architects, project managers, business analysts, developers, test analysts, production support team)Entertainment industry experience is strongly desired
Bachelor's degree in Computer Science or related discipline. Master's Degree in a related field is preferred.
Equal Opportunity Employer Minorities/Women/Veterans/Disabled