Big Data Engineer for Lohika Digital Media Agency Project

Purpose of the job

Lohika company provides premium software engineering services to leading technology companies. Our customers usually range from startup to high growth and VC backed companies, which drives a culture of acceleration and innovation. We are sure that team extension is the only engagement model, which works best.

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. You're looking for your next big thing, aren't you? So are we, hoping it's you! Jump at your chance!

Main tasks and responsibilities:

• Design data warehouses according to data processing needs.
• Create and maintain ETL procedures and functions based on Big Data solutions.
• Perform end-to-end data flows checks.
• Develop analytical solutions, e.g. BI reports and dashboards.
• Develop data platform API endpoints for 3rd party application.
• Optimize existing data solutions.
• Report to Team Lead or supervisor about feature readiness/quality and raises red flags in crises.
• Provide training for other team members on his/her area of responsibility.
• Suggest technical and functional improvements to add value to the product.
• Collaborate with other R&D, QA, documentation and globalization teams.
• Constantly improve his/her professional level.

Education, skills and experience:

• At least 3 years of experience in data warehouse and multi-dimensional database design and development using formal methodologies
• At least 3 years of experience with at least one RDBMS, e.g. Postgres, Oracle, SQL Server, etc.
• Strong SQL writing and tuning techniques
• Experience with at least one ETL tool, e.g. Talend, Informatica, Kettle etc.
• Experience with at least one Big data tool: Hadoop, BigQuery, Hive, Presto, Spark
• Experience with at least one BI tool: Looker, Tableau, SSRS, Power BI
• Experience with Agile software development methodologies
• Upper-Intermediate level of English

Would be a plus:

• Experience with any cloud platform (e.g., Google Cloud Platform, AWS or similar)
• Experience in Java or Python development
• Bash/Shell scripting
• Knowledge of Git

Lohika benefits:

• Friendly and highly professional teams

• Flexible working hours with no overtime

• Regular performance reviews

• Internal training

• Comfortable office facilities (kitchens, gym, sports activities, yoga, lounge rooms, coffee machines, etc.)

• Christmas holidays (31st December -7th January) and state holidays

• Fully paid English classes (twice per week) with own English teachers and native speakers

• Premium Medical insurance (medication, massage, and doctor in the office, etc.)

• Paid sick-leaves

• Life insurance

• 20 working days of annual paid vacation

• Incentives (marriage, childbirth)

• Corporate events (corporate parties and sports competitions)

And much more!

Please send your CV or contact us with more questions!