Data Specialist

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

📋 Description

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

• Create and assess models, commit updates, and initiate releases.

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

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

• Manage product and brand mapping, rectifying mismatches at the source.

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

• Construct and uphold Looker Studio reporting, including data sources, calculated fields, and access controls.

• Develop data quality checks and alerts.

• Reconcile figures against external systems and partners.

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

• Respond to inquiries from Media Buying, Finance, and Operations using documented queries.

• Execute other assigned responsibilities.

⛳️ 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 pinpoint discrepancies in results.

• Practical experience with cloud data warehouses, preferably BigQuery.

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

• Comprehensive understanding of data modeling, including dimensional modeling and consistent, reusable metric definitions.

• Expertise with BI tools such as Looker Studio or Power BI.

• Background in marketing or e-commerce data is a significant advantage.

• Knowledge of data quality checks and alert systems is a considerable advantage.

• Strong attention to detail and determination in tracing figures back to their source across all layers.

• Ability to articulate findings clearly to non-technical stakeholders.

• Excellent written and verbal English communication skills.

🏝️ Benefits

• Full remote work; a completely remote organization allowing you to work from anywhere.

• Home office allowance provided.

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

• Health and wellness budget available.

• More than 25 working days of vacation.

• Two paid volunteering days each year.

• Opportunities for online training and personal development.

• Professional growth and career advancement opportunities offered.

• Annual achievement bonus.

• Exclusive access to company health and wellness products.

• Flatwork culture with the opportunity to impact the company.

• Regular team-building activities and online events.

• Welcome package along with additional perks.