Senior Analytics Engineer

Renew Cannabis Co.; Chicago, Northern (IL, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

C3 Industries in Chicago seeks a Senior Analytics Engineer to design, build, and maintain enterprise data models powering reporting across Retail, Cultivation, Manufacturing, Marketing, and Finance. You will transform raw data into governed, reusable models in Snowflake and move business logic out of disparate reports.

The role emphasizes hands-on data modeling, collaboration with analysts and stakeholders, and mentoring on SQL, data quality, and transformation best practices.

Qualifications

• Bachelor's degree or equivalent in CS/IS/Analytics/Engineering.
• 4+ years building production data models and pipelines in a cloud data warehouse; Snowflake preferred, BigQuery a plus.
• Advanced SQL, including window functions, performance tuning, and incremental processing patterns.
• Experience with dbt or equivalent transformation framework and ingestion tools like Airbyte, dlt, or Fivetran.
• Power BI experience including semantic models and DAX; exposure to Fabric/Looker/Sigma is a plus.
• Proficiency with Git-based workflows, code review, and CI/CD for data.
• Python or similar scripting for pipelines and automation.
• Clear written documentation habits and ability to work with non-technical stakeholders.

Responsibilities

• Design, build, and maintain Snowflake transformation models for reporting across Retail, Cultivation, Manufacturing, Marketing, and Finance.
• Refactor business logic from Power BI datasets into governed, tested warehouse models.
• Build and maintain data ingestion pipelines and consolidate data into Snowflake.
• Define a consistent modeling approach with naming standards, grain, and conformed dimensions.
• Implement automated data quality tests and monitor their results; own remediation.
• Document models and lineage for self-serve analytics.
• Translate reporting requirements into durable data models in collaboration with stakeholders.
• Support semantic layer and BI tooling; evaluate new platform tools like Fabric, dbt, and Sigma.
• Cross-train with the team and mentor analysts on SQL and data quality.

Skills

Advanced SQL

Python

Documentation

Stakeholder communication

Cloud data warehouse

Education

Bachelor's degree or equivalent in CS/IS/Analytics/Engineering

Tools

Snowflake

BigQuery

dbt

Airbyte

dlt

Fivetran

Power BI

Microsoft Fabric

Looker

Omni

Sigma

Git & CI/CD

Job description

JOB SUMMARY

The Senior Analytics Engineer is responsible for designing, building, and maintaining the enterprise data models that power reporting and analytics across C3 Industries and High Profile Cannabis Shops. Leveraging Snowflake and Power BI, the role transforms raw data into documented, tested, reusable models the business can trust, and pulls the business logic currently embedded in individual reports into a governed transformation layer. This is a hands-on senior individual contributor role with significant influence over how C3 models its data as the company adds business units, systems, and locations.

JOB DUTIES

Core duties and responsibilities include the following. Other duties may be assigned.

• 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

None. This role mentors analysts and leads project work without direct reports.

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.