Analytics Engineer

<h1><strong>Hi there! </strong></h1><p style="min-height:1.5em">We're <a target="_blank" rel="noopener noreferrer nofollow" href="https://sweedpos.com/#/"><strong><u>SweedPos</u></strong></a><strong>,</strong> a product-driven startup building an all-in-one cannabis retail platform. We’re looking for an <strong>Analytics Engineer</strong> to help us deliver high-quality, scalable, and trusted data models that power both client-facing and internal analytics. Fully remote.</p><h1><strong><br>About Us</strong></h1><p style="min-height:1.5em"><strong>At Sweed</strong>, we’re reimagining how cannabis retailers operate. Our <strong>enterprise-grade platform</strong> combines <strong>POS, eCommerce, Marketing, Analytics and Inventory Management </strong>into a single, seamless solution—eliminating the need for multiple third-party tools.</p><p style="min-height:1.5em">We believe in <strong>simplicity, efficiency, and innovation</strong>. That’s why we build for <strong>scalability and performance</strong>, making life easier for cannabis retailers while driving real business growth.</p><p style="min-height:1.5em"></p><h1><strong>Why We’re Doing This</strong></h1><p style="min-height:1.5em">At <strong>Sweed,</strong> we believe in the <strong>medicinal potential of cannabis.</strong> It has been shown to help with chronic pain, anxiety, depression, and many other conditions. Despite the lingering stigma, we see <strong>cannabis as a powerful tool for improving lives.</strong></p><p style="min-height:1.5em">The <strong>industry is evolving rapidly, </strong>and we’re here to drive that transformation—making cannabis retail more <strong>efficient, accessible, and customer-friendly.</strong></p><h1><strong><br>Where We Are Now</strong></h1><p style="min-height:1.5em">We’ve been on the market for <strong>7 years,</strong> continuously growing and refining our product. </p><p style="min-height:1.5em">Our focus is on <strong>earning customer trust</strong>, which means constantly <strong>improving our delivery processes</strong> and <strong>rolling out new features</strong>. At the same time, we navigate the <strong>complex legal landscape</strong> of the cannabis industry, ensuring our platform remains compliant and future-proof.</p><p style="min-height:1.5em"></p><h1><strong>Team Structure</strong></h1><p style="min-height:1.5em">Our <strong>total team size is over 200 people</strong>:</p><p style="min-height:1.5em"><strong>The development team is distributed globally </strong>and organized into <strong>cross-functional product teams.</strong> These teams typically consist of 8–12 members, including front-end and back-end developers, QA specialists, and analysts. <br>Each team is led by a Team Lead and a Product Owner, ensuring effective collaboration and clear direction.<br>Meanwhile, our<strong> CEO, account managers, and customer success team are based in the USA</strong>, working closely with us to align product development with business and user needs.</p><p style="min-height:1.5em"></p><h1><strong>Why This Role Matters</strong></h1><p style="min-height:1.5em">Our customers - cannabis retailers - rely on data to make daily business decisions. As an <strong>Analytics Engineer</strong>, your work will directly power these decisions via clean, performant, and well-governed data models.</p><p style="min-height:1.5em">You’ll be responsible for transforming raw data into reliable reporting layers — working closely with our <strong>Data Architect</strong>, engineers, product analysts, and sometimes even <strong>clients</strong>. You’ll also play a key role in enforcing data quality through testing and validation practices.</p><p style="min-height:1.5em"></p><h1><strong>What to do in the project?</strong></h1><ul style="min-height:1.5em"><li><p style="min-height:1.5em"><strong>Build and maintain analytics data models</strong> 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 maintainability</p></li><li><p style="min-height:1.5em"><strong>Implement data quality tests and validation logic</strong>, ensuring accuracy and trust across reporting layers</p></li><li><p style="min-height:1.5em">Own conformed dimensions as shared contracts across downstream consumers</p></li><li><p style="min-height:1.5em"><strong>Collaborate with the Data Architect</strong> to apply consistent modeling standards and support architecture evolution</p></li><li><p style="min-height:1.5em"><strong>Work with internal teams and sometimes clients</strong> to clarify requirements and align on metric logic</p></li><li><p style="min-height:1.5em"><strong>Translate business needs into robust, reusable data models</strong></p></li><li><p style="min-height:1.5em"><strong>Ensure the integrity of client-facing reports</strong>, including reliability, freshness, and metric correctness</p></li><li><p style="min-height:1.5em">Contribute to clear <strong>documentation, metric definitions, and data contracts</strong></p></li><li><p style="min-height:1.5em">Support the continuous improvement of our modern data stack: dbt, Trino, ClickHouse, Airflow, <a target="_blank" rel="noopener noreferrer nofollow" href="http://Cube.dev">Cube.dev</a>, Metabase</p></li></ul><p style="min-height:1.5em"></p><h1><strong>What professional skills are important for us?</strong></h1><ul style="min-height:1.5em"><li><p style="min-height:1.5em">5+ years of experience in analytics engineering, data engineering, or BI development</p></li><li><p style="min-height:1.5em">Strong SQL skills and hands-on experience with dbt</p></li><li><p style="min-height:1.5em">Solid understanding of data modeling for analytics/reporting, including fact/dimension and SCD patterns design</p></li><li><p style="min-height:1.5em">Experience writing and maintaining data quality tests (e.g. dbt tests, custom SQL assertions, test coverage frameworks)</p></li><li><p style="min-height:1.5em">Experience with modern cloud-based data warehouses (e.g. Snowflake, ClickHouse, Redshift, BigQuery)</p></li><li><p style="min-height:1.5em">Excellent spoken and written English — you’ll communicate with internal teams and sometimes with external clients</p></li><li><p style="min-height:1.5em">Grain fluency - instinct for when a join will fan out, double-count, or drop rows</p></li><li><p style="min-height:1.5em">Reconciliation thinking - can trace a wrong mart number back to its source</p></li><li><p style="min-height:1.5em">Metric definition - translates ambiguous asks into precise, defensible definitions</p></li><li><p style="min-height:1.5em">Ability to clearly explain data logic and metric definitions to non-technical stakeholders</p></li><li><p style="min-height:1.5em">Meticulous approach to documentation, testing, and ownership of data artifacts<br></p></li></ul><h1><strong>Nice-to-have</strong></h1><ul style="min-height:1.5em"><li><p style="min-height:1.5em">Trino / Presto specifically</p></li><li><p style="min-height:1.5em">Semantic layer experience (<a target="_blank" rel="noopener noreferrer nofollow" href="http://Cube.dev">Cube.dev</a>, dbt Semantic Layer, LookML)</p></li><li><p style="min-height:1.5em">Experience supporting client-facing dashboards or embedded analytics</p></li><li><p style="min-height:1.5em">Multi-tenant data warehouse experience</p></li></ul><p style="min-height:1.5em"></p><h1><strong>What Else Matters?</strong></h1><ul style="min-height:1.5em"><li><p style="min-height:1.5em"><strong>Proactivity </strong>– We love team members who take initiative and provide feedback</p></li><li><p style="min-height:1.5em"><strong>Critical thinking</strong> – We value problem-solvers who think beyond just writing code</p></li><li><p style="min-height:1.5em"><strong>Adaptability</strong> – Our industry is evolving fast, and we need people who thrive in change</p></li></ul><p style="min-height:1.5em"></p><h1><strong>What We Offer</strong></h1><ul style="min-height:1.5em"><li><p style="min-height:1.5em"><strong>Salary in USD</strong> (B2B contract with the US company)</p></li><li><p style="min-height:1.5em"><strong>100% remote</strong> – We’re a remote-first company, no offices needed!</p></li><li><p style="min-height:1.5em"><strong>Flexible working hours</strong> – Core team time: 09:00-15:00 GMT (flexible per team)</p></li><li><p style="min-height:1.5em"><strong>20 paid vacation</strong> days per year</p></li><li><p style="min-height:1.5em"><strong>12 holidays</strong> per year</p></li><li><p style="min-height:1.5em"><strong>3 sick leave</strong> days</p></li><li><p style="min-height:1.5em"><strong>Medical insurance </strong>after probation</p></li><li><p style="min-height:1.5em"><strong>Equipment </strong>reimbursement (laptops, monitors, etc.)</p></li></ul><p style="min-height:1.5em"></p><h1><strong>Hiring Process</strong></h1><ol style="min-height:1.5em"><li><p style="min-height:1.5em"><strong>Recruiter Call</strong> (up to 45 minutes) – Intro & expectations</p></li><li><p style="min-height:1.5em"><strong>Hiring Manage Call</strong> (up to 45 minutes) - Deep dive into your Data background</p></li><li><p style="min-height:1.5em"><strong>Technical Interview</strong> (up to 1.5 hours) – SQL, dbt, data modeling, and DQ test logic</p></li><li><p style="min-height:1.5em"><strong>Final Interview</strong> (up to 1 hour) – Chat with Data Architect and Product stakeholders</p></li></ol>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...