On Hold / Closed
#2882
BI Developer
Hire Bonus
$$$
Login to get bonus for Hire!
Key skills: T-SQL / SSIS / bcp Utility / BI solutions / OLAP / OLTP / Data Warehouse / SQL
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