Terrabis Logo

Terrabis

Data Architect

Posted 7 Days 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

5 Days Ago
Remote
United States
Expert/Leader
Expert/Leader
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Lead complex data analyses, develop statistical models, write advanced SQL, build data models and dashboards, and establish technical standards for analytics. Mentor analysts, troubleshoot data quality and modeling challenges, partner with data engineering, translate ambiguous business questions into rigorous analyses, and communicate findings to senior stakeholders. Own the analytics function’s technical roadmap while ensuring data privacy and security practices.
Top Skills: A/B TestingCcpaData ModelingData WarehousingDatabricksETLGdprLookerPower BIRegression AnalysisSnowflakeSQLTableau
18 Days Ago
Remote or Hybrid
US
128K-193K Annually
Senior level
128K-193K Annually
Senior level
Information Technology
Designs and delivers Microsoft Fabric, Azure AI, Power BI, and generative AI architectures for enterprise clients. Leads solution design, prototyping, implementation readiness, governance, quality assurance, and client enablement across complex engagements. Develops AI solution patterns including RAG, vector search, embeddings, semantic search, and prompt orchestration. Leads project and client teams, supports business cases and proposals, reviews technical deliverables, manages risks, and serves as a trusted technical advisor.
Top Skills: AzureAzure AiAzure Ai SearchAzure OpenaiCi/CdCopilotEltEmbeddingsGenerative AiMicrosoft FabricOnelakePower BIPrompt EngineeringPysparkPythonRbacRetrieval-Augmented GenerationSemantic SearchSparkSQLVector Search
3 Hours Ago
Remote
United States
Senior level
Senior level
Cloud • Information Technology
Designs and implements Google Cloud database migration strategies, including architecture, data models, database objects, pipelines, orchestration, security, and data transfers. Advises customers on Cloud Spanner and Cloud SQL implementations, translates SQL and stored procedures, configures Google Cloud components, performs performance testing, resolves performance issues, and delivers technical workshops and architectural recommendations.
Top Skills: Cloud SpannerCloud SqlCockroachdbGCPMySQLOraclePostgresSQL

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account