Senior CRM Analyst
Core Experience is focused on making TripAdvisor a habit for our travelers. Helping the people who come to TripAdvisor find and become part of a community of travelers with similar interests. The team focuses on growing membership as well as bringing travelers a personalized travel journey.
TripAdvisor is seeking a passionate Analyst to own data-driven insights and reporting for its Media Business. Success in this role means you have strong analytic capability and believe that data analysis is the best way to build a business. You also believe that an analysts job is to guide the media business roadmap - not just run the numbers or supply reports to teams.
As an Analyst, well count on you to design, and implement statistical analyses and best practices related to data design, and contribute directly to the prioritization of the Media business roadmap. You will help understand ad and audience performance and can maximize traveler engagement and revenue.
What You'll Do:
- Build automated processes, systems, methods and tools to support answering travel trend, traveler behavior and travel content related questions at scale with TripAdvisors data.
- Generate complex insights and measurement to help with campaign optimizations
- Create end-to-end analytical processes in Hive/R/Tableau/SQL that support a web interface to rank top hotels, restaurants, attractions and travel destinations across the globe by a variety of measures and dimensions.
- Develop new data sources or ETL processes, improving efficiencies through automation, championing new tools, or delivering insightful ad hoc analysis that supports our brand and business as it evolves.
- Define metrics that matter for on-site campaigns, distill these into easy-to-understand KPIs, and create both custom reports and automated dashboards to help the team understand and optimize performance.
What We Seek:
- 3-8 years of experience as an analyst for an online consumer media business.
- Hands-on experience working with very large data sets, including statistical analyses, data visualization, data mining, and data cleansing/transformation.
- Experience with SQL and working with databases is a must. Snowflake is desirable
- Experience with Tableau (or similar Business Intelligence tools).
- Fluency in additional data manipulation languages is a plus (Python, R etc.).
- Able to take in loose requirements, ask the right questions, and produce high-quality, actionable insights for stakeholders.
- Excellent problem-solving and analytical skills, including the ability to combine creative use of insight and data with attention to detail.
- Experience building strong relationships with internal teams and external partners
- Excellent communication skills, including the ability to listen, and deliver clear concise insight that can be digested in a minimum amount of time.
- Adaptive to change and confident in learning new tools and technologies TripAdvisor is a fast-paced environment where products and processes evolve rapidly.
- Bachelors degree in a quantitative discipline; Masters degree a plus.