Data Architect
At a glance
Mid-level Data Architecture & Governance role at Terrabis. United States · full-time · $100,000–$115,000 base.
dataroles summary, based on the employer's posting.
What you'll do
- Help shape and maintain data systems that connect POS, e-commerce, CRM, and marketing platforms
- Keep the Snowflake warehouse and ETL/ELT workflows running, checking data for accuracy and availability
- Work with department leads to connect data projects to business priorities and provide insights on pricing, inventory, customers, and marketing
- Set data rules for regulatory compliance and document architecture and analytics processes
- Bring in new tools and help teams make effective use of them
What you bring
- A relevant bachelor’s degree and at least two years of experience in data architecture, analytics leadership, or data science leadership
- Advanced SQL skills, including query optimization, and experience building dimensional models with fact and dimension tables
- Hands-on use of dbt or a comparable SQL-based transformation framework, plus a cloud data warehouse such as Snowflake or BigQuery
- Python skills for data work and automation, along with experience using Git and CI/CD for pipeline changes
Who this fits
You’ll suit work that combines data infrastructure with business-facing analysis and collaboration across teams. The role is based in Illinois, with an annual salary range of $100,000 to $115,000.
From the employer
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
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance$100k+
Find me workBy the team behind dataroles.