Enterprise Data Warehouse & Analytics Specialist

Tech StaQ; Genf; Vor Ort; CHF 110.000 - 140.000; Vollzeit

Benefits dieser Stelle

Competitive benefits package

Ongoing training and certifications

Mentorship programs

Exposure to cutting-edge cloud data架构

Zusammenfassung

Tech StaQ is seeking a Data Warehouse & Data Specialist to own the end-to-end lifecycle of the enterprise data warehouse. You will drive data ingestion, modeling, performance tuning, and cloud migration to Azure Fabric and Synapse, enabling data-driven decisions across the bank.

You will collaborate with analysts, data scientists, and IT operations to deliver high-quality data solutions, dashboards, and governance in a regulated environment.

Qualifikationen

• Bachelor's or master's degree in a related field.
• 3–5 years of enterprise Data Warehouse experience in finance/banking.
• Advanced SQL Server and indexing/partitioning skills.
• Strong SSAS, SSIS, and Azure Data Factory proficiency.
• Experience with Azure Fabric, Synapse, and data lake storage.
• Fluent in French and English; Dutch a plus.

Aufgaben

• Ingest data and manage ETL pipelines with SSIS and Azure Data Factory.
• Design and optimize SSAS models (Tabular & Multidimensional) and DAX/MDX measures.
• Tune performance via indexing, partitioning, and compression.
• Lead cloud migration to Azure Fabric and Synapse with governance and cost controls.
• Develop reports in Power BI and SSRS, translating requirements into dashboards.
• Collaborate across teams to improve warehouse architecture and data governance.
• Maintain technical documentation and data dictionaries to meet GDPR/FINMA.

Kenntnisse

Data modeling

ETL development

Performance tuning

Regulatory awareness

Cross-functional collaboration

Ausbildung

Bachelor's or Master's degree in Computer Science/IS

Tools

SQL Server

SSAS (Tabular & Multidimensional)

SSIS

Azure Data Factory

Azure Synapse Analytics

Azure Fabric

Azure Data Lake Storage

Power BI

Jobbeschreibung

Tech StaQ is seeking a Data Warehouse & Data Specialist to own the end-to-end lifecycle of the enterprise data warehouse. You will drive data ingestion, modeling, performance tuning, and cloud migration to Azure Fabric and Synapse, enabling data-driven decisions across the bank.

You will collaborate with analysts, data scientists, and IT operations to deliver high-quality data solutions, dashboards, and governance in a regulated environment.