data specialist in health and wellness

IMPACT BRANDS; United States; Remote; USD 110,000 - 140,000; Full time

Benefits offered by this job

Home office allowance

MacBook or Windows workstation

Health and wellness budget

Online trainings and career growth

Job summary

IMPACT BRANDS is seeking a data analytics engineer to build and maintain warehouse models using BigQuery, Dataform, and dbt. You will manage marketing and sales data pipelines, map product data, and ensure data quality across platforms.

You will also create Looker Studio reports, define metrics, and communicate findings clearly to non-technical stakeholders. Remote work from the United States is supported, with growth opportunities in analytics and data governance.

Qualifications

• Bachelor’s degree in a related field is required.
• Strong SQL skills with joins, windows, and troubleshooting.
• Experience with cloud data warehouses (BigQuery).
• Familiarity with dbt, Dataform, and Git workflows.
• Ability to communicate findings to non-technical stakeholders.

Responsibilities

• Build, maintain, write, and review warehouse models using BigQuery, Dataform, and dbt.
• Maintain marketing and sales data pipelines and platform connectors.
• Own product and brand mapping and fix mismatches at the source.
• Build Looker Studio reports and data quality checks.

Skills

SQL

Data analysis

Communication

Education

Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Science, or related field

Tools

BigQuery

dbt

Dataform

Git

Looker Studio

Power BI

Job description

Описание

IMPACT BRANDS operates a family of health and wellness brands and is dedicated to improving people’s lives worldwide.

Задачи

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