jobapplier

Data Specialist (REMOTE)

Impact Brands, LLC

Skills

Required

  • Business Analytics
  • Data Science
  • SQL
  • window functions
  • data modeling
  • dimensional modeling
  • reusable metric definitions

Preferred

  • BigQuery
  • Dataform
  • Looker Studio / Power BI
  • marketing / e-commerce
  • data quality checks
  • cloud data warehouses
  • Git-based workflows
  • BI
  • alerting
  • dbt

About Impact Brands, LLC

  • 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.
  • 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!

Responsibilities

  • 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.

Requirements

  • Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Science, or a related field.
  • SQL skills, including joins, window functions, and the ability to troubleshoot queries and identify discrepancies in results.
  • Solid understanding of data modeling, including dimensional modeling and consistent, reusable metric definitions.
  • 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.

Preferred

  • Hands-on knowledge of cloud data warehouses, preferably BigQuery.
  • Familiarity with dbt and Dataform, including Git-based workflows.
  • 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.

Pay

from 1,600 €/mon. net Keep in mind that we are open to discussing a different salary based on your skills and competencies.

Benefits

  • Remote work.
  • We are a fully remote organization, allowing you to work from any location.
  • Home office budget.
  • A home office allowance and the possibility to choose between a MacBook or a Windows-based workstation.
  • Health and wellness budget.
  • We value your well-being - investment in your health is not just encouraged but actively supported.
  • More free time.
  • Enjoy 25+ Working Days of Holidays to recharge and relax from work.
  • Volunteering.
  • Embrace the opportunity to dedicate 2 paid days each year towards personal growth and community impact.
  • Personal development opportunities.
  • Improve yourself through training online.
  • Professional growth.
  • Exceptional performance is recognized and rewarded, offering opportunities for career advancement based on your contributions to our success.
  • Achievement Bonus.
  • We celebrate our company's successes by offering an annual bonus.
  • Our company products.
  • Get exclusive access to our health and wellness products.
  • Flatwork culture.
  • The chance to influence the company right from the start.
  • Team spirit.
  • Enjoy regular team-building activities and engaging online events.
  • And much more!
  • From a Welcome Package to other amazing perks – we’re always thinking of ways to show our appreciation for every team member.
  • Whether it's fun surprises or practical benefits, you’ll always feel valued.