IMPACT BRANDS operates a family of health and wellness brands and is dedicated to improving people’s lives worldwide.
data specialist in health and wellness
подготовься к отклику
ai-инструментыЧтобы адаптировать резюме под вакансию или составить сопроводительное письмо, загрузи резюме
описание
задачи
- Build, maintain, write, and review warehouse models using BigQuery, Dataform, and dbt; commit changes and run releases independently
- Maintain marketing and sales data pipelines, including platform connectors, so new ad accounts and products are correctly loaded into the warehouse from day one
- Own product and brand mapping, and fix mismatches at the source rather than patching reports
- Investigate discrepancies across ad platforms, raw tables, transformed models, and charts
- Build and maintain Looker Studio reports, including data sources, calculated fields, and access
- Build data quality checks and alerts to detect missing or broken data before downstream users encounter it
- Reconcile figures against external systems and partners, and document metric definitions such as active subscription, active customer, and churn
- Answer questions from Media Buying, Finance, and Operations in plain language, supported by a query
- Perform other assigned tasks
требования
- Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Science, or a related field
- Excellent SQL skills, including joins, window functions, query troubleshooting, and discrepancy identification
- Hands-on knowledge of cloud data warehouses, preferably BigQuery
- Familiarity with dbt, Dataform, and Git-based workflows
- Solid understanding of data modeling, including dimensional modeling and consistent, reusable metric definitions
- Proficiency with BI tools such as Looker Studio or Power BI
- Strong attention to detail and persistence in tracing figures to their source across every layer, from platform to final report
- Ability to communicate findings clearly to non-technical stakeholders
- Excellent written and spoken English
- Будет плюсом: exposure to marketing or e-commerce data, knowledge of data quality checks and alerting
условия
- Remote work from any location
- Home office allowance and a choice between a MacBook or Windows-based workstation
- Health and wellness budget
- 25+ Working days of holidays
- Two paid volunteering days each year
- Online training and personal development opportunities
- Career advancement opportunities based on contributions and performance recognition
- Annual achievement bonus
- Exclusive access to company health and wellness products
- Regular team-building activities and online events
- Welcome package and other benefits
навыки
Если просят выйти из iCloud, прислать код из SMS, запустить или установить что-то, перевести деньги — не соглашайся: это мошенничество.