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.
Skills: • 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