IB
Data Specialist
Contract type
Ongoing
Work mode
Remote
Experience
3 years
Job description
Remote Data Specialist role at Impact Brands, building and maintaining data warehouse models and marketing/sales data pipelines, and producing reporting for business stakeholders.
At a glance
- Work mode
- Remote
- Languages
- English
What you'll do
- Build and maintain the models in our warehouse, working in BigQuery with Dataform and dbt; write and review models, commit changes, and run releases
- Keep marketing and sales data pipelines healthy, including platform connectors, so 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 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
What we're looking for
- 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
- 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
Nice to have
- Exposure to marketing or e-commerce data is a strong advantage
- Knowledge of data quality checks and alerting is a strong advantage
Benefits
Home office budget - a home office allowance and the possibility to choose between a MacBook or a Windows-based workstation
- Remote work - fully remote organization, allowing you to work from any location
- Health and wellness budget
- 25+ Working Days of Holidays
- Volunteering - 2 paid days each year towards personal growth and community impact
- Personal development opportunities through training online
- Professional growth - exceptional performance is recognized and rewarded
- Achievement Bonus - annual bonus
- Our company products - exclusive access to health and wellness products
- Flatwork culture
- Team spirit - regular team-building activities and engaging online events
- Welcome Package and other perks
Apply
Direct apply at Impact Brands
Opens the job posting at Impact Brands
About Impact Brands
IMPACT BRANDS is a leading contributor to the health and wellness industry, with a diverse family of 7+ brands (PureHealth Research, Nation Health MD, Pureance, Trumeta, PetMade, VitalPeak, Nature's Blast). It has grown from 5 to over 350 colleagues and embraces a remote work culture.
Mission
Dedicated to helping improve the lives of people all over the world.
Key facts
- over 350 colleagues
- Health and wellness
- Expanded to a diverse family of 7+ brands
- Positively impacted the lives of 3 million people worldwide
- Fully remote organization
- Offers advancement from intern to leadership roles
What they value
- Open-mindedness
- High energy
- Adaptability
- Growth of every team member
- Flatwork culture
- Team spirit