>
  1. MS SQL Developer

MS SQL Developer

Adastra Hellas
Thessaloniki , Greece
1 year ago
Full Time
Mid-Level
-
Inactive

Basic Information

The Adastra Group is an international IT consulting company with 23 international offices headquartered in Toronto, Canada. Adastra provides leading companies with a full range of consulting services in information management - from conception to implementation and application of innovative Data & Analytics solutions. With over 2000 experts worldwide we bridge the gap between business departments and IT to increase the operational efficiency of our customers. For more information, please check www.adastragrp.com

We are looking for a passionate and driven MS SQL Developer to strengthen our team.

Responsibilities

What will your typical day to day look like? You will:

  • Further develop new and existing data integration/ETL solutions based on MS SQL Server / SSIS, 
  • Continuously analyse customer ETL processes and MS SQL Queries to identify improvement opportunities
  • Refactor existing queries and DWH data models to improve logic and performance
  • Develop an in-depth view of the customer landscape and suggest further topics to optimize the infrastructure, query, architecture, reporting, maintenance, and change management processes of the customer’s ODS and DWH landscape
  • Later implement new and migrate existing applications to MS Azure

Benefits

  • Working in an international team of Data & Analytics experts
  • A work environment where knowledge-sharing is coveted and which has an open feedback culture
  • Excellent opportunities for professional growth through industry-recognized projects for internationally-known clients
  • Support to fulfill your personal potential and individual career planning (Training and further education, participation in conferences, etc.)
  • Opportunities to take responsibility at an early stage
  • Flat hierarchies and an attractive salary & benefits package
  • Hybrid or remote working (depending on the specifics of security issues requested by clients)

Basic Requirements

  • 3+ years of working experience as a SQL Developer or equivalent role
  • Very good knowledge of SSIS and SSAS development and analysis skills
  • SQL Server performance optimization
  • T-SQL Query optimization skills
  • Analysis of execution plans, statistics, indexes
  •  ETL processes development/optimization
  • Clear and succinct verbal and written skills in English

Good to have

  • DWH data modeling knowledge
  • Experience with SSIS development/analysis
  •  SSAS skills (multidimensional), cube development/analysis (MDX)
  • Working knowledge of the Azure Platform is a big plus