MS SQL Server DWH Developer (m/f/d)

MS SQL Server DWH Developer (m/f/d)

We are on the lookout for an experienced MS SQL Server DWH developer to join our office in Vienna and contribute to the world of electronic payments.

Are you keen on DWH design and implementation, improving the performance and resilience of ETL in SQL Server? Will you enjoy taking ownership of the development of our DWH solution which includes ETL of large datasets (SSIS) powering numerous OLAP cubes (SSAS) and reports (SSRS)?

In this challenging position, you will be taking ownership of the DWH development process. There will be opportunity to work on our long-term migration projects making use of cloud technology such as Azure Data Factory.

Your area of responsibility:

• Take ownership of the DWH development project;
• Design and implement all aspects of DWH solution based on MS SQL server;
• Maintain Data integrity through OLTP/DWH;
• Query Optimization, Database tuning, Coding Triggers, Complex Views, Indexes and Stored Procedures;
• Support and maintain Data warehouse solutions using SSIS, SSRS and SSAS;
• 8x5 3rd level production support of DWH databases.

Your Profile:

• At least 5 years of DWH programming experience building high volume, mission critical, data-driven applications;
• At least 1 year of experience with MS SQL Server administration;
• Database design and optimization experience with very large and highly available databases utilizing directly attached or SAN storage, clustering, partitioning, mirroring and replication, backup, etc.;
• Very good working knowledge of the physical data model design and DDL, Table and index design with optimization in high volume batch load environments, stored procedures, triggers, user-defined functions, etc.;
• Very good working knowledge of SSIS, SSRS, SSAS;
• Experience with other RDBMS or NoSQL databases, interest in DevOps, Continuous Delivery, end-to-end automation, cloud computing, self-service interfaces, lean/agile principles are a plus.

Our offer:

• Minimum annual gross salary 45.000 EUR based on the collective bargaining agreement, additional payment possible according to experience and qualifications;
• Attractive bonus package and other employee benefits;
• A diversified range of activities in an international environment;
• Young and dynamic team with ambitious yet realistic objectives for the future;
• Open communication culture.

apply now