Data Engineer
Apply HereData Engineer - Flourish Software (Remote)
About Us
Flourish Software is a leading cannabis supply chain and retail software company. We are working to empower the cannabis industry through better technology.
What’s the opportunity?
As a Data Engineer at Flourish Software, you will be instrumental in evolving our data warehouse to enable embedded analytics for our clients. You’ll transform transactional data into a structure optimized for business intelligence and reporting, with Sigma Computing as our primary BI tool. Currently, we have a foundational data warehouse and a SQL-driven ETL process, and we’re looking to explore advanced solutions, including Snowflake, to enhance our data infrastructure. If you have experience building scalable data warehouses and are excited about exploring new tools and database options, this role is for you!
What do we value?
- Honesty, integrity, and self-driven motivation
- Clean, readable code and well-thought-out solutions
- Thorough planning prior to execution
- Teamwork and communication
- Happiness and satisfaction in your work
Key Responsibilities:
- Engineer, build, and maintain a data warehouse to transform transactional data into a client-facing analytics structure.
- Develop and optimize ETL/ELT processes to support data transformation and integrity for embedded analytics.
- Collaborate on BI and reporting initiatives, supporting advanced data visualization with Sigma Computing.
- Explore and evaluate new data warehousing solutions, including Snowflake, to improve data accessibility and scalability.
- Partner with product and engineering teams to define data architecture and best practices for reporting.
- Ensure data security, compliance, and governance across data systems.
- Implement and maintain CI/CD pipelines to automate data workflows and enhance system reliability.
Skill Requirements
- Experience with cloud-based data warehousing technologies, especially AWS Redshift, Snowflake, or Google BigQuery.
- Knowledge of data modeling techniques, including dimensional modeling and star schema.
- Strong SQL skills for data transformation, cleaning, and loading.
- Familiarity with ETL/ELT tools such as dbt, Apache Airflow, Talend, or Informatica for pipeline orchestration and automation.
- Proficiency with BI tools, especially Sigma Computing, and similar tools like Looker, Tableau, or Power BI.
- Understanding of data structuring for analytics and reporting.
- Hands-on experience with AWS services, including Lambda, Glue, Athena, Redshift, RDS, and S3.
- Experience with a programming language such as Python or Scala for data manipulation and pipeline development.
- Experience implementing data governance frameworks, security best practices, and knowledge of SOC 2 or ISO 27001 compliance standards.
- Ability to work independently in a remote-first environment and manage time effectively.
- Availability to work in US time zones.
- Excellent written and verbal communication skills in English.
Nice to Have
- Proficiency in infrastructure-as-code tools like Terraform and Ansible.
- Linux administration skills and familiarity with shell scripting.
- Familiarity with machine learning tools such as scikit-learn or AWS SageMaker, particularly for predictive analytics and forecasting.
- Knowledge of DataOps best practices, including CI/CD for data workflows, with tools like Apache Airflow, Dagster, or Prefect.
- Prior experience in the cannabis or retail industry.
Benefits
- US Based Full Time Employees:
- Health, dental, and vision insurance
- 100% covered accidental death, disability, and life insurance
- SIMPLE IRA (401K equivalent) matching
- Emphasis on work-life balance
- Remote-first company (even pre-pandemic)
- Uncapped PTO (with approval)
- Opportunity to work on foundational software of a growing and fast-paced, innovative industry
Salary Range
- US-Based Candidates: $80,000-$130,000, depending on experience.
- Candidates outside the US: Compensation will be adjusted based on local market rates, typically ranging from $50,000- $80,0000 USD per year.
Application Link:
A note to candidates
Studies have shown that women, people of color, and members of the LGBTQ+ community, are less likely to apply for jobs unless they believe they meet every single one of the qualifications as described in a job description. We are committed to building a diverse and inclusive company and we are most interested in finding the BEST candidate for the job. That candidate may be one who comes from a less traditional background, and that’s okay. We would strongly encourage you to apply, even if you don't believe you meet every one of the qualifications described.