Data Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist in designing and maintaining a scalable data architecture that integrates POS, e-commerce, CRM, and marketing platforms.

• Support the management of the centralized Snowflake data warehouse.

• Oversee ETL/ELT pipelines for automated data collection, processing, and transformation.

• Guarantee data quality, integrity, and availability through rigorous validation and monitoring.

• Collaborate with department leaders to align data initiatives with strategic objectives.

• Aid cross-functional leaders in utilizing data to address complex business challenges.

• Deliver analytical insights related to pricing, inventory, customer segmentation, and marketing optimization.

• Establish and implement data governance policies to ensure compliance with cannabis industry regulations.

• Maintain comprehensive documentation for data architecture and analytics procedures.

• Lead the integration of new tools and optimize their usage.

⛳️ Requirements

• A Bachelor's degree in Computer Science, Data Science, Engineering, Statistics, or a related discipline.

• 2-3+ years of pertinent experience in designing and constructing data architectures, leading analytics, or data science teams, and driving business, customer, or marketing analytics.

• Advanced SQL proficiency, including window functions, CTEs, and query optimization techniques.

• Strong skills in dimensional modeling, including the design of fact and dimension tables, grain declaration, and surrogate key management.

• Proficient in handling JSON and semi-structured data.

• Practical experience with dbt or similar SQL-first data transformation frameworks, encompassing testing and documentation.

• Familiarity with cloud data warehouses like Snowflake or BigQuery; experience with Snowflake is highly advantageous.

• Proficient with BI tools such as Power BI, Looker, or Tableau.

• Skilled in Python for data manipulation, scripting, and workflow automation.

• Experience using Git and CI/CD for version control, testing, and deploying data pipelines.

• Knowledge of data orchestration tools such as Airflow, Prefect, or Rundeck.

• A collaborative mindset, excellent problem-solving abilities, and the capacity to communicate technical concepts to non-technical stakeholders.

• Experience in a regulated industry and eCommerce (B2C) is preferred.

🏝️ Benefits

• Competitive salary and performance-based incentives.

• Comprehensive health, dental, and vision insurance plans.

• Opportunities for professional development and continuous learning.

• Flexible work hours and potential for remote work.

• Collaborative and inclusive company culture.