CV successfully sent!
Error sending CV!
Active #2882
Hire Bonus
$$$
Key skills: T-SQL / SSIS / bcp Utility / BI solutions / OLAP / OLTP / Data Warehouse / SQL
BI Developer

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
level
specialty
city where you are looking for work
english level
salary not lower than