Position: Data Analyst #2929
Company: Zhuko.Net
Category: Data Science
Experience required: 1y
English level: upper
Published: 2020-03-01T00:00:00+02:00

Requirements:
Profound knowledge in T-SQL (query optimization, stored procedures; user-defined functions, views, triggers, indexes, linked servers)
Hands on experience with SSIS
Basic skills in SQL Server administration
Understanding the rules of database normalization
Experience with any of BI solutions
Advanced Excel user (pivot tables, logical, statistical formulas)
Basic knowledge of the Windows command line or Windows PowerShell
Knowledge of at least one object-oriented programming language
Understanding the Data Warehouse design concepts
Ability to work independently, communicate with customers and manage tasks priorities
Sufficient level of English in the professional domain

Would be a plus:
Basic knowledge of PHP, JavaScript, VBA
Experience with Qlik Sense
Experience with MongoDB, PostgreSQL, MySQL

We offer:
Become a part of a friendly team and working on interesting projects
Spacious office in the city center
Competitive remuneration
20 working days paid vacation
Paid sick leaves
Medical insurance
Free corporate English lessons

Responsibilities:
Conduct Ad-Hoc analysis and custom reporting with the aim to enforce marketing decisions, investigate technical issues, support finance calculations
Maintain and develop regular reporting
Maintain and develop ETL processes, that gather data from SQL DB, NoSQL DB, Services API
Ensure data consistency among sources
Develop other calculations for marketing and CRM (leaderboards, cashback, etc.)
Provide technical support to the finance team