Senior Cloud DWH Architect / Data Architect

1 Day ago • All levels

Job Summary

Job Description

Social Discovery Group (SDG) is seeking a Senior Cloud DWH Architect. The role involves leading the migration of an existing MS SQL Server data warehouse to Google BigQuery, designing and implementing a scalable cloud data architecture, developing and managing ETL/ELT pipelines, collaborating with stakeholders, and ensuring high performance and security of the new cloud data platform. The ideal candidate will establish best practices for data modeling and governance. The company offers a remote opportunity with benefits including vacation, wellness days, bonuses, professional training, English lessons, and health benefits.
Must have:
  • Lead migration of MS SQL Server data warehouse to Google BigQuery.
  • Design and implement a robust cloud data architecture.
  • Develop and manage ETL/ELT pipelines.
  • Ensure high performance, security, and cost-efficiency.
  • Proficiency in Python is mandatory.
Good to have:
  • Solid understanding of MS SQL Server.
  • Experience with dbt for transformation workflows.
  • Experience with BI solutions like Superset or Looker.
  • Exposure to other cloud platforms like AWS or Azure.
  • Experience implementing data governance frameworks.
Perks:
  • Remote opportunity to work full time.
  • 28 calendar days of vacation per year.
  • 7 wellness days per year.
  • Bonuses up to $5000 for referrals.
  • Full payment for professional training and conferences.
  • Corporate discount for English lessons.
  • Health benefits.
  • Workplace organization.
  • Internal gamified gratitude system.

Job Details

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.

          Sounds good? Join us now!

          Similar Jobs

          Wargaming - Senior Game Designer (World of Tanks Blitz)

          Wargaming

          Nicosia, Nicosia, Cyprus (Hybrid)
          1 Month ago
          GoReel - Senior Game Mathematician

          GoReel

          Bratislava, Bratislava Region, Slovakia (Remote)
          1 Month ago
          Xsolla - Senior Software Engineer (Monetization)

          Xsolla

          Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
          4 Weeks ago
          PlayStation Global - Software Engineer (Peripheral Devices)

          PlayStation Global

          Aliso Viejo, California, United States (On-Site)
          2 Weeks ago

          Get notifed when new similar jobs are uploaded

          Similar Skill Jobs

          Amber - Senior Development Tester

          Amber

          Bucharest, Bucharest, Romania (On-Site)
          1 Month ago
          AeraTechnology - Technical Support Lead

          AeraTechnology

          (Remote)
          1 Month ago
          Warner Bros Games - Staff Software Engineer in Test - SDET (GQA Team)

          Warner Bros Games

          Bengaluru, Karnataka, India (Hybrid)
          2 Weeks ago
          Plarium - Unity Developer (Battle team)

          Plarium

          Lviv, Lviv Oblast, Ukraine (Remote)
          1 Month ago
          Digital sun games - 3D Artist

          Digital sun games

          Valencia, Valencian Community, Spain (On-Site)
          1 Day ago
          plana technologies - .NET Developer

          plana technologies

          (Remote)
          1 Day ago
          Rebellion - Senior Online Developer - Tech Team

          Rebellion

          Oxford, England, United Kingdom (Hybrid)
          4 Weeks ago
          Sovrun - Candidate Engagement Specialist

          Sovrun

          Makati, Metro Manila, Philippines (Hybrid)
          1 Month ago
          Synechron - Senior Angular Developer

          Synechron

          Pune, Maharashtra, India (On-Site)
          1 Day ago
          CloudLinux - Senior Go Developer

          CloudLinux

          Masovian Voivodeship, Poland (Remote)
          1 Month ago

          Get notifed when new similar jobs are uploaded

          Jobs in Worldwide

          Looks like we're out of matches

          Set up an alert and we'll send you similar jobs the moment they appear!

          Similar Category Jobs

          Looks like we're out of matches

          Set up an alert and we'll send you similar jobs the moment they appear!

          About The Company

          Social Discovery Group (SDG) is the 3rd 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.
          View All Jobs

          Get notified when new jobs are added by Social Discovery Group

          Level Up Your Career in Game Development!

          Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

          Job Common Plug