BI & Reporting Analyst
hace 5 días
Easton
Job DescriptionSalary: About Famous Cigars: Famous Cigars is a premier online cigar retailer dedicated to providing top-notch customer service and an exceptional shopping experience. Join our dynamic team and contribute to our commitment to excellence in serving cigar enthusiasts worldwide. Job Summary The BI Analyst is a technical role responsible for gathering, validating, structuring, and interpreting data used across the organization. The position supports Marketing, Merchandising, Finance, E-Commerce, and Operations by providing accurate and timely information needed for decision-making. The role requires strong skills in data extraction, SQL, and business intelligence tools. The analyst must be able to ask clarifying questions, assess whether a request aligns with the underlying business need, and translate broad or ambiguous questions into clear analytical tasks. A working understanding of data relationships, data quality, and foundational data architecture is essential. The position also uses AI-based tools to support query development, reporting, and analytical efficiency. Work Location Requirement This position is on-site Monday through Friday at our Easton, PA headquarters. Regular, in-person collaboration is required to meet production schedules, coordinate with internal teams, and manage equipment. Remote work is not standard practice and may only be approved under special circumstances in accordance with applicable law and company policy. Essential Duties and Responsibilities • Data Gathering, Structuring & Validation, • 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., • Data Analysis & Insight Delivery, • 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., • Business Intelligence & Automation, • 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., • Cross-Functional Data Support, • 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., • Technical & Analytical Problem-Solving, • 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., • AI Utilization & Automation, • Use AI for, • Drafting SQL queries, • Automating recurring reporting, • Identifying outliers, anomalies, and patterns, • Accelerating data investigation and dashboard creation, • Help teams adopt practical AI workflows that reduce manual tasks and increase accuracy., • Additional Duties, • 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. Education and Experience • Bachelors degree in Analytics, Data Science, Economics, Finance, Business, or related field., • 3-5 years in a technical data role (data analyst, BI analyst, marketing analytics, or similar)., • Strong SQL skills or AI-assisted SQL capability, • Strong competency with BI tools, • Experience working with structured datasets and relational database concepts., • Strong communication skills able to explain technical findings to non-technical teams., • Understanding of accounting/financial fundamentals. Preferred Qualifications • E-Commerce or retail analytics experience., • Experience with NetSuite, Magento, Google Analytics, YAML/JSON, or API-based data sources., • Familiarity with Python for data manipulation or process automation is a plus, • Familiarity with ETL processes or data pipelines (basic experience acceptable)., • Experience with Domo, strongly preferred, • Experience with AI tools (ChatGPT, Claude, Copilot) for analytics., • Participation in BI or data science certification programs. Key Competencies • Technical rigor & analytical depth, • Curiosity, asking why before delivering data, • Strong probing and diagnostic questioning, • Data integrity mindset, • Ability to simplify complex data, • Excellent cross-functional communication, • Ownership, accountability, and follow-through, • Comfort navigating ambiguity Physical Requirements • Core business hours are Monday through Friday, 8:00 a.m. to 5:00 p.m. This position may require flexibility, including occasional work outside standard hours to meet critical deadlines or address sensitive operational needs., • Ability to work on-site at a computer workstation for extended periods., • Manual dexterity to operate a keyboard, mouse, and digital tools is required for content management., • Attendance at in-person meetings, training sessions, and company events is required. Equal Employment Opportunity Statement Famous Cigars, LLC is an equal-opportunity employer. We are committed to creating a diverse and inclusive workplace and do not discriminate based on any protected status under applicable law. We comply with all applicable federal, state, and local laws governing nondiscrimination in employment. We encourage individuals from all backgrounds and experiences to apply and are dedicated to fostering a workplace where everyone can thrive.