Social Discovery Group logo
Social Discovery Group

Senior Cloud DWH Architect / Data Architect

We are looking for a Senior Cloud DWH Architect.

Your main tasks will be:

  • Lead the migration of an existing MS SQL Server data warehouse to Google BigQuery;
  • Design, implement, and optimize a robust and scalable cloud data architecture tailored to business needs;
  • Develop and manage ETL/ELT pipelines using dbt or any other transformation framework for seamless data transformation and integration;
  • Collaborate with stakeholders to gather requirements and align the architecture with business objectives;
  • Ensure high performance, security, and cost-efficiency of the new cloud data platform;
  • Establish best practices for data modelling, query optimization, and data governance in the cloud environment.

We expect from you:

  • Familiarity with cloud platforms (GCP preferred) and associated services;
  • Knowledge of best practices for cloud data security, compliance, and cost management;
  • Proven expertise in Google BigQuery, including data modelling, schema design, and performance tuning;
  • Proficiency in Python is mandatory.

Nice to have:

  • Solid understanding of MS SQL Server and experience migrating workloads to the cloud;
  • Experience with dbt for building and managing transformation workflows.;
  • Experience with Superset, Looker, SSRS (or other BI solutions);
  • Exposure to other cloud platforms like AWS or Azure.;
  • Experience implementing data governance frameworks;
  • Knowledge of modern DevOps practices and version control systems like Git.

What do we offer:

  • REMOTE OPPORTUNITY to work full time;
  • Vacation 28 calendar days per year;
  • 7 wellness days per year (time off) that can be used to deal with household issues, to lie down and recover without taking sick leave;
  • Bonuses up to $5000 for recommending successful applicants for positions in the company;
  • Full payment for professional training, international conferences and meetings;
  • Corporate discount for English lessons;
  • ​Health benefits. According to the paychecks, if you are not eligible for corporate medical insurance, the company will compensate you with up to $ 1,000 gross per year per employee. This can be spent on self-purchase of health insurance or on doctor’s fees for yourself and close relatives (spouse, children);
  • ​Workplace organization. The company provides all employees with an equipped workplace and all the necessary equipment (table, armchair, wifi, etc.) in our offices or co-working locations. In the other locations, the company provides reimbursement of workplace costs up to $ 1000 gross once every 3 years, according to the paychecks. This money can be spent on the rent of the co-working room, on equipping the working place at home (desk, chair, Internet, etc.) during those 3 years;
  • Internal gamified gratitude system: receive bonuses from colleagues and exchange them for time off, merch, team building activities, massage certificates, etc.

Sounds good? Join us now!

Ready to apply for this role?

Apply Now β†’

Related jobs

Apply Now β†’