Freelancer profile translated to English.
Back to original languageAbout Rodrigue
I am a Data Engineer & BI Consultant, specializing in building robust data pipelines and developing interactive dashboards. I help companies grow by optimizing their data strategy for informed decision-making.
🎯 Areas of Expertise
- Building and optimizing data pipelines: Proficient in DBT for automating and optimizing ETL processes.
- Data Warehouse modeling and management: Expertise in BigQuery and Snowflake for structuring and organizing your data.
- Extracting and analyzing KPIs for strategic decision-making: Extracting relevant KPIs to drive performance and strategy.
- Implementing Dashboards and Reporting: Expertise in Looker for creating impactful data visualizations.
- Training and upskilling teams on BI tools: Training teams on Looker and implementing self-service BI solutions.
- Agile Methodology: Agile approach for efficient and adaptable project management.
⚙️ Technologies and Tools
- BI: Looker, Tableau
- Data Transformation: DBT, Airflow
- Data Warehouse: BigQuery, Snowflake
- Cloud Platform: Google Cloud Platform (GCP)
I quickly acquire new skills and adapt easily to the specific needs of each project. I am available to discuss your data needs.
French
Native or bilingual
English
Conversational
Can work on-site
Paris (up to 50km)
Experience
- POMONAData EngineerAGRICULTURESeptember 2024 - Today (1 year and 9 months)Antony, FranceContext.POMONA Group wishes to implement a Data Warehouse on Snowflake with the aim of centralizing and optimizing the management of data related to inventory, orders, and sales. The main objective is to provide a single, reliable, and scalable data source to meet reporting needs related to supplier service rate monitoring.Work Performed.- Participation in needs analysis workshops- Contribution to the development of the target architecture and technological choices- User creation and permission management on Snowflake- Implementation of an access rights policy for different Snowflake objects- Implementation of unit tests to ensure data accuracy- Implementation of a deployment strategy for dbt models in different environments- Creation and modeling of datamarts in different environments- Design of automated data pipelines for data ingestion and transformation- Monitoring of dbt models to detect and resolve anomalies- Responsibility for the management and configuration of dbt and Snowflake instancesDeliverables.- Versioned dbt pipelines with integrated automatic tests- Datamarts built in Snowflake and optimized for BI needs- Power BI reportsTechnical Environment:Snowflake, dbt, Gitlab, SAP, SNP Glue, Power BI
- BforBankData EngineerBANKING AND INSURANCEAugust 2023 - June 2024 (10 months)Puteaux, FranceContext.In a context of developing new banking offers and increasing demand for activity monitoring dashboards, BforBank wished to strengthen its data strategy by implementing a modern infrastructure based onGoogle Cloud Platform (GCP)and **Looker**. The main objective was to improve data accessibility, facilitate real-time analysis, and enhance decision-making.Work Performed.
- Participation in analyses, impact assessments, and technical scoping
- Collaboration with business teams to identify their data visualization needs and propose suitable solutions
- Creation of new data products and evolutionary and corrective maintenance of existing data products
- Design of automated data pipelines for integrating and transforming data from Kafka topics
- Creation of activity monitoring dashboards allowing managers to track company performance in real-time
- Training of end-users on Looker usage to promote tool adoption and team autonomy
- Technical documentation of data products
- Participation in data migration to the Google Cloud Platform, enabling better data management and security
Deliverables.- Versioneddbtpipelines with integrated automatic tests
- Datamarts built inBigQueryand optimized forBIneeds
- Implementation ofself-service BIonLookerfor business teams, reducing reliance on technical teams.
- UGC CinéData EngineerFILM AND AVApril 2023 - July 2023 (3 months)Neuilly-sur-Seine, FranceContext.UGC Group undertook to centralize data from its various cinemas into a single **Data Warehouse**. The objective is to provide a unified platform for different business domains (marketing, cinemas, finance) to strengthen data-driven decision-making and improve operational efficiency.Work Performed.
- Gathering user requirements
- Analysis and extraction of relevant data from multiple databases from different cinemas
- Design and implementation of a robust Data Warehouse architecture, based on a Data Vault data model to meet scalability and historical data management needs
- Implementation of optimizations to ensure high performance for analytical queries, while maintaining flexibility to add new data sources to the Data Warehouse
- Workflow orchestration to ensure regular and reliable loads.
Deliverables.*Data Vaultdata models- Scalable and optimized Data Warehouse
- Automated Data Pipelines
Recommendations
Be the first to recommend Rodrigue
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
- Specialized Master in Business Intelligence & AnalyticsEISTI2020Le programme Mastère Spécialisé® est validé par un bac+6 accrédité par la Conférence des Grandes Écoles. La formation comprend : - Théorie de la Business Intelligence : chaîne décisionnelle (vision globale et approche détaillée des différentes phases de la chaîne), modélisation, conception des différentes phases, exemples de mises en place. - Gestion de projet décisionnel : fondamentaux de la gestion de projets et focus sur les spécificités d’un projet BI - Pratique de la Business Intelligence : gestion de la qualité des données (MDM), extraire, transformer et charger (ETL), reporting, multidimensionnel, datamining. - Projet d’entreprise BI : les étudiants mènent un projet BI d’entreprise. Celui-ci consiste en la mise en place d’une solution décisionnelle en réponse à une problématique proposée par une entreprise. Ce projet permet aux étudiants de consolider leurs acquis dans le cadre d'un projet réel.
Certifications
- Google Cloud Certified Professional Data EngineerGoogle Cloud2023
- Looker Certified LookML DeveloperGoogle Cloud2022