About the job Data Warehouse Data SpecialistWe seek a highly motivated Data Warehouse Data Specialist to join our client's Data Engineering team. In this hands-on role, you will own the end-to-endlifecycle of our enterprise Data Warehouse, drive performance optimizations, and enable data-driven decision-makingacross the bank. You will collaborate closely with business analysts, data scientists, and IT operations to design, develop, and maintain reliable, high-quality data solutions in a regulated financial environment.Key ResponsibilitiesData Ingestion ETLOrchestrate and monitor daily data loads into the Enterprise Data Warehouse using SSIS and Azure Data Factory, ensuring data quality, lineage, and error-free processing.Data Modeling CubesDesign, build, and optimize SSAS Tabular and Multidimensional models; develop advanced DAX/MDX measures and time intelligence calculations for self-service analytics.Performance TuningAnalyze execution plans and implement indexing, partitioning, and compression strategies to optimize query performance for both OLTP and OLAP workloads.Cloud MigrationLed the phased migration of on-premises datasets to Azure Fabric and Azure Synapse Analytics, defining data governance, security policies, and cost control best practices.Reporting InsightsDevelop adhoc and scheduled reports using Power BI and SSRS; partner with business owners to translate requirements into intuitive dashboards and data visualizations.Continuous ImprovementCollaborate with crossfunctional teams to propose and implement enhancements to Data Warehouse architecture, ETL processes, and the overall data governance framework.Documentation GovernanceMaintain comprehensive technical documentation, data dictionaries, and standard operating procedures in compliance with regulatory requirements (GDPR, FINMA).Required QualificationsBachelors or Masters degree in Computer Science, Information Systems, or equivalent.3 to5 years of proven experience managing enterprise Data Warehouses in a banking or financial services environment.Advanced expertise with Microsoft SQL Server (2016+)TSQL, query tuning, indexing, and partitioning.Strong proficiency in SSAS (Tabular Multidimensional), SSIS, and Azure Data Factory.Hands-on experience with Azure Fabric, Synapse Analytics, and Azure Data Lake Storage.Fluent in French and English; professional proficiency in Dutch is a plus.Preferred SkillsPower BI development: advanced DAX, performance optimization, rowlevel security.Experience with Python or R for data preparation, statistical analysis, or automation.Familiarity with CI/CD pipelines (Azure DevOps), Git version control, and Infrastructure as Code (ARM/Terraform).Knowledge of ITIL processes, data governance frameworks, and regulatory compliance in finance.Soft SkillsExceptional analytical thinking and problem-solving ability.Strong interpersonal and communication skills can explain complex concepts to technical and nontechnical stakeholders.Proactive, detail-oriented, and able to manage multiple priorities under tight deadlines.Collaborative team player with a service mindset and continuous improvement attitude.What We OfferCompetitive benefits package and career development opportunitiesOngoing training, certifications, and mentorship programsExposure to cutting-edge cloud data architecture and advanced analytics projects #J-18808-Ljbffr
Data Warehouse & Data Specialist in Geneva Arbeitgeber: Tech StaQ
Unser Unternehmen ist ein hervorragender Arbeitgeber, der Ihnen die Möglichkeit bietet, in einem dynamischen und unterstützenden Umfeld zu arbeiten. Mit einem wettbewerbsfähigen Leistungspaket, einem hybriden Arbeitsmodell und kontinuierlichen Schulungs- sowie Entwicklungsmöglichkeiten fördern wir Ihre berufliche Weiterentwicklung. Zudem haben Sie die Chance, an innovativen Cloud-Datenarchitekturprojekten teilzunehmen und Ihre Fähigkeiten in einem regulierten Finanzumfeld weiter auszubauen.
