Freelancer profile translated to English.

Description

I am a Data Analyst. Mastering the GCP universe - particularly BigQuery and DataForm tools, I excel in SQL data analysis.

My skills cover the following core activities:

Querying data warehouses and building advanced analyses (BigQuery, SQL)
Utilizing cloud services and automating processes (DataForm, Google Cloud, Python)
Identifying underlying business insights from data through dedicated dashboards (Looker Studio, Power BI, Tableau)

What sets me apart is my ability to quickly switch between topics while staying focused and producing results. Whether it's tackling complex IT challenges or managing data configurations, I thrive in dynamic environments where every detail counts.

I am constantly results-oriented, pragmatic, and proactive.

Types of data missions performed:

Sharing insights on website content and layout with major automotive and healthcare clients through BI dashboards
Troubleshooting web issues, responding to ad-hoc requests, and detecting specific patterns
Reconstructing a GA360 data gap (Jan 2024) using the Google Analytics API
Converting session-based data (GA360) to event-based data (GA4) as needed
Implementing server-side tagging, and basic analytics and advertising pixels under GTM
Full audit of GTM containers to free up space
Utilizing APIs from major Paid Social and Digital platforms to automate data pipelines and enable regular reporting
Utilizing cloud services (GCP) to automate processes
Implementing user consent in accordance with Law 25, via OneTrust in Basic and Advanced Mode on GTM

I look forward to an initial discussion with your teams!

Industry field of expertise

Languages

French
Native or bilingual
English
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Boryl
Senior Data Analyst
CONSULTING AND AUDITS
October 2024 - Today (1 year and 7 months)
Lyon, France
I hold the position of Senior Data Analyst at Boryl since 10.21.2024 in Lyon, Auvergne-Rhône-Alpes, France

BI
DataViz
SQL Big Query Google Cloud Platform Dataform Looker Studio
Publicis
Senior Data Analyst
PRESS AND MEDIA
April 2023 - Today (3 years and 2 months)
Toronto, Canada
Connecting with Google Sheets, Analytics, Amazon Ads, and Similarweb APIs, GCP's Google Scheduler, Functions, and Cloud Run tools to automate data flows and streamline internal and client Web and Media reporting

Configuring about ten GTM containers (datalayer, custom JS variables), configuring about ten GA4 properties - including creating key events for Google Ads retargeting, creating custom dimensions and metrics, creating audience lists for Search and Media retargeting needs, correcting attribution errors, archiving GA360 data within the 4 essential structures needed for client reporting (sources, campaigns, pages, events) in BigQuery
Implementing server-side tagging under GTM to send conversions via server (GCP) to Meta Events Manager, implementing enhanced conversions by adding 1st-party data (JS variables) to Floodlight tags under GTM
Auditing GTM containers, identifying and refactoring obsolete tags and triggers, configuring Social tracking pixels (TikTok, Reddit, Google, Microsoft), implementing video tracking

Mapping GA4 event data in BigQuery to simplify data visualization and ad-hoc analysis
Utilizing Web data in BigQuery to respond to ad-hoc requests and for troubleshooting
Monthly reporting and recommendations on Web content and layout, competitive benchmarking of Aspira Canada to propose solutions in terms of SEO, Web content, and optimizing upper-funnel awareness, competitive benchmarking of the Lexus RX gasoline and hybrid model to identify Web improvement areas
Supporting the migration from GA360 to GA4

Ensuring client websites comply with Quebec's new "Law 25": implementing OneTrust, manual configuration of basic and advanced modes under GTM (variables, triggers, tags)
Google Tag Manager Google Cloud Platform (GCP) Big Query Predictive Modeling Google Analytics 4 Migration Looker Studio Python Programming Standard SQL API Gateway Google Analytics JSON Regex
Castafiore
Marketing Data Analyst
LUXURY GOODS
November 2021 - February 2023 (1 year and 3 months)
Paris, France
Web and Digital Product Analysis

Maximizing web performance and reducing CPA: implementing tagging plans for major client domains - dataLayer.push(), monthly reports on macro and micro KPIs, regular sharing of data-based insights and recommendations on website content and layout for castafiore.fr
Ad hoc support: utilizing web data in BigQuery to respond to ad-hoc requests and for troubleshooting

Building and automating data pipelines

Overall data architecture structuring: ad-hoc analysis of GA360 data using BigQuery, integration of Shopify, Google Ads, and Meta APIs to structure advertising, CRM, and back-office data - sales and transactional data
Google Tag Manager Google Cloud Platform (GCP) Tracking Big Query API Gateway Google Analytics 4 Standard SQL Python Programming E-commerce JSON Regex HTML + CSS Looker Studio