Location
Tbilisi; onsite, remote, or hybrid work options available
Company
Andersen provides software development and technology services for clients across financial services and other industries.
What you will do
•Gather requirements from marketing analysts and BI stakeholders and translate them into attribution logic, source, and data mart changes.
•Lead the migration of attribution pipelines, including dbt models, Airflow DAGs, and data sources, while running legacy and new pipelines in parallel.
•Build and optimize incremental data marts in BigQuery using dbt and SQL, including recalculations and backfills.
•Design data quality checks, validate data, and investigate discrepancies across product and source systems.
•Analyze external inputs such as AppsFlyer data, advertising cost feeds, Google Sheets dictionaries, and upstream marts.
•Participate in testing, releases, downstream consumer repointing, documentation, and knowledge sharing.
Requirements
•3+ years of experience as an Analytics Engineer, DWH Engineer, or Data Analyst working with data warehouses.
•Strong understanding of data warehouse architecture, including ODS and data marts, as well as incremental loads, historical data handling, and deduplication.
•Expert SQL skills and experience designing and optimizing data marts.
•Hands-on experience with BigQuery or a similar columnar database, dbt on large incremental projects, and Airflow or a similar orchestration tool.
•Knowledge of Python for data processing and ETL tasks.
•English at Intermediate+ level or above, with the ability to work with stakeholders and translate business needs into data requirements.
Nice to have
•Experience with mobile and marketing attribution data, including AppsFlyer, Adjust, Branch, ad network cost data, SKAN, and ATT.
•Familiarity with ad fraud detection and AppsFlyer Protect360.
•Experience with GCP, Cloud Storage, or Dataform.
•Experience with Lightdash, Looker, Tableau, or other analytics and BI tools.
Culture & Benefits
•Remote, office-based, and hybrid work options.
•Mentoring, onboarding, professional development, and career growth opportunities.
•Corporate training portal and certification compensation.
•Private health insurance and sports activity compensation.
•Additional annual bonus of up to EUR 1,000 per month depending on expertise and participation in company activities.
•Referral program and corporate social activities.
