What are the responsibilities and job description for the Sales BI Analyst position at IGS Solutions LLC?
We are setting the industry standard to influence and inspire through our innovative methods. We merge together cannabis culture with cutting-edge technology to deliver the best possible customer and employee experience(s).
STIIIZY operates a fully integrated cannabis business with a footprint that covers the entire breadth of the state of California; the world's largest cannabis market. We control our supply chain from cultivation to retail, which enables us to deliver clean and tested cannabis products at unmatched prices.
Our mission is to provide the one-stop-shop cannabis experience by offering exceptional customer experience service and diversified products. We strive to build long-term customer loyalty.
This Recruitment effort is supported by IGS Solutions LLC
About the Role
The Sales BI Analyst will play a critical role on the Sales Analytics team by providing ongoing support for the wholesale sales organization. Primary responsibilities include the development and maintenance of analytic reporting, dashboards, data models, SalesForce.com administration, and assist with the analysis of sales and market data. The ideal candidate will possess strong analytical and communication skills, data management, business intelligence tool development (PowerBI), visual design best practices, expert Excel, and experience supporting sales, finance, and/or supply chain organizations.
What You'll Do
- Develop and maintain automated BI reports and dashboards in PowerBI and Excel
- Compile, analyze, and report all segments of available data, trends (historical/future), & KPI’s
- Assist with SalesForce.com platform administration.
- Contribute to the development of sales plans
- Monitor and analyze store sales, distributor sales, and inventory data.
- Provide actionable insights to guide the sales, marketing, and distribution teams.
- Monitor and evaluate wholesale sales team performance and make analysis recommendations.
- Collaborate with IT to support data management best practices.
- Assist with BI dashboard user training and documentation to ensure uniformity throughout the organization.
- Provide support to leadership with ad hoc reporting needs as directed.
- Perform all other duties as assigned or inherent to the position.
Required Skills/Abilities
- Strong research, data analysis, and modeling skills
- Strong communication and presentation skills
- Ability to work independently and with cross-functional teams
- Ability to manage tasks and work under deadlines while producing a high-quality result.
- Advanced user Skills of Microsoft Office Excel
- Proficiency of the English language, verbal and written format
- Comfortable working with ERP systems, maintaining large data sets, and data cleansing.
Education & Experience
- Bachelor’s degree or equivalent in Business, Computer Science, Information Systems, or related field 3 years of relevant work experience.
- 2 years prior analytical analysis experience working in mid/large size CPG company sales/supply chain environments required. (Prefer cannabis, beverage, apparel, or food industries background)
- Advanced/Intermediate experience developing automated BI tools, data models, and reporting in PowerBI
- Programming experience: Object Oriented Programming, DAX & SQL. VBA a plus
- Analytical Skills: Expert Excel, Cognos, Power BI, Data Model Framework, and Retail Math Analytics
- Experience with SalesForce Administration
- Experience with SQL Server Management Studio
- Microsoft suite (Excel, Word, PowerPoint, Access)
We provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
