Senior Cloud DWH Architect

Описание вакансии

Social Discovery Group (SDG) is the third-largest social discovery company in the world, uniting 60+ brands with 500 million users. We solve the problems of loneliness, isolation, and disconnection by transforming virtual intimacy into the new normal. Our portfolio includes online communication platforms focusing on AI, game mechanics, and video streaming—Dating.com, DateMyAge, Cupid Media, Dil Mil, Kiseki, and others.

SDG invests in IT startups worldwide. Our investments include Open AI, Patreon, Flo, Clubhouse, Woebot, Flure, Astry, Coursera, Academia.edu, and many others.

We bring together a team of like-minded people and IT professionals specializing in creating and developing globally impactful social discovery products. Our international team of 1200 professionals and digital nomads works worldwide.

Our teams of digital nomads work remotely from Cyprus, Malta, the USA, Armenia, Georgia, Kazakhstan, Montenegro, Poland, Latvia, Serbia, Spain, Portugal, UAE, Israel, Turkey, Thailand, Indonesia, Japan, Hong Kong, Australia and many other locations.

In August 2024, we achieved Great Place to Work US Certification™! This achievement reflects our core belief that a truly exceptional workplace is built on trust, pride, and camaraderie—not just great perks.

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.