BI Analyst

What Do We Do?

Triple Whale centralizes and simplifies all the metrics used by Shopify sellers, enabling them to save more time and make more money. We help e-commerce businesses accurately track and forecast all kinds of metrics, including changes in profits and operational metrics. Our goal is to infuse AI into e-commerce, empowering shops to have an accurate picture of their business and make optimal choices that boost their bottom line. Launched in mid-2021, Triple Whale already has over 11,000 clients, top-tier investors, and growing hubs in Columbus, North Carolina, and Israel.

Who We’re Looking For

We're looking for a sharp and passionate BI Analyst . Coming with a strong SQL background and the ability to establish and build tables and views on behalf of our clients and for our leadership team. This role is 50% customer facing– you’ll need to have an in-depth understanding of business, data and vast knowledge in SQL & Excel, and the soft skills to work with our businesses to ensure our state of the art LLM based data platform maximizes its capability. You will be responsible for analysis, creating tools, dashboards, and reports with our customers, on our platform. You will utilize our LLM-based platform to its limit, close any data gaps that might be found and design and create new capabilities on behalf of our customers. Our perfect candidate will turn data into information, information into insight and insights into business decisions on behalf of our customers.

What You’ll Be Doing

• Work with our customers on gaining insights from our data and building beautiful visualization using our joint LLM / SQL editor engine.
• Build and maintain BI related tables and views within the GCP environment and within our in-app SQL Editor, fusing multiple data sources over BigQuery such as Stripe, PostHog, HubSpot etc. and visualizing the data over our TW UI.
• Write ETLs in SQL (and some SQLX) and orchestrate them using GCP’s dataform, Airflow and other tools.* Collaborate with other functions across the company to establish automation that results in reports and dashboards with useful analysis and datainsights.
• Explain trends across data sources, potential opportunities for growth or improvement, and data caveats for descriptive, diagnostic, predictive (including forecasting), and prescriptive data analysis
• Assist in the development, documentation and adoption of our Data Catalog so data can be efficiently integrated, modeled and analyzed
• Constantly look for opportunities to help unblock other teams and team member
• Search for automation opportunities around data analysis and reporting* Follow and improve our processes and workflows for maintaining high quality data and reporting while implementing the Dataops philosophy in everything you do
  
  

Qualifications

• A BSc degree in a field that emphasizes statistical and analytical skills from one of Israel’s leading Universities - A must.
• 1 year or more of experience in similar roles as part of a BI team or an analytical role as part of a data engineering team.
• Fluency in SQL within analytical data warehouses - A must.
• Experience with TypeScript or JavaScript - advantage.
• Experience with Business Intelligence tools (e.g. Looker, Tableau, Superset, etc)
• Ability to write complex SQL including multi-table joins, grouping and aggregation, common table expressions, and conditional filters
• Passionate about data, analytics and automation. Experience cleaning and modeling large quantities of raw, disorganized data
• Experience working with a variety of complex data sources. Our data includes Shopify, GitHub, Facebook Ads, Google Ads, HubSpot, Stripe and many others
• Strong communication and interpersonal skills
• Strong project management skills
  
  

This is a full-time, hybrid role (2 days a week in office, either Jerusalem or Bnei Brak/Ramat Gan).

Join our innovative team and play a key role in shaping the future of our products! If you have a passion for technology, data-driven insights, and optimizing marketing performance, we'd love to hear from you!

Our Values

We Are Customer Obsessed: From our mission to every detailed project, everything we do is designed to create a positive impact for our customers.

We Move (Very!) Quickly: The speed at which we work, iterate, and deliver value is our most competitive advantage.

We Are Trustworthy: Candor, directness, and honest communication helps us learn, grow and improve so we can win together.

We Are Curious: We extend beyond our comfort zone and ask questions that guide us towards new, creative, and bold paths.

We Act Like A Mensch: We act with honor, integrity and empathy, and have deep respect for our customers and each other.

In the News

Triple Whale raises $25M for its smart Shopify data platform

Columbus e-commerce startup Triple Whale aims to triple in size

Businessinsider: BusShopify merchants have doubled ad spend on TikTok to reel in customers, as privacy changes make Facebook a ‘complete nightmare’ for customer acquisition.

Triple Whale Raises $27.7M to Develop Default Ecommerce Operating System for Shopify Brand s