Position: Middle/Senior Data Engineer
Company: Lohika
Category: SQL
Experience required: 3y
English level: intermediate

**ABOUT THE PROJECT:**
Our customer is a digital agency that establishing links between the brand 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 such as Google, Viber, etc.

**MAIN TASKS AND RESPONSIBILITIES:**
End-to-end data flows checks
Data issues investigation
Data transfer maintenance
Support of existing Datalake (Hive, Talend, GCP) solution, issues troubleshooting
Support of existing solution of exporting data to BigQuery
Create new LookML explores and improve reporting dashboard
Client Feeds maintenance
Extension of ETL processes
Improvement of existing ETL processes and data transfers
Performance optimization
Direct communication with customer
Report to TL about current tasks status, technical or other risks

**EDUCATION, SKILLS AND EXPERIENCE:**
Strong knowledge of SQL 
Experience with SQL optimization and performance tuning 
Experience in building ETL processes, using ETL tools (Talend is a big plus, Informatica, MS SSRS) 
Experience with Big Data tools: Hive, Hadoop, Presto
Experience with BI tools (Looker is a big plus, Tableau, Pentaho) 
Experience in Data warehousing 
Upper-Intermediate level of English

**WOULD BE A PLUS:**
Knowledge and practical experience with Google Cloud tools 
Programming languages: Python
Docker
Bash/Shell scripting