04.06.2026 aktualisiert

**** ******** ****
Premiumkunde
100 % verfügbar

Experienced Data Architect and Business Intelligence Specialist

Winterthur, Schweiz
Schweiz
B.Sc Mathematics, Queen Mary University of London
Winterthur, Schweiz
Schweiz
B.Sc Mathematics, Queen Mary University of London

Profilanlagen

Steven McDougall CVDADB01 2025.pdf
Steven McDougall CVDADB01D 2025.pdf
Steven McDougall CVDADM01 2025.pdf

Skills

Agile MethodologieData AnalysisAtlassian ConfluenceAtlassian JiraMicrosoft AzureBusiness IntelligenceCloud ComputingDatenbankenData ArchitectureData GovernanceData IntegrationETLData MigrationDatenmodellData WarehousingIBM DB2Datenbank DesignDimensionale ModellierungKnowledge ManagementProjektmanagementMicrosoft Sql-ServerOracle FinancialsScrumMicrosoft Power BIPL/SQLSQLSQL Server Reporting ServicesSQL Server Integration ServicesSQL Server Analysis ServicesTransact-SqlAzure Data FactoryDatenmanagementPhysical Data ModelsCloud-MigrationMicroservices
Database Technologies
Extensive experience with Oracle, MS SQL Server, DB2, and various SQL dialects including T-SQL and PL/SQL. Proficient in designing and optimizing database systems for high performance and availability.

Business Intelligence Tools
Expert in MS SSIS, SSAS, SSRS, Power BI, and Azure Data Factory. Skilled in creating comprehensive BI solutions and data warehouses for enterprise-level reporting and analytics.

Cloud and Data Architecture
Proficient in Azure cloud services, microservice DB design, and data migration. Experienced in designing and implementing scalable data architectures and cloud migration strategies.

Data Modeling
Skilled in creating conceptual, logical, and physical data models. Experienced with various modeling techniques including dimensional modeling for data warehouses.

ETL and Data Integration
Proficient in designing and implementing ETL processes using various tools and technologies. Experienced in large-scale data migration and integration projects.

Agile Methodologies
Familiar with Agile software development practices, including Scrum. Experienced in using tools like Jira and Confluence for project management and collaboration.

Data Governance and Management
Knowledge of data governance principles and experience with master data management implementations.
 

Sprachen

DeutschverhandlungssicherEnglischMuttersprache

Projekthistorie

Senior Data Architect

DWH Design

Data Analyst and Engineer (Contract)

Swica Krankenversicherung AG

Versicherungen

Analysis of insurance business intelligence applications, design of Star Schemas for reporting, implementation of ETL processes, and support for BI data warehouse migration to Azure cloud.

Data Architect (Contract)

FIFA
Lead designer for new tournaments and events database system, migration of existing systems to cloud, development of DWH for business intelligence, and management of database services.

Data Architect

Adcubum AG
Responsible for data architecture definition, data modeling, analysis and design of canonical data models, and investigation of Big Data techniques for the Syrius product.

Senior Database Consultant

AMR-Partner (IT Consultancy)
Worked for Credit-Suisse as DB2 expert, improving physical design and SQL code for client reporting applications, resulting in significant performance improvements.

Senior Technical Expert

UFD AG (IT Consultancy)
Hired out to Oracle Corporation, Netherlands as Senior Technical Expert at the Dutch Tax Authority, designing and implementing DB2 version of Oracle Enterprise Tax Management system.

Senior Database Consultant

UFD AG (IT Consultancy)
Worked for UBS AG, Zürich as Senior DB2 Consultant and DBA, responsible for DB2 usage in large and complex database projects.

SAP /DB2 and IMS Consultant (Freelance)

T-Systems International
DB2 consultant in project SAPHIR, designing and implementing backup and recovery strategies for SAP R/3 in a DB2 environment, and tuning data warehouses.

Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden