The Role

The Business Intelligence Engineer is responsible to help build, automate, and maintain corporate automation workflows. As a green field project this is an incredibly exciting opportunity to help design the systems and partner with key stakeholders in the business to drive strategic impact. As a BI Engineer you are a problem solver and genuinely like helping others solve complex problems. We are specifically seeking a candidate with AWS integration technologies, Python, SQL, & PowerShell. This position will be in the Chicago area in a hybrid work setting.

Responsibilities

Translate Green Thumb business needs into technical specifications to design, build and deploy various Business Intelligence solutions
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
Maintain and update existing scripts as well as create new ones to support various processes
Manage SaaS integrations and SQL databases, 0365 integration, and utilize AWS technologies (Glue, Data Pipeline, EC2, S3, EMR, RDS, etc.)
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

Qualifications

6+ years related experience
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
Proven experience partnering with key stakeholders in understanding business requirements to solve key strategic initiatives in Agile environment
Ability to make recommendations for new metrics, strategies, and methods to improve measurement and data collection practices
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

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

GTI prefers all new hires to be fully vaccinated against COVID-19 and provide proof of vaccination at time of hire

Apply for this Job

* Required

First Name *

Last Name *

Email *

Phone *

Location (City) *

Resume/CV *

Dropbox Google Drive

(File types: pdf, doc, docx, txt, rtf)

Cover Letter

Dropbox Google Drive

(File types: pdf, doc, docx, txt, rtf)

At Green Thumb, we believe in the "and beyond" when it comes to our team. Tell us about a time you acted in the "and beyond" in your job.

Will you require Visa sponsorship now or in the future? *

Are you authorized to work in the United States? *

Are you currently employed? *

What are your compensation expectations for this role? *

Please confirm you are over 21 years of age. *

Please select your gender pronoun. *

Are you a former Green Thumb Industries (GTI) employee who has been on the payroll of GTI or a GTI - affiliated business? An affiliate is considered a business entity owned in whole or in part, directly or indirectly, by GTI. *

How did you hear about this position? *

If you were referred by a current Green Thumb employee, please specify the full name of the person who referred you below.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Green Thumb’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Gender

Are you Hispanic/Latino?

Please identify your race

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Veteran Status

Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

Autism
Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
Blind or low vision
Cancer
Cardiovascular or heart disease
Celiac disease
Cerebral palsy
Deaf or hard of hearing
Depression or anxiety
Diabetes
Epilepsy
Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
Intellectual disability
Missing limbs or partially missing limbs
Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

Disability Status

¹Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.