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.
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
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Lead enterprise data architecture across warehouses, data lakes, downstream applications, and AI workloads. Design data models, Medallion Architecture, ELT standards, semantic layers, APIs, access controls, and reusable datasets. Partner with business and BI teams to drive adoption, conduct architecture reviews, establish platform standards, and mentor data and analytics engineers. The role requires deep Snowflake, dbt, data modeling, pipeline, and semantic-layer expertise, with experience in AI data patterns and cloud infrastructure preferred.
Top Skills:
AWSAzureDatabricksDbtDelta LakeGCPGraphQLLlmsPower BIRagRestSnowflakeSnowflake Unity CatalogTableau
Information Technology
Designs and delivers Snowflake data architectures on AWS, including dbt-based data engineering and AI-enabled solutions. Leads RAG, vector search, embedding, semantic search, and analytics initiatives from proof of concept through production. Directs project teams, oversees solution quality and budgets, supports proposals and business cases, and serves as a trusted technical advisor to clients. Requires strong data engineering, governance, documentation, communication, and stakeholder-management skills, with travel as needed.
Top Skills:
AWSDbtEmbedding PipelinesGenerative AiPrompt OrchestrationRetrieval-Augmented GenerationSemantic SearchSnowflakeSQLVector Search
Artificial Intelligence • Information Technology • Professional Services • Analytics
Designs and oversees enterprise data architectures spanning databases, warehouses, lakes, integrations, and cloud environments. Translates business requirements into scalable, secure, and cost-efficient solutions; establishes data modeling, governance, quality, metadata, and security practices; guides engineers and analysts; optimizes infrastructure; and maintains architecture documentation. Requires extensive Databricks, data engineering, big data, cloud, and stakeholder leadership experience.
Top Skills:
Apache KafkaSparkAWSAzureData IntegrationData LakesData WarehousesDatabricksETLGCPHadoopMicroservicesNosql DatabasesRelational DatabasesServerless
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
