Freelance Data Optimization Specialist
About the role
Holistic Industries, Inc. is seeking a Data Optimization Specialist with strong experience in SQL Querying & Optimization, Data Wrangling, and Ad Hoc Analysis.
The Data Optimization Specialist will be a key contributor to our Business Intelligence team, helping to streamline and clean our data infrastructure to improve the accuracy, reliability, and usability of reporting across the organization. This role focuses heavily on writing efficient SQL queries, diagnosing and resolving data quality issues, and creating more scalable, centralized data pipelines.
We’re looking for someone who will be proficient in:
- Data Quality & Cleanup: Identify inconsistencies, missing values, duplications, and other issues within large datasets. Design and implement SQL-based processes to resolve them.
- SQL Querying & Optimization: Develop efficient, scalable SQL queries that power reports, dashboards, and internal analytics processes. Refactor legacy queries for performance and clarity.
- Data Wrangling: Use SQL to transform, clean, and optimize data queries for use in Power BI dashboards, leveraging read-only access to the SQL-based data warehouse as to not disrupt current data structure.
- Collaboration & Support: Partner with BI analysts, data engineers, and business stakeholders to understand data pain points and proactively improve data reliability and accessibility.
- Documentation & Templates: Document assumptions, logic, and best practices to enable consistent reuse of cleaned datasets or common transformations.
- Ad Hoc Analysis: Support fast-turn data requests and build exploratory queries to assist in decision-making and root cause analysis.
- Other duties as assigned, or any reasonable request from any member of management.
We are looking for someone who enjoy working in messy data environments and has a passion for turning disjointed, inconsistent data into trusted, actionable information for stakeholders. While this role will directly support our Power BI environment, Power BI expertise is not required — rather, a strong SQL foundation and attention to data integrity are essential.
About Holistic Industries
We are plant people, for people who love the plant. Scaling from a seed of inspiration in 2011, Holistic is now one of the largest and fastest growing privately held cannabis companies in the country. We are growers of cannabis, careers and communities. We are builders of brands and retail experiences. We champion the plant, our partners and all people working to end prohibition.
In our Liberty dispensaries around the country, we champion cannabis, the culture, and most importantly, our customers. We are your neighbors with the good weed. We hire local talent and feature local brands, in addition to our own brands, in every store.
Our brands include Garcia Hand Picked and Strane, Hellavated, Do Drops, Cannaceutica and more to come. We sell and supply hundreds of dispensaries with our brands, provide full spectrum support to sell in and sell through the highest quality cannabis in a diverse line-up of products for every type of cannabis consumer. From genetics snobs to Deadheads to patients looking for relief, our brands have one thing in common - they are for cannabis lovers like us.
We cultivate the best plants and people in the industry. Our grows are full of experts on a mission to nurture each and every plant to reach its highest potential. That takes a unique approach, a lot of passion and pride in what we grow and sell. Our cultivation team members are first in line to buy the cannabis they grew, harvested and trimmed as soon as it hits store shelves.
We operate in California, Oregon, Maryland, Massachusetts, Michigan, Pennsylvania, Washington D.C. and West Virginia, with support staff working remotely around the country. We are deeply and actively committed to the communities we serve and DEI. If you are interested in joining our team, please reach out and let us know. We are always looking for plant people to grow with us!
Freelance Data Optimization Specialist
About the role
Holistic Industries, Inc. is seeking a Data Optimization Specialist with strong experience in SQL Querying & Optimization, Data Wrangling, and Ad Hoc Analysis.
The Data Optimization Specialist will be a key contributor to our Business Intelligence team, helping to streamline and clean our data infrastructure to improve the accuracy, reliability, and usability of reporting across the organization. This role focuses heavily on writing efficient SQL queries, diagnosing and resolving data quality issues, and creating more scalable, centralized data pipelines.
We’re looking for someone who will be proficient in:
- Data Quality & Cleanup: Identify inconsistencies, missing values, duplications, and other issues within large datasets. Design and implement SQL-based processes to resolve them.
- SQL Querying & Optimization: Develop efficient, scalable SQL queries that power reports, dashboards, and internal analytics processes. Refactor legacy queries for performance and clarity.
- Data Wrangling: Use SQL to transform, clean, and optimize data queries for use in Power BI dashboards, leveraging read-only access to the SQL-based data warehouse as to not disrupt current data structure.
- Collaboration & Support: Partner with BI analysts, data engineers, and business stakeholders to understand data pain points and proactively improve data reliability and accessibility.
- Documentation & Templates: Document assumptions, logic, and best practices to enable consistent reuse of cleaned datasets or common transformations.
- Ad Hoc Analysis: Support fast-turn data requests and build exploratory queries to assist in decision-making and root cause analysis.
- Other duties as assigned, or any reasonable request from any member of management.
We are looking for someone who enjoy working in messy data environments and has a passion for turning disjointed, inconsistent data into trusted, actionable information for stakeholders. While this role will directly support our Power BI environment, Power BI expertise is not required — rather, a strong SQL foundation and attention to data integrity are essential.
About Holistic Industries
We are plant people, for people who love the plant. Scaling from a seed of inspiration in 2011, Holistic is now one of the largest and fastest growing privately held cannabis companies in the country. We are growers of cannabis, careers and communities. We are builders of brands and retail experiences. We champion the plant, our partners and all people working to end prohibition.
In our Liberty dispensaries around the country, we champion cannabis, the culture, and most importantly, our customers. We are your neighbors with the good weed. We hire local talent and feature local brands, in addition to our own brands, in every store.
Our brands include Garcia Hand Picked and Strane, Hellavated, Do Drops, Cannaceutica and more to come. We sell and supply hundreds of dispensaries with our brands, provide full spectrum support to sell in and sell through the highest quality cannabis in a diverse line-up of products for every type of cannabis consumer. From genetics snobs to Deadheads to patients looking for relief, our brands have one thing in common - they are for cannabis lovers like us.
We cultivate the best plants and people in the industry. Our grows are full of experts on a mission to nurture each and every plant to reach its highest potential. That takes a unique approach, a lot of passion and pride in what we grow and sell. Our cultivation team members are first in line to buy the cannabis they grew, harvested and trimmed as soon as it hits store shelves.
We operate in California, Oregon, Maryland, Massachusetts, Michigan, Pennsylvania, Washington D.C. and West Virginia, with support staff working remotely around the country. We are deeply and actively committed to the communities we serve and DEI. If you are interested in joining our team, please reach out and let us know. We are always looking for plant people to grow with us!