Freelancer profile translated to English.
Back to original languageAbout Aurélia
Business Intelligence Analyst with over five years of experience, I have worked both as a freelancer and within companies on projects covering the entire **data value chain**.
I am currently seeking opportunities within organizations that wish to leverage their data, where I can utilize my expertise while continuing to explore new tools and working methods.
My expertise:
- Design and implementation ofdata collectionandintegrationpipelines from various sources
- Creation ofdashboardsandanalyses
- Implementation oftests**, **monitoring**, and **documentationto ensure data reliability and quality
French
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- Business intelligence | ETL | Data VisualisationFreelanceCONSULTING AND AUDITSJanuary 2018 - Today (8 years and 5 months)Paris, FranceI help my clients leverage their data to guide their decisions. I work across the entire data value chain: from collection to visualization, including modeling and governance.Notable clients:**Opsmill**: Design of a **BigQuery data warehouse**, transformation via **Dataform**, creation of business datamarts to facilitate data exploitation**Origine 117**: Implementation of a **complete datastack**, from data collection (Stitch, Fivetran, Python scripts) to storage and analysis on **BigQuery**, with transformation via **Dataform**. Design of analyses and dashboards in collaboration with operational teamsPromotrans**: **API queryingvia Google Apps Script, data storage and preparation in **PostgreSQL**, creation of interactive dashboards with Looker StudioUniverseo**: SEO dashboards to analyze the performance of multiple sites, technologies used: **Google Analytics, Google Search Console, Looker StudioTerroirs d’Avenir**: Data ingestion via API, storage in **BigQueryviaPython/Pandas**, creation of **business dashboardsfor operational monitoringOnePark**: Integration of data from various sources via **StitchtoBigQuery**, **SQL/dbt transformation**, creation of **Metabase dashboardsBeauterra**: **PostgreSQLquerying and dashboard development onLooker StudioandTableau
- Origine 117Business Intelligence (BI) AnalystAGRICULTUREJanuary 2023 - Today (3 years and 5 months)Montréal, CanadaComplete implementation of the Business Intelligence system for Origine 117
- Collection and integration of data from various sources (Shopify, Google Ads, QuickBooks, POS systems, etc.)
- Design and development of the Data Warehouse to centralize information (Google Cloud/Big Query).
- Creation of reporting and data visualization tools (Looker Studio, Excel, Metabase) enabling optimized decision-making through in-depth analysis.
- Continuous improvement of data collection and reporting processes
- Galeries LafayetteBusiness Reporting OfficerRETAIL (LARGE RETAILERS)September 2021 - August 2022 (1 year)Paris, FranceResponsible for the design, development, maintenance, and adoption of reporting tools for the marketing, CRM, and purchasing teams.
- Gathering reporting and analysis needs from business teams
- Development of data models for reporting with Google BigQuery
- Design and development of dashboards with Looker Studio and Power BI
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Data Bird - Data Analyst BootcampDatabird2021Formation intensive data analyst - bootcamp de 8 semaines : - Gestion des données (SQL, bases de données, data warehousing, ETL) - Analyse de données (Python, Pandas) - Data visualisation (Google Data Studio, Tableau) - Applications métier (projets entreprises en mode agile)