Job offer
Full Stack Data Warehouse & Reporting Engineer
Zuger Kantonalbank is looking for a full-stack data warehouse & reporting engineer to design, develop, and optimize interactive Power BI dashboards and contribute to a modern data warehouse architecture. The engineer will also develop and implement ETL/ELT processes and take charge of reporting operations and further development.
Job description
Full Stack Data Warehouse & Reporting EngineerYour tasks
- Design, development, and optimization of interactive Power BI dashboards (including data modeling and performance tuning)
- Advising departments on self-service BI, KPI definition, data strategies, and best practices
- Contribute to the strategy and development of a modern, Azure-based data warehouse architecture
- Development and implementation of ETL/ELT processes (Azure Data Factory, SQL, Data Vault)
- Setting up automated tests for data pipelines and reports, and ensuring high data quality
- Setting up and maintaining CI/CD pipelines and automating development and data processes
- Assuming responsibility for operations, requirements gathering, and continuous development of reporting
Our requirements
- Completed degree in computer science, business informatics, or comparable qualification
- Knowledge of SQL, ideally experience with Microsoft Azure Services (including Azure Synapse Analytics)
- Experience in reporting and business intelligence with a focus on Power BI (DAX, Power Query) required
- Knowledge of Data Factory, Blob Storage, SQL Database, Azure DevOps
- In-depth knowledge of data warehousing and dimensional modeling (Data Vault and Kimball)
- Experience with CI/CD pipelines, DevOps tools, and automated testing
- Analytical thinking, structured approach to work, and in-depth knowledge of ETL/ELT processes
- Very good knowledge of German
We offer
- Performance-related remuneration: 12 monthly salaries and a performance-related contribution based on the achievement of bank targets
- Home office: Whether in the office or at home—depending on your role, you decide where you can work best.
- Trust-based working hours: Thanks to trust-based working hours, you can organize your working hours flexibly.
- Vacation days and vacation purchase: With us, you get at least 28 vacation days. In addition, you have the option of purchasing up to 10 additional days to tailor your time off to your needs.
Job details