Position: BI Developer  #2882
Company: Zhuko.Net
Category: Other
Experience required: 3y
English level: intermediate

Responsibilities:
Develop and maintain company’s BI system (integrate new data sources, add new measures and dimensions to existing data model);
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;
Keep track of main KPI metrics, investigate business problems, offer new indicators that would help to monitor changes in business;
Participate in bonus program planning;
Review and improve marketing automation campaigns;
Develop other calculations for marketing and CRM (leaderboards, cashbacks etc.);
Conduct market research of 3rd party solutions with the aim to fulfill business needs, offer solutions that could improve company business processes;
Provide technical support to finance team;

Requirements:
Profound knowledge in T-SQL (query optimization, stored procedures; user-defined functions, views, triggers, indexes, linked servers); 
Hands on experience with SSIS and bcp Utility;
Basic skills in SQL Server administration;
Understanding rules of database normalization;
Experience with any of BI solutions;
Advanced Excel user (pivot tables, logical, statistical formulas);
Basic knowledge of Windows command line or Windows PowerShell;
Knowledge of at least one object-oriented programming language;
Understanding of forecasting models; 
Understanding differences between OLAP and OLTP approaches
Understanding the Data Warehouse design concepts
Ability to work independently, communicate with customers and manage tasks priorities;
Sufficient level of English in professional domain;

Will be a plus:
Knowledge of R or Python packages for statistical analysis;
Successful experience in forecasting models development;
Basic knowledge of PHP, JavaScript, VBA;
Experience with Qlik Sense;
Experience with MongoDB, PostgreSQL, MySQL;
Experience as a team manager;

What we offer:
Work with creative friendly team at interesting projects
Comfortable office in the city center
Competitve remuneration and social package
Medical insurance after probation period
Professional trainings and conferences
Career growth opportunities
Free corporate English lessons
Work and development in highly professional team