Position: Middle / Senior DWH Engineer
Company: DataRoot Labs
Category: SQL
Experience required: 2y
English level: intermediate

Requirements:
– Guru in SQL (writing complex queries using analytical functions etc)
– Good data modelling techniques knowledge and skills
– Understanding of DWH and Data Engineering patterns and practices, DWH architecture
— Experience with any column based analytical data base (we use Bigquery)

Nice to have experience with: 
— Python scripting — Apache Airflow
— ELT tools such DBT or Dataform
-- BI and dashboard tools
-- Familiarity with Data Quality tools and techniques

Responsibilities:
— Working closely with Data Science and Analytics team, writing complex SQL analytical and transformation queries in our DWH. This will be your main duty in the team.
-- Model data delivered by Data Engineers for convenience use by our analysts and data scientists.
-- Your SQL code must be well documented and written using our coding conventions, easy-to-read and easy-to-support
– Optimise existing queries.
-- Suggest ideas, make code reviews, take a part in team brainstorms. We like and encourage team-style work.
— Deploy queries and views, write and deploy schemas for them.
-- Monitor data pipelines (we use Apache Airflow)
– Support Data Scientists,  Data Analysts and Data Engineers  with SQL (you will be the main SQL guru in the team, so we expect you to share your experience with others)
— Assist in building data visualization dashboards (we use Google Data Studio, but going to migrate to Tableau) -- Write Bigquery custom functions using SQL or Javascript (we promise, this will happen rarely)
-- If you have decent Python programming skills, you can write Python services (but this is not required for this position and completely optional)
-- Document the data tables you work with

What we offer:
🌴 20 working days of annual vacation leave.
⛑ Caring policy for sick leaves.
📅 Flexible schedule, fully remote.
💻 Working with the newest technical equipment.
🌟 English courses, educational events & conferences are covered by the company upon request.
☑️ Accountant services are covered by the company.

PlayA is uniting gaming experts from various regions to build ML/AI-enabled solutions for the whole gaming ecosystem. Come join our Play-A league!