Terrabis Logo

Terrabis

Data Architect

Posted One Month Ago
Remote
Hiring Remotely in United States
100K-115K Annually
Mid level
Remote
Hiring Remotely in United States
100K-115K Annually
Mid level
Designs and maintains scalable data architecture, Snowflake warehouses, ETL/ELT pipelines, dimensional data models, and governance processes. Partners with business stakeholders to deliver insights for pricing, inventory, customer segmentation, and marketing optimization. Builds reliable analytics datasets and dashboards, integrates data tools, monitors data quality, and ensures compliance within the regulated cannabis industry.
The summary above was generated by AI

ABOUT US

Terrabis is a leading privately held cannabis company with a bold growth strategy. Operating in both wholesale and retail, we are at the forefront of the industry, setting new standards, and pushing boundaries. Join us in shaping the future of cannabis.


POSITION SUMMARY

Terrabis is seeking a Data Architect to assist in designing, implementing, and managing an innovative data infrastructure. This role will enable data-driven decision-making and innovation, aligning with the company's growth in the regulated cannabis industry. You will collaborate with the analytics team, along with other business stakeholders, to deliver tools and insights to propel the business forward.


RESPONSIBILITIES

Data Architecture and Infrastructure

  • Help design and maintain a scalable data architecture that integrates various systems, including POS, e-commerce, CRM, and marketing platforms.
  • Assist in managing our centralized data warehouse in Snowflake
  • Maintain ETL/ELT pipelines to automate data collection, processing, and transformation.
  • Ensure high data quality, integrity, and availability through regular validation and monitoring processes.

Business Partnership and Strategy

  • Partner with department leads to align data projects with strategic goals.
  • Be a thought partner to cross-functional leaders, helping them leverage data to solve complex business problems.
  • Provide analytical insights for pricing, inventory, customer segmentation, and marketing optimization.

Governance and Compliance

  • Develop and enforce data governance policies to ensure compliance with cannabis industry regulations.
  • Maintain documentation for all data architecture and analytics processes to ensure clarity and consistency.

Tooling and Innovation

  • Spearhead new tool integrations and maximize their use.

QUALIFICATIONS

  • 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) to clean and transform raw data into trusted, scalable datasets
  • 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 like Snowflake or BigQuery to build and maintain analytics-ready data models (Snowflake experience is a strong plus)
  • Experience with BI tools like Power BI, Looker, or Tableau to build reliable semantic layers and executive dashboards
  • 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 to schedule and monitor production pipelines
  • A collaborative mindset with strong problem-solving skills and the ability to communicate technical concepts to non-technical stakeholders
  • Experience in a regulated industry, and Ecommerce (B2C) preferred.

ADDITIONAL INFORMATION

Terrabis is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics.

Illinois Pay Range
$100,000—$115,000 USD

Similar Jobs

Yesterday
Remote or Hybrid
120K-140K Annually
Senior level
120K-140K Annually
Senior level
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Define and lead the architecture of NBCUniversal’s greenfield Microsoft Fabric enterprise data platform. Establish lakehouse, warehouse, integration, real-time streaming, data modeling, governance, security, DevOps, and observability standards. Translate architecture and business objectives into delivery roadmaps, epics, stories, and implementation plans while guiding multidisciplinary engineering teams. Design scalable solutions combining operational, historical, master, and reference data to support reporting, analytics, automation, AI, and reusable data products.
Top Skills: Amazon KinesisAPIsAzure DevopsAzure Event HubsBicepChange Data CaptureCi/CdData FactoryDelta LakeEventhouseEventstreamGithub ActionsKafkaLakehouseAzureMicrosoft FabricNotebooksOnelakePower BIPysparkPythonReal-Time IntelligenceSemantic ModelsSQLTerraformWarehouse
13 Hours Ago
Remote
USA
84K-106K Annually
Senior level
84K-106K Annually
Senior level
Information Technology • Consulting
Designs and owns Databricks lakehouse architecture, scalable batch and streaming pipelines, data governance, analytics models, and cloud infrastructure. Leads major platform migrations, establishes engineering and CI/CD standards, manages Terraform and FinOps practices, and prototypes AI use cases. The role advises stakeholders, mentors engineers, and ensures secure, compliant, cost-effective data platforms across cloud environments.
Top Skills: Amazon EmrSparkAWSAzureAzure DevopsCi/CdDatabricksDatabricks Asset BundlesFinopsGCPGitGithub ActionsHadoopLangchainLanggraphLlmsMedallion ArchitectureMlflowNoSQLOlapOltpOpenai ApisPysparkPythonScalaSpark SqlSQLTerraformUnity CatalogVector Databases
Yesterday
In-Office or Remote
70K-90K Annually
Junior
70K-90K Annually
Junior
Insurance
Build and govern curated analytical datasets, KPI definitions, data mappings, and reporting solutions in an Azure-based ecosystem. Analyze and validate complex data using SQL and Python, support data quality and reconciliation, and maintain cloud and legacy ETL workflows. Collaborate with business, architecture, and engineering teams on pipelines, semantic models, data lineage, migrations, and governance. Monitor Azure and Fabric platforms while improving performance, documentation, and self-service analytics capabilities.
Top Skills: Azure Data FactoryAzure Data Lake StorageAzure DevopsAzure SqlAzure SynapseCi/CdDelta LakeEvent HubsExcelInformaticaJSONMicrosoft FabricMicrosoft PurviewParquetPower BIPysparkPythonRestService BusSoapSQLXMLXpath

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account