Analytics Engineer (SQL + Omni/Data Studio)

NO AGENCY. DO NOT CONTACT ME OUTSIDE OF UPWORK. We are a data consulting firm that builds analytics infrastructure in BigQuery for e-commerce brands. We are looking for a detail-oriented analyst to join our team on a part-time basis (20-30 hours per week), with availability every day between 8:00 AM and 12:00 PM Eastern Time. The Role: Our clients are e-commerce companies, and nearly everything we build revolves around their core data: web analytics, paid advertising, transactions, and subscriptions. You should already be familiar with these datasets and understand the kinds of questions e-commerce operators care about, whether that is ROAS by channel, subscription churn, conversion funnels, or LTV analysis. If this is the world you work in, you will ramp up quickly. Your primary focus will be building and maintaining dashboards and reports in Omni and Google Data Studio (formerly Looker Studio). You will translate modeled data into clear, reliable visualizations that help our clients make decisions. You should be comfortable navigating a star schema and understanding how dimensions and measures relate to underlying fact and dimension tables. Beyond reporting, you will write and maintain SQL models in dbt that answer specific business questions. You will be expected to validate the accuracy of your own work and follow pre-established naming conventions throughout the modeling layer. Requirements: - Hands-on experience working with e-commerce data, including web analytics, paid ads, transactions, and subscriptions - Strong experience building dashboards and reports in Omni and Google Data Studio (formerly Looker Studio) - Proficient in SQL, with hands-on experience writing models in BigQuery or dbt - Familiarity with star schema design and how it supports downstream reporting - Sharp attention to detail, especially around data accuracy and naming consistency - Fluent in English with strong written communication skills - Highly motivated and able to work independently Nice to Have: - Experience with dbt (getdbt.com) - Experience with GitHub - Experience with Google Analytics 4 - Experience leveraging AI Please include examples of dashboards you have built in the past. Screenshots, links, or case studies all work. We will only consider candidates who meet the core requirements and can commit to the stated availability. If that sounds like you, we would love to hear from you.