Analytics/Data Engineer

Analytics / Data Engineer We're Sweed, a product-driven company building an all-in-one cannabis retail platform. We're looking for an Analytics / Data Engineer to help us build reliable, scalable, and trusted data models that power both client-facing and internal analytics.This role is fully remote and is currently planned as a full-time short-term contractor engagement focused on a major analytics platform migration initiative. At the same time, we see strong long-term potential for the right person as the platform and team continue to grow.We're also open to considering a part-time setup (around 4 hours/day) for candidates with particularly strong and relevant experience.About Us At Sweed, we're reimagining how cannabis retailers operate. Our enterprise-grade platform combines POS, eCommerce, Marketing, Analytics, and Inventory Management into one seamless solution - helping retailers replace multiple disconnected tools with a unified operating system.We've been on the market for 7+ years and continue to grow, refine our product, and support cannabis retailers in a complex and highly regulated industry.Why This Role Matters We're currently migrating our analytics and reporting ecosystem from several legacy systems to a new modern data platform.This is not a pure BI or dashboard-building role. The main focus is on building reliable data marts, migrating reporting logic, improving data quality, and helping us mature our analytics engineering practices.You'll work closely with our Data Architect, Analytics Engineers, Data Engineers, and Client Reporting team. The role sits between analytics and data engineering: we need someone who can understand business requirements, but also think technically about pipelines, partitioning, query performance, modeling, and reconciliation.Current Data Context Our current landscape includes several legacy layers built around ClickHouse and Snowflake. We're now moving toward a more scalable modern data stack centered around dbt + Trino.ClickHouse is still heavily involved in the legacy environment, so experience with ClickHouse - especially around migration, optimization, and reconciliation - would be a strong plus.The environment is still evolving. Some parts of CI/CD, testing, documentation, and data quality processes are already in place, while others are actively being built and improved.Team Setup You'll join the Data Layer team, which currently includes:Data Architect / Team Lead3 internal Analytics Engineers1 external contractorclose collaboration with the DWH / Data Engineering teamregular interaction with the Client Reporting team as the main internal stakeholderThe DWH team owns ingestion, replication, source systems, and infrastructure. The Data Layer team owns the transformation and analytical layer after the data lands: dbt models, marts, reporting logic, reconciliation, documentation, and data contracts.What You'll Do Build and maintain analytics data models using dbt - incremental pipelines (merge strategies, hashdiff, SCD Type 1/2) across retail domains (sales, inventory, loyalty, marketing, promotions), with strong emphasis on structure, documentation, and maintainabilityImplement data quality tests and validation logic, ensuring accuracy and trust across reporting layersOwn conformed dimensions as shared contracts across downstream consumersCollaborate with the Data Architect to apply consistent modeling standards and support architecture evolutionWork with internal teams and sometimes clients to clarify requirements and align on metric logicTranslate business needs into robust, reusable data modelsEnsure the integrity of client-facing reports, including reliability, freshness, and metric correctnessContribute to clear documentation, metric definitions, and data contractsSupport the continuous improvement of our modern data stack: dbt, Trino, ClickHouse, Airflow, Cube.dev, MetabaseWhat We're Looking For 5+ years of experience in analytics engineering, data engineering, BI development, or similar data-focused rolesStrong SQL skillsHands-on experience with dbtSolid understanding of analytical data modeling: facts, dimensions, grains, SCD patterns, data martsUnderstanding of ETL/ELT pipelines and reporting layersExperience with query optimization, partitioning, incremental models, and data pipeline reliabilityExperience with data reconciliation and investigating inconsistent metricsAbility to work with business requirements and ask strong clarifying questionsGood written and spoken EnglishStrong ownership mindset and ability to work autonomously in a fast-changing environmentWillingness to learn, adapt, and dive deeper into technical detailsNice to Have Trino / Presto experienceClickHouse experienceAirflow experienceExperience with Metabase, Superset, Cube.dev, Looker, Tableau, or similar BI / semantic layer toolsExperience with data contractsExperience with retail, marketplace, eCommerce, fintech, payments, or transactional dataExperience in migration projectsExperience working in distributed / remote teamsWhat Else Matters This role is best suited for someone who enjoys the middle ground between analytics and engineering.You probably won't enjoy this role if you only want to build dashboards or only want to work on pure infrastructure. We need someone who can take a requirement, understand the business logic behind it, design the model, implement it in dbt, validate the result, and ensure the reporting layer can actually be trusted.The environment is still evolving, so we value people who are comfortable with ambiguity, changing priorities, and imperfect processes.What We Offer Salary in USDB2B contract with a US company100% remote setupFlexible working hoursCore collaboration time: 09:00–15:00 GMT20 paid vacation days per year12 holidays per year3 sick leave daysMedical insurance after probationEquipment reimbursementHiring Process Recruiter Call — up to 45 minutesTechnical Interview — up to 1.5 hours (SQL, dbt, modeling, reconciliation, and data quality logic)Final Interview — up to 30 minutes