Data Specialist (REMOTE)

IMPACT BRANDS is a leading contributor to the health and wellness industry. With a journey from 5 to over 350 colleagues, and the expansion to a diverse family of 7+ brands (PureHealth Research, Nation Health MD, Pureance, Trumeta, PetMade, VitalPeak, Nature's Blast). We are dedicated to helping improve the lives of people all over the world.

At IMPACT BRANDS, we embrace remote work culture and cherish open-mindedness, high energy, and adaptability qualities that are essential in our dynamic environment. We prioritize the growth of every team member, regardless of their location, offering advancement from intern to leadership roles.

IMPACT BRANDS has already positively impacted the lives of 3 million people worldwide. Join us as a remote Data Specialist and let’s impact billions together!

• Build and maintain the models in our warehouse, working in BigQuery with Dataform and dbt. You write and review models, commit your changes, and run releases yourself.

• Keep our marketing and sales data pipelines healthy, including platform connectors, so that new ad accounts and new products land in the warehouse correctly from day one.

• Own product and brand mapping, and fix mismatches at the source rather than patching the report.

• Investigate discrepancies across every layer, from the ad platform through the raw tables and transformed models to the chart itself.

• Build and maintain reporting in Looker Studio, including data sources, calculated fields and access.

• Build data quality checks and alerts so that missing or broken data is noticed before anyone downstream sees it.

• Reconcile our numbers against external systems and partners, and document the definitions behind metrics such as active subscription, active customer and churn.

• Answer questions from Media Buying, Finance and Operations in plain language, backed by a query you can show.

• And 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, and the ability to troubleshoot queries and identify 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.

• Exposure to marketing or e-commerce data is a strong advantage.

• Knowledge of data quality checks and alerting is a strong advantage.

• Strong attention to detail and persistence in tracing numbers back to their source across every layer, from the platform to the final report.

• Ability to communicate findings clearly to non-technical stakeholders.

• Excellent written and spoken English.

Salary: from 1,600 €/mon. net 

Keep in mind that we are open to discussing a different salary based on your skills and competencies.