Position: Senior Data Engineer for Lohika Digital Media Agency Project #8620
Company: Lohika
Experience required: 3y
English level: intermediate

Our current customer is a digital agency that connects brands and consumers. The agency is more than 400 people strong, manages over $600MM in media spend and deploys campaigns in 70 markets in many cities around the world. Our customer provides services for companies like Google, Viber, etc.

Responsibilities:
Extracting and processing data from different API’s
Working with ETL’s based on Big Data technologies: Apache Hadoop, Talend/Airflow, Hive, Google Cloud Platform
End-to-end data flows checks

Required Knowledge:
At least 5 years of experience with at least one RDBMS (Postgres, MySQL, SQL Server, etc.)
Expert in SQL writing and tuning techniques 
At least 2 years of experience with Big data tools (Hadoop, Hive, Spark, HBase, Kafka, etc.)
Experience with clouds (GCP - preferred, AWS)
Experience with at least one ETL tool (Talend, Informatica, Kettle, etc.)
At least 5 years of experience in data warehousing and multi-dimensional database
Upper-Intermediate level of English
Knowledge of Git
Agile methodologies 

Optional Knowledge:
Python development
Experience with designing and building Data lake
Experience with Presto
Experience with Looker
Bash/Shell scripting