Enterprise Data Warehouse & Analytics Specialist

Tech StaQ; Genf; On-site; CHF 110,000 - 140,000; Full time

Benefits offered by this job

Competitive benefits package

Ongoing training and certifications

Mentorship programs

Exposure to cutting-edge cloud data架构

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Data modeling

ETL development

Performance tuning

Regulatory awareness

Cross-functional collaboration

Education

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

Job description

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.