Senior MS SQL Developer & ETL Expert (m/w/d)

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

Your responsibilities:

  • Development of new and further development of existing data integration/ETL solutions based on MS SQL Server / SSIS
  • Continuous analysis of customer ETL processes and MS SQL Queries to identify improvement opportunities
  • Refactoring of existing queries and DWH data models to improve logic and performance
  • Development of an in-depth view of customer landscape and suggesting further topics to optimize the infrastructure, query, architecture, reporting, maintenance and change management processes of the customer’s ODS and DWH landscape
  • Later implementing new and migrating existing applications to MS Azure

Required Skills, Knowledge and Experience:

  • A university degree in computer science, business informatics, natural science, mathematics, or in a comparable course of study
  • 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


  • 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

What we offer:

  • 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