Data Specialist

IMPACT BRANDS

. Build and maintain warehouse models in BigQuery using Dataform and dbt .

Posted 10/22/2026full-timeRemote • LithuaniaMid-LevelSenior💰 €1,600 per monthWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining data models in BigQuery using Dataform and dbt, with a strong focus on data quality checks and reporting through Looker Studio. Proficient in SQL and capable of communicating complex findings to non-technical stakeholders.

Highest-signal resume keywords

SQL ExpertiseBigQuery ProficiencyDataform KnowledgeLooker Studio ReportingData Quality Checks

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData ModelingDimensional ModelingData Quality ChecksTroubleshooting QueriesMetric DefinitionsPlatform ConnectorsData ReconciliationGit-Based WorkflowsCalculated Fields

Soft Skills

Attention to DetailPersistenceClear Communication

Tools & Technologies

BigQueryDataformDbtLooker StudioPower BI

Industry Keywords

Marketing DataE-Commerce DataFinanceBusiness AnalyticsData Science

Tech Stack

Tools & technologies

BigQueryCloudSQL

About the role

Key responsibilities & impact

Build and maintain warehouse models in BigQuery using Dataform and dbt
Write and review models, commit changes, and run releases
Maintain marketing and sales data pipelines, including platform connectors
Ensure new ad accounts and products land correctly in the warehouse
Own product and brand mapping and fix mismatches at the source
Investigate discrepancies from ad platforms through raw tables, transformed models, and reports
Build and maintain Looker Studio reporting, including data sources, calculated fields, and access
Build data quality checks and alerts
Reconcile numbers against external systems and partners
Document metric definitions such as active subscription, active customer, and churn
Answer Media Buying, Finance, and Operations questions using documented queries
Perform other assigned tasks

Requirements

What you’ll need

Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Science, or a related field
Excellent SQL skills, including joins and window functions
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 alerting is a strong advantage
Strong attention to detail and persistence in tracing numbers back to their source across every layer
Ability to communicate findings clearly to non-technical stakeholders
Excellent written and spoken English

Benefits

Comp & perks

Remote work; fully remote organization, allowing work from any location
Home office allowance
Choice between a MacBook or a Windows-based workstation
Health and wellness budget
25+ working days of holidays
2 paid volunteering days each year
Online training and personal development opportunities
Professional growth and career advancement opportunities
Annual achievement bonus
Exclusive access to company health and wellness products
Flatwork culture and opportunity to influence the company
Regular team-building activities and online events
Welcome package and additional perks