Data Specialist (REMOTE)

Impact Brands

3d•Remote

About The Position

IMPACT BRANDS is hiring a remote Data Specialist to support its health and wellness brands. The role builds and maintains the company’s data warehouse models and marketing and sales data pipelines, investigates data discrepancies, and develops reporting and data quality processes. The specialist works with teams including Media Buying, Finance, and Operations, explaining findings clearly and documenting metric definitions.

Requirements

Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Science, or a related field.
Excellent SQL skills, including joins, window functions, troubleshooting queries, and identifying discrepancies in results.
Hands-on knowledge of cloud data warehouses, preferably BigQuery.
Familiarity with dbt and Dataform, including 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 numbers back to their source across all data layers.
Ability to communicate findings clearly to non-technical stakeholders.
Excellent written and spoken English.

Nice To Haves

Exposure to marketing or e-commerce data.
Knowledge of data quality checks and alerting.

Responsibilities

Build and maintain warehouse models using BigQuery, Dataform, and dbt; write and review models, commit changes, and run releases.
Keep marketing and sales data pipelines and platform connectors healthy so new ad accounts and products are correctly added to the warehouse.
Own product and brand mapping, correcting mismatches at their source.
Investigate discrepancies across ad platforms, raw tables, transformed models, and reports.
Build and maintain Looker Studio reporting, including data sources, calculated fields, and access.
Build data quality checks and alerts to detect missing or broken data before it affects downstream users.
Reconcile company metrics against external systems and partners, and document metric definitions such as active subscription, active customer, and churn.
Respond to questions from Media Buying, Finance, and Operations with clear explanations supported by queries.
Complete other assigned tasks.