Data Specialist

This is a fully remote position, open to applicants in Lithuania.

📋 Description

• Develop and sustain warehouse models utilizing BigQuery, Dataform, and dbt.

• Write and evaluate models, commit updates, and execute releases.

• Oversee marketing and sales data pipelines, which include platform connectors.

• Ensure the accurate integration of new ad accounts and products into the warehouse.

• Take responsibility for product and brand mapping, rectifying mismatches at the source.

• Examine discrepancies from advertising platforms through raw tables, transformed models, and reports.

• Create and manage Looker Studio reporting, encompassing data sources, calculated fields, and access control.

• Establish data quality checks and alerts.

• Reconcile figures against external systems and partners.

• Document definitions for metrics such as active subscriptions, active customers, and churn rates.

• Address inquiries from Media Buying, Finance, and Operations using relevant queries.

• Execute additional tasks as assigned.

⛳️ Requirements

• Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Science, or a related discipline.

• Strong SQL proficiency, including the use of joins and window functions.

• Capability to troubleshoot queries and identify inconsistencies in results.

• Practical experience with cloud data warehouses, ideally BigQuery.

• Familiarity with dbt and Dataform, including Git-based workflows.

• Comprehensive understanding of data modeling, specifically dimensional modeling and the creation of consistent, reusable metric definitions.

• Proficiency in BI tools such as Looker Studio or Power BI.

• Experience with marketing or e-commerce data is a significant plus.

• Knowledge of data quality checks and alert systems is an added advantage.

• Exceptional attention to detail and a tenacity for tracing numbers back to their origin.

• Ability to effectively communicate findings to non-technical stakeholders.

• Excellent command of written and spoken English.

🏝️ Benefits

• Fully remote work; operate from any location within a completely remote organization.

• Home office allowance provided.

• Option to choose between a MacBook or a Windows-based workstation.

• Health and wellness budget available.

• 25+ working days of holiday entitlement.

• Two paid volunteering days each year.

• Opportunities for personal development through online training.

• Career advancement and professional growth opportunities.

• Annual achievement bonus offered.

• Exclusive access to company health and wellness products.

• Flat organizational culture with opportunities to influence the company.

• Regular team-building activities and online events.

• Welcome package and additional perks.