Senior BI Developer

Kiev, Ukraine

Experience:

— 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 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 of forecasting models
— Understanding differences between OLAP and OLTP approach
— 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:

— 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

We offer:

— Become a part of a friendly team and working on interesting projects
— Spacious office in the city center
— Competitive remuneration and social package
— Medical insurance
— Free corporate English lessons

Requirements:

— Develop and maintain the company’s BI system (integrate new data sources, add new measures and dimensions to the 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, cashback, 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 the finance team

Apply