Data Specialist

IMPACT BRANDS is a leading contributor to the health and wellness industry. 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! Our Treats: 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. Bits of your job: 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 Key expectations: 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 alertin