Freelancer profile translated to English.
Back to original languageAbout Naidine
Looking for an Analytics Engineer?
You've come to the right place.
I am an Analytics Engineer with over 5 years of experience in data. I help companies structure, validate, and leverage their data to facilitate business decision-making.
I have collaborated with companies such as JTEKT (Toyota Group), APRR, Data New Road, Descours & Cabaud, and Fretly.
I can assist you with:
- Analytical modeling and data structuring (staging, marts, KPIs)
- Implementing and industrializing data pipelines
- Data transformation and validation with SQL, Python, and dbt
- Designing dashboards and business intelligence reports
- Defining and tracking business indicators
- Improving data quality and documentation
- Migrating and modernizing data stacks (PostgreSQL, Snowflake, Power BI…)
- Automating processes and reports
- Collaborating with business, product, and technical teams
- Supporting users and disseminating data best practices
I also have knowledge of: Data Build Tool (DBT), Microsoft Excel, Tableau Software, Talend, Apache Airflow, Docker, Linux, GIT / GitHub, Microsoft Power Query, Medallion Architecture, Data Visualization, ETL Tools...
I place great importance on transparency, communication, and the quality of deliverables.
I send a daily report to my clients at the end of the day on all the tasks I have completed.
Do you have a project?
Contact me, I respond in less than 1 hour.
--
analytics engineer, analytics tag manager, analytics engineer dbt, analytics engineer power bi, analytics tracking, analytics mobile, analytics ga, analytics gtm, snowflake talend, snowflake dbt, snowflake aws, dbt snowflake, dbt bigquery, sql data, sql power bi, "power bi", power bi finance, power bi sql
French
Native or bilingual
English
Conversational
Spanish
Basic
Can work on-site
Lyon (up to 50km), Marseille (up to 50km), Saint-Étienne (up to 50km), Paris (up to 50km), Lille (up to 50km)
Experience
- JTEKT EuropeAnalytics EngineerMECHANICAL ENGINEERINGMay 2024 - Today (2 years and 3 months)Irigny, FranceJTEKT is an international automotive supplier in the Toyota Group specializing in steering systems and industrial components. The group has over 45,000 employees worldwide.I joined the Process Engineering team to automate and modernize budgeting and decision-making processes for several international plants. The team consists of a finance business expert and myself, covering all Data / BI / automation aspects.My responsibilities:• Implementation of a modern data stack: Docker, Airflow, PostgreSQL, MinIO, DBT, Streamlit, and Power BI.• Development of a budgeting and investment tracking application with automated alerts.• Industrialization of ETL pipelines with Python, SQL, and APIs (BOX, SharePoint).• Automation of budget summary files and invoicing tracking with Python and Excel.• Development of Power BI dashboards for financial and operational monitoring of industrial sites.• Setting up updates, distributing reports, and direct collaboration with finance teams in a bilingual English environment.I contributed to the following developments:• Complete automation of a process that previously took 2 weeks of full-time work for 4 people, reducing the time to approximately 3 minutes.• Deployment of 3 automated reports used by over 100 users.• Implementation of 3 daily and 1 weekly refresh cycles.• Daily monitoring of approximately 300,000 lines of industrial and financial data.• Centralization of data steering from 30 plants.Technical Context:Python, SQL, Docker, Linux, Apache Airflow, PostgreSQL, MinIO, Streamlit, Power BI, Power Query, DAX, Excel, APIs, SharePoint, SAP BW, ETL, Data Engineering, BI, Reporting, KPI.
- APRRAnalytics EngineerRETAIL (LARGE RETAILERS)September 2023 - April 2024 (6 months)Lyon, FranceAPRR, one of Europe's leading motorway groups, manages over 2,300 km of motorways in France and oversees mobility, transport, and connected services infrastructure.Within APRR's Data department, I supported the teams in migrating data stacks, operational maintenance, and modernizing BI tools. The team, consisting of about 20 people, included Lead Tech, Architect, BI Manager, Product Owner, Data Scientists, Analysts, and Engineers.I worked autonomously under the supervision of the BI Manager.My responsibilities:• Complete overhaul of Data/BI projects from requirements gathering to production deployment.• Migration of data stacks: Python to Talend, PostgreSQL to Snowflake, Tableau to Power BI.• Industrialization of ETL / ELT pipelines and redesign of data models with Medallion architecture on Snowflake.• Use of Snowflake stored procedures and dynamic tables to optimize analytical processing.• Development and maintenance of Power BI and Tableau Software dashboards.• Configuration of refreshes, alerts, and RLS security rules.• Facilitating user workshops, technical documentation, and supporting internal teams.• Operational maintenance, monitoring of Talend flows, and Snowflake database monitoring.I contributed to the following developments:• Complete redesign of 2 strategic Data projects involving migration of dashboards, ETL flows, and data storage.• Support for approximately 20 business users per project.• Monitoring and operational maintenance of Talend flows, Snowflake databases, 25 Power BI dashboards, and 27 Tableau dashboards.• Improved reliability of business intelligence processes and reduced manual tasks through automation.• Contribution to enhancing user experience and business decision-making through modernized BI tools.
- APRRAnalytics EngineerRETAIL (LARGE RETAILERS)August 2022 - October 2023 (1 year and 2 months)Lyon, FranceAPRR, one of Europe's leading motorway groups, manages over 2,300 km of motorways in France and oversees mobility, transport, and connected services infrastructure.Within the Data department, I participated in projects related to data valorization and BI industrialization for business and operational teams. The Data team comprised 20 experts: Lead Tech, Valorization Lead, Architecture Lead, BI Manager, Product Owner, Data Scientists, Data Analysts, and Data Engineers.Key responsibilities:• Development of ETL pipelines (Python, SQL).• Management of PostgreSQL analytical databases.• Creation of Power BI and Tableau dashboards.• Analysis of business needs and definition of KPIs.• Automation of business intelligence reporting.• Extraction/structuring of data (PDF, Excel, APIs, internal databases).• Implementation of OCR processes in collaboration with operational teams.Projects completed:• Data Pavement: OCR on 3,000 PDFs, consolidation of 15 years of data (100,000 measurements), creation of a Power BI dashboard to optimize an investment of €100 million.• Waste Reporting: Automation of regulatory reporting by unifying 6 data sources.• EV Charging Station Monitoring: Tracking of 1,000 electric charging stations from 10 operators using 30 KPIs on charging, consumption, and performance.• CHU Datathon: Development of an award-winning intelligent search engine based on MongoDB, KeyBERT, and Streamlit.Main contributions:• Reduction of manual analysis tasks.• Structuring and reliability of critical data.• Development of BI tools for several business teams.• Interventions on ETL, data modeling, dashboards, and data valorization.Technical Context:Power BI, Tableau Software, Python, SQL, PostgreSQL, MongoDB, Streamlit, OCR, ETL, Data Visualization, KPI, Reporting, Excel, VBA, Git, APIs, Data Engineering, Predictive Maintenance, EV Charging.
Recommendations
+1
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 ScienceLyon Ynov CampusNiveau : mention bien Ynov Lyon Campus est une école spécialisée dans les métiers du numérique, de l’informatique et des technologies innovantes. Le campus forme chaque année des profils techniques destinés aux métiers de la data, du développement, de la cybersécurité, du cloud et de l’intelligence artificielle. Majeures : • Big Data & Dataviz (Hadoop, PowerBI, Tableau) • Architectures & Administration BDD (MongoDB) • Architectures Distribuées (Redis, Neo4j, Spark, Scala, Docker) • Mathématiques appliquées à la Data Science (R, Python) • Machine Learning (Python, Jupyter) • Deep Learning (Python, GoogleColab) Électifs : • Pilotage de la stratégie SI • Gestion de projet IT • Méthodologies de tests et tests unitaires • React.js • Flutter • Suite Adobe (Photoshop, Illustrator, InDesign, Premiere Pro)
- Professional Bachelor's degree in Decision-Making and Statistics Professions (LP MDS), (Statistics, Business Intelligence, and Big Data track)IUT d'Aix-MarseilleNiveau : Mention Bien L’Université d’Aix-Marseille est l’une des plus grandes universités françaises, reconnue pour ses formations en sciences, technologies et informatique décisionnelle. Cette formation m’a permis de développer des compétences en : • Conception et gestion de bases de données massives • Informatique décisionnelle et visualisation de données • Analyses statistiques et data mining • Techniques d’apprentissage profond (Deep Learning) • Développement d’interfaces WEB pour la donnée • Rédaction de rapports d’études et restitution analytique Le cursus incluait également : • 150 heures de projets tutorés sur des problématiques concrètes d’entreprise • Un stage professionnalisant de 12 à 16 semaines • Une pédagogie alternant théorie, projets et cas pratiques métier Programme :
Certifications
- Data Engineering with dbtlinkedin learning2024