Senior Analytics Engineer

JOB SUMMARY:

Senior Analytics Engineer

JOB DUTIES:

• Design, build, and maintain transformation models in Snowflake that serve reporting across Retail (High Profile Cannabis Shops), Cultivation, Manufacturing, Marketing, and Finance.
• Refactor business logic out of Power BI datasets into governed, tested, version-controlled models in the warehouse.
• Build and maintain ingestion pipelines from C3's source systems, including consolidation of BigQuery marketing and ecommerce data into Snowflake.
• Define and apply a consistent modeling approach covering naming standards, grain, conformed dimensions, and a shared product and location master.
• Implement automated data quality testing and monitoring, and own resolution when tests fail.
• Document models and lineage so analysts can self-serve without relying on tribal knowledge.
• Partner with analysts and business stakeholders to translate reporting requirements into durable models rather than one-off extracts.
• Support the semantic layer and BI tooling, and contribute to evaluation of new platform tools such as Microsoft Fabric, dbt, Airbyte, dlt, Omni, and Sigma.
• Cross-train with the broader team and contribute to shared ownership of critical pipelines and models.
• Mentor analysts on SQL, modeling practice, and data quality.

SUPERVISORY RESPONSIBILITIES:

JOB REQUIREMENTS:

• Bachelor's degree in computer science, information systems, analytics, engineering, or a related field; equivalent experience considered.
• Minimum four years building production data models and pipelines in a cloud data warehouse; Snowflake experience strongly preferred, BigQuery a plus.
• Advanced SQL, including window functions, performance tuning, and incremental processing patterns.
• Demonstrated data modeling depth across dimensional modeling, slowly changing dimensions, and designing for reuse across multiple reporting consumers.
• Hands-on experience with dbt or an equivalent transformation framework, and with ingestion tooling such as Airbyte, dlt, or Fivetran.
• Working experience with Power BI, including semantic models and DAX; exposure to Microsoft Fabric, Looker, Omni, or Sigma a plus.
• Proficiency with Git-based workflows, code review, and CI/CD for data.
• Python or a comparable scripting language for pipeline and automation work.
• Clear written documentation habits and the ability to work directly with non-technical stakeholders.
• Cannabis, retail, CPG, or multi-site manufacturing experience a plus.

C3 Industries is led by a passionate, creative, and hardworking team of cannabis cultivation and processing experts. We produce the highest quality, indoor cannabis flower, and extracted products at our state-of-the-art facilities in Oregon and Michigan.

At C3I our product is cannabis, but our most important asset is our people. We believe in hiring locally, offering competitive compensation packages, and giving our employees an opportunity to learn and grow. As a company, we are committed to being active corporate citizens and community members and celebrate diversity and inclusion.