Business Intelligence Analyst

Green Thumb Industries | Chicago, IL, United States

Posted Date 10/13/2021

The Role 

The Business Intelligence Analyst is responsible for leading the design and build-out of data-driven solutions.  The BI Analyst will support multiple divisions at Green Thumb Industries by creating business intelligence and analytics visualizations that drive the business while ensuring accuracy and consistency of the information. This position will collaborate with business and technology stakeholders to design reports, visualizations, and dashboards to sustain tactical and strategic decision making. As a Business Intelligence Analyst, you are a problem solver, expert with metadata, database schemas, AWS integration technologies, Python, SQL, ETL logic, etc. and have a broad knowledge of data sources, data integration, and data flow.


  • Translate Green Thumb business needs into technical specifications to design, build and deploy various Business Intelligence solutions
  • Manage SaaS integrations and SQL databases, 0365 integration, and utilize AWS technologies (Glue, Data Pipeline, EC2, S3, EMR, RDS, etc.)
  • Maintain and update existing scripts as well as create new ones to support various processes
  • Work collaboratively with various business partners to assist in the design and implementation of analysis tools to answer business challenges
  • Drive operational excellence for data ingestion, transformation and publication to ensure confidence in systems
  • Partner with finance, operations, and technology to prioritize and define data and BI development needs
  • Work with business partners in different teams to identify new BI capabilities and projects
  • Analyze and visualize large scale data to present the findings and opportunities, and output solid analysis report with recommendations
  • Sync your activities and share your experience with a diverse team
  • Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting


  • 5+ years related experience, Bachelor's degree required in technical field
  • Proven proficiency in Python, SQL, AWS technologies
  • Proven experience and knowledge with major BI reporting tools, Tableau preferred
  • Advanced data analysis skills – e.g. database query construction, data warehousing, regression modeling, and experience in market and business analysis
  • Experience designing and implementing scalable ETL design and mappings, database query construction and data warehousing skills
  • Ability to make recommendations for new metrics, strategies, and methods to improve measurement and data collection practices
  • Experience in SharePoint Online management preferred
  • Great communication and troubleshooting skills
  • Passion for technology and growth mindset
  • Highly motivated, self-directed, innovative and able to work independently or among teams with keen judgement, common sense and resourcefulness
  • Adapts and thrives in a demanding, fast-paced environment
  • Possesses a high level of critical thinking
  • Operates with a high level of professionalism and integrity, including dealing with confidential information
  • Must understand and comply with the rules, regulations, policies, and procedures of Green Thumb
  • Must have a solid understanding of the Cannabis laws, rules and regulations and passion to further their understanding and knowledge of the industry and the laws.

Additional Requirements 

  • Must pass any and all required background checks  
  • Must be and remain compliant with all legal or company regulations for working in the industry  
  • Must be a minimum of 21 years of age 
  • Must be approved by state badging agency to work in cannabis industry 

Share this job