Middle Software Engineer (MS SQL) (offline)

Required skills:
— 2+ years of professional work experience;
— Strong experience in T-SQL, procedures, functions, triggers, views and queries;
— Experience with Microsoft SQL Server 2012/2014/2016 and newer;
— Knowledge of PowerBI is considered a plus;
— Experience with SSRS, SSAS, SSIS, & SSDT;
— Working knowledge of MySQL databases;
— Knowledge and experience of Data Warehouse concepts;
— Problem solving skills;
— Strong written and verbal English communications skills.

As a plus:
— A degree in Computer Science, IT or related field is considered a plus.

We provide: 
— Direct employment, an e-commerce company. Not out staff/outsource;
— Agile culture, the continuous improvement process;
— Friendly and highly-qualified colleagues;
— Challenging international projects; 
— Competitive salary, yearly reviewed; 
— Real possibilities of growth;
— Direct employment with paid vacations & sick leaves;
— Flexible work schedule; 
— Excellent working conditions; 
— Powerful hardware, best software/tools;
— Learning and innovations — internal demos & trainings, individual mentorship; 
— Potential business trips /relocation to the USA;
— Ability to attend local & international conferences.

Responsibilities:
— Develop complex stored procedures, functions, triggers, views and queries in support of application development;
— Participate in application development projects and be responsible for the database architecture and design;
— Review and optimize existing stored procedures, functions, triggers and queries;
— Convert existing embedded SQL code into stored procedures;
— Develop custom scripts to automate various database management processes;
— Develop PowerBI reports;
— Define and review best practice standards for data integrity;
— Develop various ETL jobs for our Data Warehouse.