BI Analyst

Tenth Avenue Holdings, LLC; New York (NY); Hybrid; USD 70,000 - 90,000; Full time

Job summary

A consumer-driven company in New York is seeking a dedicated BI Analyst. The role involves building and maintaining Tableau dashboards, optimizing SQL queries on Amazon Redshift, and collaborating with business stakeholders for actionable insights. The ideal candidate should have 1-2+ years of analytical experience and a Bachelor’s degree. This position requires some in-office work but allows for a hybrid schedule, making it flexible for the right candidate.

Qualifications

• 1-2+ years of experience as a Data Analyst, Business Analyst, or similar role.
• Ability to translate business questions into analytical approaches.
• Experience with Shopify or other retail/e-commerce platforms is a plus.

Responsibilities

• Build, enhance, and maintain Tableau dashboards and reports.
• Write and optimize SQL queries against an existing data warehouse.
• Assist in maintaining/upgrading data sources to ensure real-time data flow.

Skills

Strong SQL skills

Experience with Tableau

Detail-oriented approach

Communication skills

Understanding of retail/e-commerce

Education

Bachelor’s degree in Information Science, Business, or related field

Tools

Amazon Redshift

Tableau

Job description

Who We Are

Tenth Avenue Holdings is a collection of consumer-driven businesses and brands that operates and invests in privately and publicly held businesses. Our revenue model centers on providing long-term value through strategic investments and partnerships with brands whose leadership align with ours. Our specialty is providing long‑term investment and value for our CPG brands, specifically in the e-commerce space. Our core values foster caring, curiosity, integrity and fun!

Overview

We are seeking a dedicated and adaptable BI Analyst to join our team. In this role, you will play a pivotal part in ensuring the seamless operation of our IT & data systems by maintaining our data warehouse and reporting platform that provides data insights into business questions for the marketing and operations teams at our Jewelry and Pet consumer brands. Over time, you’ll expand our data warehouse to incorporate more of our consumer brands data.

What You’ll Do

• Build, enhance, and maintain Tableau dashboards and reports used by various teams that support both B2C/B2B channels including building and maintaining operational reports for our warehouse such as damage rates and on‑time fulfillments.
• Unit sales and inventory levels that support forecasting by our purchasing team.
• Orders by B2B partner, shipping type, or channel for our marketing team.
• COGS, margins, and profitability reports for finance and leadership, and other weekly, monthly, and quarterly reports used by various business teams.
• Write and optimize SQL queries against an existing Amazon Redshift data warehouse to support reporting and ad‑hoc analysis. Answer recurring and ad‑hoc business questions with clear data insights and visualizations.
• Assist in maintaining/upgrading data sources including Shopify, shipping platforms, marketing platforms, and more to ensure real‑time data continues to flow into Redshift.
• Establish and implement common views of data used by various reports to improve maintainability and accuracy of data sources across both existing and new reports.
• Partner with business stakeholders to clarify requirements and ensure reports are accurate, timely, and actionable.
• Document metrics definitions, data sources, and reporting logic to improve consistency and trust in data.

Who You Are

• Bachelor’s degree in Information Science, Business, or related field (or equivalent work experience).
• 1–2+ years of experience as a Data Analyst, Business Analyst, or similar role.
• Strong SQL skills with experience querying relational data warehouses (we use Amazon Redshift). You should be able to write performant queries and explain joins.
• Hands‑on experience building reports and dashboards in Tableau or comparable system.
• Ability to translate business questions into analytical approaches and communicate findings clearly.
• Detail‑oriented approach to investigating and validating data sources.
• Strong attention to detail and communication skills.
• Understanding of retail/e‑commerce concepts including COGS, inventory turn, seasonality, forecasting, on‑hand inventory, and direct‑to‑consumer vs drop‑ship.
• Experience working with retail, e‑commerce, or consumer brands (inventory‑heavy businesses) a plus, as is experience working within inventory, sales, and financial datasets.
• Experience with Shopify or other retail/e‑commerce platforms a plus.
• This position is based in New York and will require 2–3 days a week of in‑office time with occasional travel to CT required (once per month).

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, color, religion, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or any other characteristic protected by applicable laws, regulations and ordinances.