Data Analyst – Business Intelligence and Insights

About The Opportunity

First Table is transforming Business Intelligence, and we seek a professional eager to help shape this evolution. This role offers a unique intersection of business consulting, analytics engineering, and BI, blending data insights with technical and commercial decision-making capabilities.

Success here goes beyond technical skills; it demands a consulting approach—curiosity, commercial awareness, and confidence in engaging stakeholders to convert business challenges into actionable, data-informed solutions.

The role involves close collaboration with our Data Engineer and Data Scientist, working closely with Marketing, Product, and Commercial teams. Half of your time will focus on understanding business problems and framing solutions, with the remainder dedicated to designing data models, developing Power BI dashboards, and delivering impactful insights.

If analyzing business challenges excites you as much as crafting impactful dashboards, this is the right role for you.

About Us

First Table, headquartered in Queenstown, New Zealand, is a pioneering hospitality tech company with over a decade’s presence across New Zealand, Australia, and the United Kingdom. We connect diners and restaurants through smart technology, facilitating early bird and last table bookings, thereby enhancing dining experiences and restaurant operations.

Our core values—Win-Win-Win, Own It, and Grow Together—define our culture and commitment to employees, partners, and customers, creating a vibrant work environment.

Role Overview

As the Business Intelligence & Insights Data Analyst, you'll be instrumental in advancing our BI capabilities. This role bridges our sophisticated data platform and the business units relying on it, transforming queries into reliable insights that steer decisions. Working collaboratively, you will influence data modelling, governance, and usage throughout the organization, incorporating AI tools judiciously to enhance analysis and delivery.

Key Duties

• Lead the advancement and migration of our reporting infrastructure to Snowflake and Power BI.
• Craft scalable semantic models along with reusable data workflows and pipelines.
• Develop high-performance and user-friendly Power BI dashboards and reports.
• Engage with Marketing, Product, and Commercial teams to interpret business needs into data solutions.
• Establish, validate, and uphold trusted business metrics and reporting protocols.
• Analyze client, product, and commercial metrics to discover trends and growth opportunities.
• Provide actionable insights to support strategic business decisions.
• Collaborate actively with the Data Engineer to enhance data platform and BI functionality continually.

Candidate Profile

• 3-4 years' experience in data analysis, business intelligence, analytics engineering, or consulting, blending technical proficiency with stakeholder engagement.
• Proficient in SQL, preferably within Snowflake or similar cloud warehouses.
• Advanced capability with Power BI including DAX, Power Query, and semantic modelling skills.
• Strong grasp of dimensional modelling concepts such as Star Schema, Fact and Dimension table designs.
• Familiarity with commercial data sets like marketing performance, product analytics, or sales reporting.
• Confidence in leading stakeholder workshops and translating requirements into reporting products.
• Excellent communicator able to convey technical information to diverse audiences.
• Experience with analytics tools like Google Analytics, Amplitude, or equivalent event-tracking platforms.
• Degree in Business Analytics, Data Science, Computer Science, Statistics, Commerce, or relevant field, or corresponding professional experience.

Additional Advantages

• Experience with dbt (data build tool).
• Knowledge of Row-Level Security (RLS) and Power BI deployment standards.
• Exposure to cloud data platforms and modern BI architectures.
• Work history within consulting firms or agencies.

Why Join Us?

• Enjoy a flexible, high-trust hybrid working model based in Auckland or Queenstown, adapted to your preferred workflow.
• Make a tangible impact on marketing, product, and commercial strategies through data-driven decisions.
• Be a key contributor to our next-generation BI platform migration using Snowflake and Power BI.
• Engage with multifaceted data challenges across marketing, product, and commercial domains to fuel growth.
• Shape organizational data modelling, reporting standards, and the overall BI framework.
• Support a beloved and expanding consumer brand influencing markets in New Zealand, Australia, and the UK.
• Receive perks including free First Table bookings, regular team recognition, social events, and a role within a purpose-driven award-winning company.

Application Process

We invite you to submit your application, including your resume and a brief cover letter describing your enthusiasm for the role and how your experience equips you for success. Applications will be reviewed promptly as they arrive, so early application is encouraged.