Freelancer profile translated to English.
Back to original languageAbout Aurelien
Experienced Data & BI Consultant, I design and administer high-performance data solutions, centered around the Microsoft Fabric and Azure platform. With my background as Lead Data Analyst and Power BI Architect, I develop APIs and web applications, set up datalakes, and automate workflows with modern tools (n8n, Azure Functions, Containers). Curious and passionate, I am also developing skills in open-source solutions like dbt and Airflow. My goal: transform data into actionable insights to support decision-making and accelerate business performance.
French
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- SémaphoresDevelopment of a secure FastAPI API for an accounting firmCONSULTING AND AUDITSFebruary 2026 - March 2026 (1 month)Tours, FranceContext:A firm of accountants needed to secure access to a client's accounting data for a third-party software publisher, while ensuring confidentiality and compliance.🎯 Mission Objective
- Design and deploy a secure API to control access to accounting data via JWT authentication and Azure containerization.
⚙️ Solutions Implemented- Development of the REST API with FastAPI for secure data exposure
- Implementation of a JWT authentication and authorization system ensuring secure exchanges
- Containerization of the application and deployment on Azure Container Instances for scalability and simplified management
📊 Results Obtained- Secure and controlled access to sensitive client data, respecting confidentiality
- Flexible and scalable deployment capability thanks to Azure containers
- Simplification of third-party integration without compromising security
🧩 Technical Stack- Python
- FastAPI
- JWT
- Azure Container
- Bicome ConsultingBI Portal with Power BI Embedded and Advanced Report ManagementCONSULTING AND AUDITSJanuary 2025 - December 2025 (11 months)Tours, FranceContext:Bicome consulting wanted to offer its clients a personalized portal with access to secure Power BI reports, while having an administration tool to dynamically manage content, users, and access rights.🎯 Mission Objective
- Develop a web portal integrating Power BI Embedded, accompanied by authentication APIs, business APIs, and an associated database, allowing fine-grained management of reports, users, and security (RLS).
⚙️ Solutions Implemented- Development of a secure authentication API to manage portal access and user identification
- Design of a business API for dynamic management of reports and user rights
- Setup and management of a database to store user information, report parameters, and security rules
- Integration of Power BI Embedded ensuring smooth access to reports directly within the portal
- Implementation of Row Level Security (RLS) for granular control of accessible data according to profiles
- Automation of authentication processes and user rights management
📊 Results Obtained- Secure portal offering personalized and controlled access to BI dashboards
- Flexible and centralized management of reports, users, and permissions via business APIs
- Enhanced data governance with fine-grained access control thanks to the database and RLS
🧩 Technical Stack- Power BI Embedded
- REST API (authentication & business)
- Python and Flask
- Database management
- RLS (Row Level Security)
- Body HouseData Lake and Power BI Reporting connected to OdooRETAIL (SMALL BUSINESS)January 2025 - Today (1 year and 5 months)Tours, FranceContext:Bodyhouse wanted to consolidate its sales, customer, and review data to have a unified view and reliable decision-making reports. The main sources are Odoo, Dataverse, and Avis Vérifiés.🎯 Mission Objective
- Implement a medaillon data lake connected to various sources to ensure data consistency and freshness, supported by a suite of Power BI reports.
⚙️ Solutions Implemented- Medaillon architecture to structure and differentiate raw, cleaned, and enriched data
- Automated ETL/ELT integration of Odoo, Dataverse, and Avis Vérifiés data
- Development of interactive and customized Power BI reports for business teams
- Data synchronization and control to ensure consistency in dashboards
📊 Results Obtained- Centralized and reliable view of customer, product, and feedback data
- Improved decision-making thanks to dynamic reports tailored to needs
- Enhanced operational and strategic monitoring with near real-time indicators
🧩 Technical Stack- Microsoft Fabric
- Odoo
- Dataverse
- Avis Vérifiés API
- Power BI
Recommendations
Be the first to recommend Aurelien
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
- RNCP Title Data AnalystCEFIM2022Formation de niveau Bac+3 en analyse de données, Python, data visualisation et développement de solutions data
- Digital and Data Solutions Manager3il ingenieur2023Diplôme certifiant délivré par 3iL Ingénieurs, formant à la gestion et au développement de solutions digitales et data. Ce parcours permet de maîtriser la gestion de projet (planification, suivi, reporting), l’analyse des besoins clients, la conception et le déploiement d’applications, ainsi que la prise en compte des enjeux liés à la sécurité et à la qualité des données. Les compétences techniques incluent le développement d’applications multi-supports, la création et l’intégration de services web (API REST, SOAP), la gestion d’entrepôts de données (datawarehouse), ainsi que la collecte et l’analyse de données volumineuses (Big Data) avec SQL/NoSQL. Ce diplôme prépare à piloter des projets digitaux complexes, en adaptant méthodologies et outils selon les contextes, tout en assurant la relation client et le travail en environnements internationaux.