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!
