Apply on Employer Site

Famous Smoke Shop · 4 weeks ago

BI & Reporting Analyst

Easton, Pennsylvania, United States

Full-time

Onsite

Mid Level

3+ years exp

Famous Smoke Shop is a premier online cigar retailer dedicated to providing top-notch customer service. The BI & Reporting Analyst role involves gathering, validating, and interpreting data to support various departments, ensuring accurate and timely information for decision-making.

RetailTobacco

Responsibilities

Extract, clean, and validate data from multiple systems using SQL

Translate vague or high-level requests into clear, structured analytical questions

Determine whether the requested data is relevant, accurate, and aligned to the business need

Establish repeatable data flows that reduce manual work and increase accuracy

Ensure consistency of metrics, definitions, and logic across departments

Analyze customer, product, financial, and operational datasets to identify trends and insights

Build clear, concise, non-technical summaries for leaders and cross-functional partners

Provide data-backed recommendations, not just raw reporting

Identify anomalies, outliers, and gaps in data quality or business logic

Build, refine, and maintain dashboards and automated reporting within Domo, ensuring strong data modeling, visualization, and metric consistency

Improve visibility into performance metrics across Marketing, Merchandising, Finance, and Ops

Help lead the transition from homegrown reporting to a modern BI ecosystem

Use AI to accelerate querying, visualization, and report automation

Work closely with Finance to align reporting with accounting rules, margin logic, and COGS accuracy

Support Merchandising with pricing analysis, inventory insights, forecasting inputs, and SKU performance

Support E-Commerce with conversion metrics, site performance data, and product placement analytics

Serve as an internal consultant for teams requesting deeper data insights

Ask probing, challenging questions to clarify ambiguous business requests

Identify when departments are asking for the wrong metric or insufficient data

Recommend better approaches, data sources, or analytical frameworks

Act as the 'dealer of data', ensuring teams receive dependable, decision-ready insights

Use AI for drafting SQL queries, automating recurring reporting, identifying outliers, anomalies, and patterns, and accelerating data investigation and dashboard creation

Help teams adopt practical AI workflows that reduce manual tasks and increase accuracy

Support Marketing in evaluating performance for campaigns, paid media, email, SEO, and promotions

Assist with segmentation, personalization, and cohort analysis when needed

Provide insights that support A/B testing and ROI evaluation

Contribute to catalog or direct-mail segmentation projects as bandwidth allows