The Lead Warehouse Engineer is part of a small Warehouse team at TripAdvisor. The Data Warehouse is a critical component of the overall technology architecture at TripAdvisor. He/She will have an opportunity to make an impact and should be excited about being part of the team that makes a difference to the daily lives of our consumers in other parts of the organization, such as Sales, Marketing, Content and Engineering.
This engineer will act as the technical lead/architect of the 12 terabyte data warehouse system at TripAdvisor. This position requires that the engineer roll up their sleeves and write code. This is NOT a design and blue sky only role.
The qualified individual will have a proven track record delivering high quality results, while thriving in a quickly paced environment.
Responsibilities
• Technical direction for the following warehouse systems
o Core relational warehouse database
o Microsoft Analysis Services
o Microsoft Reporting Services
o ETL system currently used to populate core warehouse
• Ensuring that TripAdvisor has warehouse systems in place to deal with our explosive growth
• Leading and mentoring other members of the team
• Work with the team on items such as DBA related work, cube creation and maintenance, ongoing optimization of the existing data structures, creating user friendly reporting systems
• Help in developing SSIS Packages, scripts, programs, and schemas to facilitate date movement and cleansing for both internal systems and external data feeds
• Maintain and monitor all the warehouse systems to ensure their proper operation, performance and availability
• Responsible for writing reports for different business constituents within the company
Requirements
• BS in Computer Science or equivalent
• 3+ years of experience on SQL Server 2000/2005. Experience with other relational databases is a plus.
• Warehousing concepts, dimensional modeling, star schema
• 2+ years of experience with very large data warehouses including design and tuning
• SQL Server Analysis Services - 2005 OLAP experience including design and deployment of complex cubes
• Proficiency in Transact-SQL (SQL Server 2005 specific), complex queries, stored procedures, functions and other related system objects
• Proficiency in SQL tuning, understanding optimization (index types, search arguments, covered indexes, etc.)
• SQL Server Integration Services (SSIS)
• Organized, self-motivator, great communicator and detail oriented
• Strong analytical and problem-solving skills
• Sense of humor and good people rapport
• Ability to deal with the pressure of juggling lots of tasks
• Ability to prioritize or learn how to
• Ability to shift projects quickly
Optional Requirements
• Experience as a programmer in a JAVA/.NET technologies (C#, VB) environment is a definite plus
• Exposure to SharePoint
• Exposure to Performance Point Server 2007
• Exposure to Ominiture / Visual Sciences
Interested?
If you are interested in joining a rapidly growing company with great people in an exciting industry, please send a resume and cover letter to
warehouse_jobs@tripadvisor.com. No phone calls, please.