Tayeb Aouina

As part of the PODIUM project, design and implementation of a medallion data architecture on BigQuery, development of data pipelines using Google Workflow, data anonymization and validation, as well as centralization and security of the DIG's strategic indicators.

Main achievements:

• Functional scoping & steering: facilitating workshops, gathering requirements, estimating costs and development planning

• Data modeling & governance

– Design of target data models (medallion architecture)

– Classification of assets as data products, documentation of business rules and quality control

• Development & integration

– Development of BigQuery data ingestion routines and orchestration via Google Workflow

– Construction of a Power BI Online semantic model in Direct Query on BigQuery

• Power BI Reporting: model redesign, DAX measure creation, dashboard design

• Testing & validation: writing and executing test cases, analyzing anomalies, tracking fixes obtained:

✔Significant reduction in operating costs and optimization of cloud resources in production of a data catalog operational classification of data products

✔Reduction in error rate through automation of quality controls

Technical environment: Power BI, Azure DevOps, Microsoft Fabric, SQL, Python, Google BigQuery, Airflow DAGs, DBT, Cloud Storage, GitLab CI, Linux, Docker, GCP, skills=[]

Design, redesign, and industrialization of a strategic multi-departmental data platform (HR, Marketing, Finance, Sales, Purchasing). Modernization of the decision-making ecosystem and deployment of high-performance steering tools.

Main achievements:

• Redesign of the OWF Data platform and the decision-making steering tool

– Reconstruction of the data warehouse, OLAP cubes, and reports for sales teams

– Development of SQL stored procedures and SSIS packages (integration framework)

– Participation in the modeling of SSAS Tabular cubes

• Power BI Development & reporting

– Creation and improvement of Power BI reports and dashboards

– Development of DAX queries for the Web portal tiles

• Functional support

– Support for business teams and participation in Agile ceremonies (sprint planning, daily, retrospective)

Results obtained:

✔Project delivered on time

✔Significant reduction in data processing time

✔Successful automation of complex and recurring tasks

✔Reduced error rate thanks to improved control processes

Technical environment: Visual Studio Code, Airflow, Git, DBT, BigQuery, SQL, Python, Google BigQuery, Airflow DAGs, Cloud Storage, GitLab CI, Linux, Docker, GCP, skills=[]

Design and optimization of data pipelines, modeling of financial datasets, and ensuring data ingestion, quality, and security for business teams (financial analysts, middle office, risk managers).

Main achievements:

• Architecture & modeling

– Implementation of a modern data architecture (data warehouse / data lake)

– Modeling and structuring of datasets according to needs (medallion, normalization/denormalization)

• Data ingestion & processing

– Development of ETL/ELT to integrate multiple sources: internal systems (CRM, financial management), external providers (markets, ESG, funds), shared files (Excel, CSV, API)

– Management of the complete cycle: extraction, cleaning, transformation, enrichment, and loading

• Pipelines & orchestration

– Implementation of robust and automated pipelines to ensure data flow reliability

– Orchestration via Google Workflow and Airflow, with management of schedules, alerts, and monitoring

✔Architecture of

✔Centralization and validation of strategic decision-making data

✔Automation of pipelines, reducing manual work and errors

✔Improvement of anonymization) technical: Git, PostgreSQL, SQL, Python, GCP, AWS, GCP BigQuery, GCP Cloud Run, GCP Pub/Sub, Tableau Data Warehouse, SCRUM, skills=[]