About Projects Skills Experience Education Contact
Data Architect · Analytics Engineer

Sofiane Ouzian

AWS · dbt Core · Snowflake · Qlik

10 years of enterprise delivery across French and European accounts. I design cloud-native data architectures on AWS, build modern transformation layers with dbt Core, and deliver end-to-end Qlik solutions — from raw ingestion to analytical consumption.

Book a call →
10+
years of
enterprise delivery
1000+
Qlik apps
delivered & migrated
4
industry
certifications
2M+
monthly users on
a live public tool
Sofiane Ouzian
Scroll
Certifications

Verified credentials

About

From raw data
to business insight

Qlik expert who spent 2 years inside Qlik's own Professional Services — the software vendor itself. At Qlik, I ran architecture & performance assessments across enterprise deployments (QSDA Pro), rescued 2 failing BI platforms, and led complex on-premises → Cloud migrations. Beyond Qlik: I cover the full data stack and design architectures built to last — scalable, governed, wired into CI/CD from day one.

At Volvo Group / UD Trucks, I simultaneously led the migration of 1,000+ Qlik applications to a multi-node AWS infrastructure, and built a dbt Core / Snowflake layer that cut reporting latency from 4 hours to minutes for 450 users — while keeping the business running throughout.

📍 Paris, France 🇫🇷 French national 🌐 Remote-ready
🏗️
Architecture first, dashboards second
Every engagement starts with data model design, governance, and layered architecture — not just the visual layer.
☁️
Dual AWS certified cloud practitioner
Solutions Architect + Data Engineer — I design and own the full cloud infrastructure, not just the BI layer.
⚡
Modern stack: dbt Core, Snowflake, CI/CD
Incremental models, slim CI pipelines, local LLM-generated docs — production-grade engineering, not ad hoc scripts.
🔍
Qlik insider — assessments & platform rescue
2 years at Qlik (the vendor) — architecture & performance assessments (QSDA Pro), rescue of 2 failing enterprise BI platforms, and product knowledge few external consultants ever access.
Signature Projects

Delivery that moved the needle

02
Analytics Platform Lead
TotalEnergies

CDC-driven ETL & Snowflake Datamart

Mar 2021 – Aug 2022 · Paris

Legacy batch architecture causing 24-hour reporting latency across Finance, Operations and Supply Chain. Replaced with a CDC-driven, incremental ETL stack — Control-M, Talend, Snowflake, SAP CDS Views extractors.

SnowflakeTalendControl-MSAP CDSCDCQlik Sense
24h
latency eliminated — real-time incremental loads
200+
users across 5 BUs on live Snowflake datamart
03
Live · Public
APEC — French Job Market Authority

Data Cadre

Oct 2017 – Nov 2018 · apec.fr

Designed and delivered APEC's public labour market visualisation tool — a Qlik mashup built with JavaScript Capability APIs, live on apec.fr. Three-layer QVD architecture, geospatial dashboards via KML layers.

Qlik SenseJavaScriptCapability APIsKML / GeoAnalyticsQVD 3-layer
View live tool ↗
2M+
monthly visitors on the apec.fr platform
↗
still live and publicly accessible today
Skills

End-to-end
data stack coverage

☁️
Cloud AWS
Dual certified
EC2S3VPC AWS GlueRDS PostgreSQL LambdaEventBridgeCloudWatch ALBFSx for WindowsIAM
🏗️
Data Engineering
Modern stack
dbt Coredbt Fusion SnowflakePySpark AWS GlueControl-MTalend Parquet / S3CDCSAP CDS Views
📊
Qlik Platform
Certified Architect
Qlik SenseQlik Cloud QlikViewQDF NPrintingSection Access QMC Multi-CloudQSDA Pro Qlik CLIApp Automation MashupsCapability APIs GeoAnalyticsDAR method
📈
Business Intelligence
PL-300
Power BIDAX KPI designDatamart design SSASSQL Server
⚙️
Dev & Scripting
CI/CD
PythonSQL JavaScriptHTML / CSS GitHub ActionsREST APIs Vue.jsExcel VBA
🧠
Architecture & AI
Senior
Well-Architected Framework Capacity planningMulti-env design Local LLM / OllamaQwen2.5-Coder manifest.json automation
Experience

10+ years of enterprise
data delivery

HCLTech · Volvo Group / UD Trucks Oct 2024 – present Fixed-price
Principal Data Architect & Lead Data Engineer
Project 1 · Qlik Migration & AWS Infrastructure

Ground-up design and deployment of a 16-node EC2 infrastructure across 4 environments. Migration of 1,000+ Qlik apps with <30 min production downtime. Private VPC, ALB, multi-AZ RDS PostgreSQL, FSx for Windows — Well-Architected compliant.

Project 2 · Analytics Engineering & Modern Data Stack

dbt Core transformation layer (staging/intermediate/mart) on Snowflake. AWS Glue / PySpark pipelines from SAP — latency cut from 4h to minutes. Slim CI via GitHub Actions. Local LLM documentation (Qwen2.5-Coder / Ollama), zero data outside VPC.

AWS EC2Qlik Clouddbt CoreSnowflakePySparkGitHub ActionsOllama
Qlik — Professional Services Aug 2022 – Sep 2024
Senior Professional Services Specialist

Architecture and environment audits via QSDA Pro. Recovery of 2 failing enterprise BI platforms. Led on-premises → Qlik Cloud transitions. Multi-sector PoCs with Pre-Sales and CSE teams. Custom JavaScript extensions, write-back solutions, and mashups via Capability APIs.

Qlik SenseQlik CloudQDFQSDA ProJavaScript
TotalEnergies Mar 2021 – Aug 2022
Analytics Platform Lead

Replaced legacy batch architecture with CDC-driven ETL (Control-M, Talend, Snowflake, SAP CDS Views), eliminating 24h latency for 200+ users. Designed Snowflake datamart (Finance, Operations, Supply Chain). Governed Qlik platform under QDF.

SnowflakeTalendControl-MSAP CDCQlik Sense
HSBC Sep 2020 – Dec 2020 Fixed-price
Migration Tech Lead

Full-remote engagement — rebuilt 20 QlikView / Qlik Sense reports, migrated QVD layers to SSAS cubes, delivered on Power BI.

QlikViewPower BISSAS
Dior — LVMH IT Division Nov 2018 – Jun 2020
Qlik Lead Developer

Delivered 25+ Qlik Sense apps and Vue.js mashups for C-suite and 100 commercial teams globally. Automated NPrinting for 500+ users — eliminated 5h/week of manual reporting. Administered Qlik security, licences, and user management across all BUs.

Qlik SenseNPrintingVue.jsSection Access
APEC Oct 2017 – Nov 2018
BI Developer

Built Data Cadre — APEC's public labour market visualisation tool, live on apec.fr (2M+ monthly visitors). Migrated Cognos to Qlik Sense. Three-layer QVD architecture, geospatial dashboards with KML layers.

Qlik SenseJavaScriptKMLOracleGeoAnalytics
Airbus — A380 Programme Nov 2015 – Oct 2017
Technical Business Analyst

Designed and delivered a Qlik Sense tracking app for 30+ aircraft sections on the A380, used daily across 5 BUs and 3 countries. Full lifecycle: PoC, build, deployment, knowledge transfer to multinational teams.

Qlik SenseKML GeospatialSupply Chain
Zodiac Aerospace — Boeing B787 Feb 2015 – Nov 2015
Supply Chain Analyst

Managed production and logistics of critical electrical components for the B787. Developed an Excel VBA macro suite for end-to-end tracking of volumes, supplier performance, and delivery KPIs.

Supply ChainExcel VBAKPIs
Education

Academic background

2010 – 2014
Dual Engineering Degree
ENSAIT Roubaix (FR) · ESITH Casablanca (MA)
Industrial Engineering & Logistics · Supply Chain & IT
Erasmus Exchange — Design & Distribution Management
2008 – 2010
Competitive Engineering Prep (PSI)
Lycée Moulay Youcef — Morocco
Physics & Engineering Sciences
Selective two-year programme preparing for France's top engineering schools
🇫🇷FrenchNative
🇬🇧EnglishBilingual
🇲🇦ArabicNative
🇪🇸SpanishConversational
Contact

Let's discuss your
next data project

Available for Data Architecture, Analytics Engineering, or Qlik engagements — remote or hybrid from Paris.