Data Specialist (REMOTE)
Impact Brands, LLC
- Remote · Anywhere
- Remote
- Mid Level
- Bachelor's degree
- Posted
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.
