Urbana is a San Francisco-based cannabis dispensary brand that is seeking a skilled data analyst to support a multi-unit team of retail managers and executives with a bold BI agenda.  IF YOU HAVE RETAIL ANALYTICS EXPERIENCE AND ENJOY A FAST-PACED ENVIRONMENT CREATING INNOVATIVE DATA-BASED SOLUTIONS, YOU'LL THRIVE AT URBANA. 

ESSENTIAL FUNCTIONS:

The Business Analyst is responsible for collecting, verifying, analyzing and reporting of comprehensive retail performance of the company.  Primarily serving senior management with timely insights into every facet of retail activity and plausible strategic opportunity, the role also provides middle management with critical performance metrics that impact their day-to-day decisions and actions.  Because of the rapidly-changing nature of our national economy and nascent cannabis sector, the Business Analyst must synthesize broad industry and consumer metrics into recommendations while remaining objective and considerate of Urbana's mission, strategy, constraints and capabilities.

THIS IS AN ONSITE POSITION.

REQUIREMENTS:

Cannabis experience is NOT a requirement but will receive priority consideration.

• Minimum 2 years of retail analytics experience.
• 21 years of age or over.
• Bachelor's degree.
• Highly developed understanding of contemporary BI tools and solution approaches, API exploitation, dashboard creation, Microsoft Excel, Google Sheets (plus MSOffice and Google Workspace suites) through hands-on experience in high-demand settings.
• Extensive experience extracting, unifying, and managing data from POS systems, inventory management systems, e-commerce platforms and other retail systems.
• Experience in establishing SKU and category naming conventions to support long lifecycle unification and reporting from multiple sources.
• Enhanced report and data visualization/business graphics creation skills in Google Sheets and Powerpoint.
• Excellent communication skills to transform key insights and findings into actionable presentation formats. 
• Ability to build strong relationships with analytics peers at business partners.
• Strong written and verbal communication skills. 
• Ability to multitask in a fast-paced environment with critical deadlines.
• Maintain and update existing databases, backup systems, and key corporate assets.
• Excellent time management and prioritization skills.
• A sincere interest in thriving in the cannabis industry.

RESPONSIBILITIES:

Create, manage, support, and constantly evolve the following internal analytics functions:

• Revenue, category, COGS dashboards (10+ in a single BI suite)
• Sales analysis and long-term projection/demand forecasting
• Inventory on hand and ordering recommendations
• Overstock reports
• Brand performance reports
• Fraud detection reports
• Retail discount analysis
• Partner discount analysis and chargeback reports
• COGS reports
• Inventory adjustment reports
• Customer demographics reports
• Advertising agency reports
• Special projects
• Other reports required from time to time

PREFERRED SYSTEMS KNOWLEDGE:

Cannabis experience is NOT a requirement but candidates with direct encounters with these systems will receive priority consideration.  

• Treez POS
• LeafLogix POS
• METRC
• IheartJane Ecommerce
• Springbig rewards
• Tableau BI
• Python
• SQL

.

COMPENSATION & BENEFITS

• Competitive salary

• Health, dental, vision insurance and life insurance

• Paid vacation

• Bonus eligibility

• Semi-annual performance reviews

• Employee discounts

• Opportunity to grow with our expanding business

A routine background check on all applicants after making a conditional offer of employment. Benefits are subject to change and employer-sponsored insurance benefits are offered to full-time employees that have met the waiting period requirements of each applicable insurance carrier.

We proudly support the San Francisco Equity Program. If you meet the criteria as an equity applicant at http://www.officeofcannabis.sfgov.org, please inform us in your cover letter for priority processing.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law.