Job
- Level
- Experienced
- Job Field
- BI, Database
- Employment Type
- Full Time
- Contract Type
- Permanent employment
- Salary
- from 4.500 € Gross/Month
- Location
- Vienna
- Working Model
- Hybrid, Onsite
Job Summary
In this role, you will develop complex data models for SQL Server and Oracle, maintain OLAP cubes and BI applications, and optimize DWH components for data preparation and transformation for accurate reporting and planning.
Job Technologies
Your role in the team
- Are you excited about the practical implementation of data-driven reporting and planning solutions? The Management Reporting team develops all components and takes responsibility for planning and calculation applications based on Cognos Planning Analytics; designing and developing strategic, cross-domain reporting applications, especially in the data domains of HR and financial data, is another focus area — for this, we are looking for an experienced Data Warehouse Engineer with several years of professional experience.
- They develop logical and physical data models for SQL Server as well as Oracle Data Warehouse databases for the Data Warehouse systems of the Magistrate of the City of Vienna.
- They develop and maintain independently Cubes, In-Memory OLAP Tabular Models, and Data Marts based on Microsoft SQL Server Analysis Services (SSAS) as the data foundation for reporting and analysis applications.
- You are responsible for the development and maintenance of Data Warehouse (DWH) applications and Business Intelligence (BI) applications for smaller initiatives and projects.
- They independently develop DWH components for data preparation and transformation.
- They model and aggregate large datasets to provide high-performance analysis and planning data.
This text has been machine translated. Show original
Our expectations of you
Qualifications
- You have very good knowledge of the architecture (development, design, and data population) of relational database systems (e.g., MS-SQL Server).
- They have solid knowledge in the development of OLAP systems, e.g., Microsoft SQL Server Analysis Services (dimensional cubes and tabular models).
- You have very good knowledge of ETL tools (e.g., Microsoft Integration Services).
- You have good knowledge of logical and physical data modeling.
- You can demonstrate good German language skills (at least level B2).
- You are goal-oriented and enjoy delving into topics.
- You are pleased to see the results of your work reflected in the city.
Experience
- You have several years of professional experience in developing Data Warehouse solutions and data extraction and transformation solutions.
This text has been machine translated. Show original
Benefits
Food & Drink
More net
Health, Fitness & Fun
Work-Life-Integration
Job Locations
Topics that you deal with on the job
This is your employer
Stadt Wien
Wien
The Magistrat of the City of Vienna employs approximately 65,000 workers, including the companies "Wiener Krankenanstaltenverbund" and "Wiener Wohnen". Of those employees, nearly half work for the company "Wiener Krankenanstaltenverbund". The wide range of services offered can be seen from the 260 different job groups.
Description
- Company Type
- Established Company
- Working Model
- Hybrid, Onsite
- Industry
- Public Service, Unions
Data Warehouse Engineer
- Salary
- from 4.500 € Gross/Month
- Location
- Vienna
- Working Model
- Hybrid, Onsite
- Diversity
- Open for all genders
