Built the Analytics Architecture team from scratch by hiring, training, and mentoring three Analytics Engineers, fostering a culture of continuous learning and improvement, and directly contributing to the success of the organization's data platform.Managed the data warehouse roadmap, aligning project deliverables with business objectives and timelines. Developed data models covering over 30 unique business processes across six major products and subsequently coached my team to independently maintain and take on the end-to-end development of new dimensional data models.Established a robust testing foundation with over 3000 tests using DBT, covering every data model through generic structure unit tests and functional tests. This included trend anomaly detection, golden value comparisons, regression prevention prior to production, and monitoring shifts in source data quality.Directed comprehensive data assessments for all new products and datasets, centralizing data and analytics requirements from the business alongside existing and proposed data sources. Evaluated gaps between requirements and current capabilities, recommending steps to bridge these gaps, thus ensuring alignment with strategic objectives. This strategic oversight ensured the effective translation of complex business needs into scalable data solutions, improving data quality and accessibility across the organization.Advanced our documentation practices, in a remote working setting, using tools like Alation (Data Catalog), making our data models accessible and understandable for a wide internal audience including Data Scientists, Business users, BI developers and the Data Governance team.Managed complex stakeholder relationships and prioritized projects based on business impact, while actively engaging with senior leadership to design and implement strategic data projects.

Facilitated team development and ensured efficient project progress by breaking down assignments into smaller, tangible tasks for team members.Shared knowledge and aligned the team on data modeling strategies to ensure consistency and minimal redundancy in our data models.Implemented improvements in data architecture, team processes, and functions. Maintained and updated existing data models, both in code and documentation, ensuring their relevance and efficiency.Led the integration of data technologies like DBT into our data stack (Cloudera Impala, Redshift, S3, PySpark, Python, DBT) with agile principles in mind, significantly improving our data modeling, ETL processes, and analytics delivery.Drove the enhancement of our Enterprise Dimensional Model through prototyping data models in SQL, reinforcing the data warehouse as the single source of truth for any internal analytics requests.

Led a team of three developers, enabling six business data analysts by providing training on a spectrum of BI tools, from self-service platforms to comprehensive enterprise solutions. Enhanced team’s analytical proficiency and streamlined operations.Developed and implemented a data factory, optimizing the analytical production chain from web scraping (Python), through data pipeline automation (Airflow), to data visualization (Power BI). This innovation led to a 90% decrease in the time Data Analysts spent on data collection.Provided organizational, technical, and modeling guidance across Digital Dimension and its subsidiary entities. Played a key role in elevating the company’s BI capabilities through strategic consultation and hands-on training.

Designed the architecture, pipelines, and dimensional modeling for the data warehouse project of TF1, France's leading television channel, within an 8-member team.Led the implementation of scrum in the context of agile data warehousing development, applying and advocating for agile principles. Each scrum iteration we delivered an increment of value, starting from internal core business applications as data sources and moving through data modeling and data pipeline processes to provide insights through self-service tools to our end users.Concentrated on modeling individual business processes, using continuous integration and data unit testing to maintain high standards of data analysis quality, without regression.

Participated in the Marine Compass BI project (monitoring boat activity and performance) within a diverse BI architecture including Microsoft, Oracle, and Talend technologies.Engineered the migration of the OLAP Cube and developed SSRS reporting solutions. Collaborated closely with business users to generate executive-level weekly reports for C-level management.

As an ETL Developer at Orange Telecom for the International Intercarrier Communication Project, I developed and tested large scale data pipelines using Microsoft's SSIS, SSAS, and SSRS technologies.