Senior BI & Analytics Consultant

Our travel-focused platform runs on data, yet we are still hitting a few roadblocks: reports occasionally contradict each other, web experiments take too long to interpret, and we know there is hidden opportunity to move our conversion rate even higher. I want a senior-level mind to step in, find the story inside our numbers, and turn it into dashboards, recommendations, and winning test results.

Scope and priorities
• First, tighten the data foundation. Using Snowflake and Oracle you will write advanced SQL and, through dbt models scheduled in Airflow/Astronomer, ensure every metric is trustworthy. Eliminating inaccurate data reporting is the immediate win.
• Second, elevate visualization. You will rebuild our Tableau estate so executives see traffic analysis, KPIs, and conversion funnels at a glance, with lightning-fast load times.
• Third, unlock experimentation insights. Our Optimizely programme is active but under-analysed; you will pair the raw results with Adobe Analytics to resolve current difficulties in A/B testing analysis and surface clear next steps for site performance and personalization.

Key tools in play include Tableau, Adobe Analytics, Optimizely, Snowflake, Oracle, dbt, Airflow, and Git for version control; deep knowledge of each is essential. A background in e-commerce, travel, or hospitality analytics will help you understand our audience and move quickly.

Deliverables
1. Clean, documented SQL/dbt models feeding a single source of truth.
2. At least three executive-ready Tableau dashboards displaying website performance, traffic, and conversion rate optimization metrics.
3. A repeatable Optimizely analysis framework (queries, templates, slides) that shortens the time from test completion to decision.
4. A concise narrative deck highlighting insights, wins, and next steps—data storytelling that lands with non-technical stakeholders.

Please attach or link to previous Tableau dashboards or BI work that demonstrate similar challenges solved. I will shortlist and invite a brief technical chat to confirm fit before kickoff.