BI Data Engineer

COMPANY OVERVIEW Cresco Labs is one of the largest public, vertically integrated, multistate operators in the cannabis industry. Our portfolio of in-house cultivated and manufactured brands features some of the highest quality, most awarded and most popular cannabis products in America. With dozens of locations nationwide, our owned and operated Sunnyside dispensaries provide a welcoming, positive, judgement-free place to shop for anyone at any point on their cannabis journey. Founded in 2013, Cresco Labs' mission is to normalize and professionalize cannabis through our passionate employees. As stewards of the cannabis industry, our teams are constantly focused on supporting the needs of our fellow colleagues, consumers, customers, and communities alike. With a focus on Social Equity and Educational Development, our SEEDTM initiative ensures that our company reflects the communities in which we serve, ensuring equal opportunity for all to have the knowledge and resources to work in and own businesses in cannabis. At Cresco Labs, we aim to revolutionize and lead the nation's cannabis industry with a focus on quality and consistency of product, and to bring legitimacy to the industry with the highest level of integrity and professionalism. MISSION STATEMENT At Cresco, we aim to lead the nation's cannabis industry with a focus on regulatory compliance, product consistency, and customer satisfaction. Our operations bring legitimacy to the cannabis industry by acting with the highest level of integrity, strictly adhering to regulations, and promoting the clinical efficacy of cannabis. As Cresco grows, we will operate with the same level of professionalism and precision in each new market we move in to. JOB SUMMARY Cresco Labs seeks a Business Intelligence Data Engineer to enhance our corporate team. Your core role involves crafting robust data infrastructure and analytics services, managing Snowflake datasets for reporting, and building and maintaining Tableau Dashboards highlighting Wholesale, Cultivation, Planning, and Retail data. CORE JOB DUTIES Build dynamic Tableau dashboards tailored to stakeholder needs, ensuring visualization, security, and data access requirements are met. Utilize Snowflake's SQL and Tasks to manage large datasets, optimizing ETL jobs. Develop Python scripts for data warehouse operations, preparing datasets for advanced analytics. Create Fivetran data syncs and maintain existing pipelines. Integrate master data standards across disparate sets of department data. Collaborate with business stakeholders to identify opportunities where data insights can help drive decision-making. Track budgets, goals, and production plans against actuals for business leadership. Stay current on data science tools and developments. Automate and document processes for enhanced efficiency in BI workflows. Leverage Tableau features, including parameters, fixed formulas, mobile reports, and drilldowns, for comprehensive reporting solutions. REQUIRED EXPERIENCE, EDUCATION AND SKILLS Bachelor's degree preferred, or equivalent technical certifications combined with 2+ years of strong analytical experience. 1+ years using Snowflake or similar SQL Data Warehouse. Practical experience building implementing dashboards with Tableau or other business intelligence software. Familiar with Python scripts & SQL task scheduling. Takes initiative & ownership over dataset & dashboard projects. Excellent written and verbal communication skills. High level organization and structure. BENEFITS Cresco Labs is proud to offer eligible employees a robust offering of benefits including major medical, dental and vision insurance, a 401(K)-match program, FSA/HSA programs, LTD/STD options, life insurance and AD&D. We also offer eligible employees paid holidays and paid time off. Other rewards may include annual discretionary bonuses, stock options as well as participation in our employee discount program. Benefits eligibility for permanent positions may vary by full-time or part-time roles, location, or position. COMPENSATION In accordance with any local and state compensation laws, the estimated range of compensation is $70,000 - $75,000 [+ bonus eligible]. Final offer details and future compensation may be determined by multiple factors including but not limited to, geographic location, market compensation data, skills, experience and other relevant factors. For questions about this please discuss with your recruiter during the interview process. ADDITIONAL REQUIREMENTS Must be 21 years of age or older to apply. Must comply with all legal or company regulations for working in the industry. Cresco Labs is an Equal Opportunity Employer and all applicants will be considered without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status. #J-18808-Ljbffr

Created: 2024-11-05