Senior Software Engineer (MS SQL)

Required skills

— 3+ 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 offer

— 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.

Project description

Ecentria Is the Destination for All Things Gear.
Thousands of brands. Millions of products. Countless how-to guides and reviews. All powered by our proprietary eBusiness Platform and driven by our unrivaled expertise. We are Ecentria, and we serve those who play, work and serve with passion.

We work in teams using agile processes, peer code reviews, and continuous integration. The work includes the whole spectrum of web development tasks, such as writing web apps (both front-end and back-end work), web service consumers and providers, automated publishing tools for our stores and retail channels, and critical business analytics applications.

Ecentria is seeking a supremely talented Software Engineer!
This person will be working on the most complex projects being introduced in the company’s e-commerce web platform, leading technical discussions, mentoring other developers and enforcing best practices and coding standards on both a team and department level. This is a great opportunity for problem solvers who are comfortable tackling challenging problems in an Agile team environment.

Our technology stack includes the following:
Atlassian stack (Jira/Confluence/Bamboo/Stash)
PHP 7 / Symphony / MySQL/MS-SQL
React / JS / jquery. Redux, Typescrypt
ElasticSearch, RabbitMQ, Apache Cassandra
AWS/Azure