BI Engineer

TripAdvisor, Needham, MA

Know better. Book better. Go better.

TripAdvisor is going through an exciting business and brand transformation evolving from a review site to a travel commerce site. The Brand Analytics team partners with both brand marketing and product teams across the organization to deliver impactful business insights. TripAdvisor’s Brand Analytics team is seeking a BI Engineer to work directly on projects that impact the company’s initiatives.

Essential Job Functions:
• Work with internal clients to understand business requirements
• Design, implement, and support ETL flows for the CRM data warehouse
• Design, implement, and deliver reports based on business requirements using SSIS or using in-house ETL platform
• Understand the data source systems and source data in detail and become a SME
• QA any work done by self and other team members
• Document all of the design and development artifacts
• Troubleshoot and support all BI related production processing
• Understand the current reporting environment and use that knowledge to continuously improve the CRM data warehouse.

• 3-5 years’ experience in the design, development, and testing of Data Warehouse implementations
• 3+ years of experience with SQL and Relational Databases
• Experience with MS SQL Server is a must;
• Extensive experience with writing SQL and Stored Procedures, query tuning etc.
• Deep knowledge of dimensional modeling and experience with it on at least 2 large projects in production
• Experience with ETL tools such as SSIS or Informatica
• Experience with reporting tools such as Brio, Tableau, Qlickview, SSRS,  PowerBI, Excel
• Ability to communicate and work with both technical and non-technical team members
• Ability to work in a fast-paced and dynamic environment
• Excellent interpersonal skills including verbal and written communication, teamwork, and issue resolution
• A problem-solving mindset; this individual should be highly motivated and self-directed
• Experience with Apache Hadoop/Hive integration, R, Spark, Kafka is also a big plus


About TripAdvisor

TripAdvisor® is the world's largest travel site*, enabling travelers to unleash the potential of every trip. TripAdvisor offers advice from millions of travelers, with 500 million reviews and opinions covering 7 million accommodations, restaurants and attractions, and a wide variety of travel choices and planning features — checking more than 200 websites to help travelers find and book today's lowest hotel prices. TripAdvisor branded sites make up the largest travel community in the world, reaching 390 million average unique monthly visitors** in 49 markets worldwide. TripAdvisor: Know better. Book better. Go better.

Want to learn more about TripAdvisor? Visit http://www.tripadvisor.com