Data Specialist (REMOTE)

Impact Brands, LLC; United States; Remote; USD 65,000 - 90,000; Full time

Benefits offered by this job

Remote work

Home office budget

Health and wellness budget

25+ holidays per year

2 paid volunteering days

Job summary

IMPACT BRANDS is a fully remote data-driven company helping health and wellness brands grow globally. We are looking for a Data Specialist to build and maintain warehouse models in BigQuery, with Dataform and dbt, and to keep marketing and sales data pipelines healthy.

You will own product/brand mapping, investigate data discrepancies, and develop Looker Studio reports. We value curiosity, initiative, and collaboration across teams.

Qualifications

• Build and maintain the models in our warehouse using BigQuery, Dataform and dbt.
• Keep marketing and sales data pipelines healthy to ensure new ad accounts and products land in the warehouse correctly.
• Own product and brand mapping and fix mismatches at the source rather than patching reports.
• Investigate discrepancies across layers from ad platform to charts.
• Build and maintain Looker Studio reporting with data sources and calculated fields.
• Create data quality checks and alerts to catch missing or broken data early.
• Reconcile numbers against external systems and document metric definitions.

Responsibilities

• Design and maintain data models in the warehouse (BigQuery).
• Maintain data pipelines and platform connectors for marketing and sales data.
• Map products and brands, fix source-level mismatches.
• Troubleshoot discrepancies across data layers.
• Develop Looker Studio reports and dashboards.
• Implement data quality checks and alerting mechanisms.
• Cross-functionally answer questions with reproducible queries.

Skills

BigQuery

Dataform

dbt

SQL

Data pipelines

Data quality checks

Discrepancy investigation

Communication

Education

Bachelor's degree in a relevant field

Tools

BigQuery

Looker Studio

dbt

Job description

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.