Analytics Engineer

StateHouse Holdings Inc.•San Francisco, CA

About The Position

The Analytics Engineer is responsible for designing, building, and maintaining scalable analytics data models and business intelligence solutions that enable data-driven decision-making across the Company’s vertically integrated operations, including cultivation, manufacturing, wholesale, retail, compliance, and supply chain. This role partners closely with Data Engineering and cross-functional stakeholders to translate complex business requirements into reliable, well-structured datasets, dashboards, and actionable insights, while helping establish and maintain standards of analytics, best practices, and scalable processes to support the continued growth and maturity of the Company’s data function.

Requirements

Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field, or equivalent practical experience.
Advanced proficiency in SQL, with the ability to write efficient, scalable, and well-structured queries for analytics and data transformation.
Hands-on experience with modern cloud data warehouses (e.g., Snowflake, Redshift, BigQuery).
Experience designing, building, and maintaining dbt projects, including staging, transformation, and analytics layers.
Proven experience developing and maintaining Tableau dashboards and reporting solutions.
Experience using Python for data processing, automation, or analysis (e.g., pandas, numpy).
Familiarity with data orchestration frameworks such as Airflow and understanding of workflow scheduling and monitoring.
Experience using Git for version control, including collaboration and code review workflows.
Understanding of analytics engineering best practices, including testing, documentation, and deployment processes.
Must be 21+ years old and pass a criminal background check requirement

Nice To Haves

Exposure to CI/CD practices for data or analytics workflows, preferred.
Experience working within cloud-based environments (e.g., AWS, GCP) and familiarity with DevOps tools (e.g., Docker, Kubernetes) is a plus.
Experience working with complex data models and integrating multiple data sources across business domains.
Exposure to multi-domain analytics environments, including retail, supply chain, manufacturing, or regulated industries such as cannabis, is highly desirable.

Responsibilities

Designs, develops, and maintains scalable analytics data models using dbt, supporting end-to-end workflows from staging to curated analytics marts.
Ensures data models are production-ready, reliable, well-documented, and optimized for reporting and downstream analytics use cases.
Partners with Data Engineering to build and maintain efficient, scalable, and sustainable data pipelines.
Translates business requirements into structured datasets, semantic layers, and actionable insights to support operational and strategic decision-making.
Develops, maintains, and enhances Tableau dashboards and reports using analytics-engineered data models.
Enables self-service analytics by delivering clean, trusted, and accessible datasets to business users.
Applies strong SQL and data modeling practices to ensure high-performance query execution and data integrity.
Utilizes Python for data processing, automation, and analysis where applicable.
Participates in version control processes using Git, including code reviews, documentation, and collaboration workflows.
Supports orchestration and scheduling of data workflows using tools such as Airflow or similar frameworks.
Establishes and promotes analytics engineering standards, including testing, documentation, and deployment best practices.
Collaborates with cross-functional teams to ensure alignment between data solutions and business objectives.
Works independently with minimal oversight, applying critical thinking and problem-solving skills to deliver high-quality outcomes.
Executes ad hoc projects as assigned by direct supervisor.