Freelancer profile translated to English.
Back to original languageAbout Pierre
Freelance Data & Analytics
🎯 Target Roles
- Lead Data Analyst
- Analytics Engineer
- Data Analyst
💎 About Me
I can manage Data projects and teams. I implement adapted, resilient, and scalable solutions (ETL, data warehouse, data models, reporting, apps).
- 8 years of experience in Data & Analytics
- Former Senior Consultant at KPMG
- Former Lead Data Analyst at Electronic Arts
- International experience (France, Canada, Germany)
💻 Technical Skills
- Languages: Python, SQL, Bash
- Orchestration & transformation: Airflow, dbt
- Business Intelligence & Viz: Power BI, Tableau, Looker, Streamlit
- Data platforms: GCP, MotherDuck, Databricks
- Databases: PostgreSQL, SQL Server, Oracle, MySQL
- DevOps & Collaboration: Git, Docker, CI/CD
- GenAI: Claude Code, Copilot, Cursor
📍 References (Employers / Clients)
- Consulting: KPMG
- Banking & Insurances: BNP Paribas, Axa
- Gaming: Electronic Arts
- Telco: TELUS
- Retail: L'Oréal, InVivo, Mars
- Aeronautic: Airbus
Feel free to contact me to discuss your projects!
English
Native or bilingual
German
Conversational
French
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- Electronic Arts (EA)Senior Data AnalystVIDEO GAMES AND ANIMATIONOctober 2022 - April 2026 (3 years and 6 months)Vancouver, BC, Canada
💎 Summary
As a Lead Data Analyst, I am the technical leader of a team of 4 data analysts within the Mobile division, under the QA sub-division.📝 Tasks
- Technical leadership: solution design, architecture and code reviews, implementation and monitoring of best practices
- Delivery: requirements gathering, development of ETLs on modern stacks (airflow, dbt) and legacy (SQL Server, stored procedures, jobs), delivery of data viz solutions (Power BI, Looker Studio) and web apps (Streamlit)
💻 Tools
- Languages: Python, SQL, Bash
- Orchestration & transformation: Airflow, dbt
- Business Intelligence & data viz: Power BI, Tableau, Looker, Streamlit
- Data platforms: GCP, MotherDuck, Databricks
- Databases: PostgreSQL, SQL Server, Oracle, MySQL
- DevOps & Collaboration: Git, Docker, CI/CD
- GenAI: Claude Code, Cursor, Copilot
🎯 Deliverables
⚖️ "Work VS Capacity" Allocator- Distribute tasks among testers based on their availability (capacity) to speed up test work organization within the team
🔮 Bug Prediction Model- Predict bugs in a release to help tester teams estimate the required effort to prevent undetected bugs during deployment
🤖 Risk-Based Testing Solution (Rule Engine)- Identify risky game sections in a release so QA teams can focus their efforts where needed
💎 Data Quality Reporting Solution- Identify data quality issues and alert teams via automated emails and Slack bots so they can address them
🏃➡️ Sprint Workload Analysis Reporting Solution- Identify workload within a sprint and analyze the team's capacity to handle the work (burn down) based on its resources
- KPMG FranceSenior Consultant Data & AnalyticsCONSULTING AND AUDITSJanuary 2018 - September 2022 (4 years and 8 months)Île-de-France, France👨💼 I have worked as a Senior Consultant at KPMG, a large consulting firm, in its Data & Analytics department.I have worked on various client engagements in different sectors, mainly as a Business Analyst and as a Data Analyst.
Activities 📖
Some of the things I got to work on:Deployment of ETL pipelines (extracting and transforming data from different sources and loading these into target databases)Business Intelligence (building and deploying dashboards, managing workspaces access and resources)Organizing data migration (moving customers from older systems to a newer system)Project management (leading initiatives and reporting to key stakeholders)Tools 💻
Programming: Python, SQLDatabases: OracleCloud: Google Cloud PlatformData visualization: Power BI, Tableau, Looker StudioVersion control: GitHubDeliverables 🎯
Implementation of a Customer Data Platform (CDP) 💎- Leading the implementation of a Customer Data Platform as part of a large marketing automation program. Gathered requirements, identified priorities and laid out a roadmap for data ingestion and data quality initiatives, providing support to a team of 2 data engineers.
Data migration support 🚚- Leading the migration of customer data from multiple systems to a new solution as part of its implementation. Collected requirements and laid out a delivery roadmap, including go-live and post go-live. Built several ETLs migrate the data from former systems to target solution. Organized the testing.
Other deliverables (to be updated) 🔧- supporting the creation of a data and analytics team within a large FMCG company (roadmap, milestones, identification, assessment and prioritization of data initiatives as part of a transformation program)
- supporting the implementation of a web application, taking on different roles over time, in particular project manager, PO and scrum master
- building several end to end reporting solutions with BI (Business Intelligence)
Recommendations
Be the first to recommend Pierre
Help this freelancer shine by sharing your experience working together.
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
- Master of Science (M.Sc.)EMLYON Business School2017Master of Science (M.Sc.)