Data Architect

Terrabis

. Help design and maintain scalable data architecture integrating POS, e-commerce, CRM, and marketing platforms.

Posted 11/4/2026full-timeRemote • United StatesJuniorMid-Level💰 $100,000 - $115,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining scalable data architecture, with advanced proficiency in SQL and experience in cloud data warehouses like Snowflake. Capable of providing analytical insights and ensuring data quality while adhering to compliance regulations in the cannabis industry.

Highest-signal resume keywords

Advanced SQL ProficiencyData Architecture DesignSnowflake ExperienceETL/ELT Pipeline ManagementData Governance Compliance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLDimensional ModelingPythonData TransformationData Quality AssuranceData AnalyticsData WarehousingJSON HandlingVersion ControlData Orchestration

Soft Skills

Collaborative MindsetProblem-Solving SkillsCommunication Skills

Tools & Technologies

SnowflakeBigQueryPower BILookerTableauDbtGitCI/CDAirflowPrefect

Industry Keywords

EcommerceB2CData GovernanceCannabis Industry Regulations

Tech Stack

Tools & technologies

AirflowBigQueryCloudETLPythonSnowflakeSQLTableau

About the role

Key responsibilities & impact

Help design and maintain scalable data architecture integrating POS, e-commerce, CRM, and marketing platforms.
Assist in managing the centralized Snowflake data warehouse.
Maintain ETL/ELT pipelines for automated data collection, processing, and transformation.
Ensure data quality, integrity, and availability through validation and monitoring.
Partner with department leads to align data projects with strategic goals.
Help cross-functional leaders leverage data to solve complex business problems.
Provide analytical insights for pricing, inventory, customer segmentation, and marketing optimization.
Develop and enforce data governance policies for compliance with cannabis industry regulations.
Maintain documentation for data architecture and analytics processes.
Lead new tool integrations and maximize their use.

Requirements

What you’ll need

Bachelor's degree in Computer Science, Data Science, Engineering, Statistics, or a related field.
2-3+ years of relevant experience in designing and building data architecture, leading analytics, or data science teams, driving business, customer, or marketing analytics.
Advanced proficiency in SQL, including window functions, CTEs, and query optimization.
Strong dimensional modeling skills, including designing fact and dimension tables, declaring grain, and managing surrogate keys.
Comfortable working with JSON and semi-structured data.
Hands-on experience with dbt or similar SQL-first data transformation frameworks, including testing and documentation.
Experience with cloud data warehouses such as Snowflake or BigQuery; Snowflake experience is a strong plus.
Experience with BI tools such as Power BI, Looker, or Tableau.
Proficiency in Python for data manipulation, scripting, and workflow automation.
Experience with Git and CI/CD for version control, testing, and deploying data pipelines.
Familiarity with data orchestration tools such as Airflow, Prefect, or Rundeck.
Collaborative mindset, strong problem-solving skills, and ability to communicate technical concepts to non-technical stakeholders.
Experience in a regulated industry and Ecommerce (B2C) preferred.