Analytics Engineer / Data Scientist (offline)

“The first page of the Internet” is the name of the platform that has brought together 500 million people around the world and thousands of communities with common interests and desire to share.

There are two departments with open roles, in one of which you can take part: Video Data Science or Economy Data team.

Tech skills we’re looking for:

✔ you have strong SQL skills and able to read and write complex SQL queries

✔ familiar with Airflow and creating ETLs from scratch

✔ a basic knowledge of Python is also required so they can deploy code in Airflow and also push code for metrics alerting, Amundsen and other internal data tooling changes.

What We Can Expect From You:

✔ need to be adept at working with remote teams with a substantial time zone difference (data team will be on Pacific Standard Time)

✔ ability to communicate progress and roadblocks

✔ be able to hit the ground running and adapt to existing data frames and data structures.

Job duties include:
✔ Build and maintain SQL repositories
✔ Perform quality checks on events and other data logs
✔ Clean up and maintain Airflow DAGs — including setting up complex dependencies, running backfills, investigating root causes of sequential failures etc.
✔ Build and maintain Mode dashboards (knowing Mode is NOT a requirement for the job)
✔ Set up and investigate metric alerts using 3rd party tools such as Anamalo
✔ Data documentation and creating wikis to help others understand and use our data
✔ Create weekly metrics reports that summarize the state of the business

Working schedule: flexible as long as you are available for meeting at 9AM PST twice a week.

Tech stack: SQL, Airflow/ETL experience, Python

What do we offer:

Benefits&Perks
• Great project from world-known company
• Stable long-term employment
• Personal Development Plan
• High level of team
• High-trust environment: no time-trackers and flexible working hours
• Opportunity to go on international business trips
• Paid vacation, sick-leave
• Subscription to popular educational resources and library with contemporary professional literature
• Official Ukrainian holidays are days off
• Corporate events
• English classes & speaking clubs
• Comfortable working environment