Skip to main content
Top expert badge
Recommended expert
Profile header background

Pierre-Jean A.-BI Expert | ETL & Data Architecture | ERP Integration | Reporting

Pierre-Jean A. - BI Expert | ETL & Data Architecture | ERP Integration | Reporting - profile avatar
Profile header overlay
Available
Stuttgart, Germany

Check rate

Experience

Mar 2023 - Apr 2023
Friedrichshafen, Germany

Verification Engineer – Aviation

Tri.Merge GmbH

Position summary
Verification Engineer – Aviation at Tri.Merge GmbH
Industries
Aerospace and Defense
Business areas
Quality Assurance
  • Automated analysis of test script repositories using Python
  • Set up a SQLite database for signal and value tracking
  • Identified critical inconsistencies through ad hoc SQL queries
  • Technologies: Python, SQLite, Excel/ODBC
Apr 2022 - Sep 2023
Koblenz, Germany

Requirements & Systems Architect

ZF Friedrichshafen AG

Position summary
Requirements & Systems Architect at ZF Friedrichshafen AG
Industries
Automotive
Business areas
Product Development
  • Defined system requirements in Doors in compliance with ISO 26262
  • Implemented MBSE methods (Cameo) for a consistent system architecture
  • Developed Python-based analysis tools to identify process inconsistencies
  • Technologies: Doors, MBSE (Cameo), PTC Windchill/Integrity, Python
Dec 2019 - Feb 2026
Böblingen, Germany
On-site

BI Expert & Agile Product Owner – Business Intelligence

Ineos Automotive GmbH

Position summary
BI Expert & Agile Product Owner – Business Intelligence at Ineos Automotive GmbH
Industries
Automotive
Business areas
Business Intelligence
Information Technology
Product Development
  • Designed and built a Python/SQL-based analytics platform integrating SAP (CDS Views), Teamcenter, Polarion, OP Center, and SharePoint
  • Developed Power BI dashboards and ODBC-optimized Excel solutions for executive reporting
  • Enabled data-driven decisions across all engineering disciplines
  • Technologies: PostgreSQL, SQL Server, SQLite, Snowflake, Power BI, Python
  • Developed an end-to-end BI platform, from data extraction from SAP, Teamcenter, Polarion, and SharePoint through a Python/SQL transformation layer to the Snowflake data warehouse and Power BI frontend
  • Built data models and layered structures (Raw Ingestion, Curated, Business-ready), as well as KPI dashboards and self-service reports
  • Automated regularly updated reports without manual intervention and reduced recurring manual consolidation tasks
  • Gathered and documented technical requirements with Controlling, IT, and Project Management, and translated business requirements into technical specifications in Azure DevOps
  • Conducted knowledge transfer and training for internal users and created comprehensive solution documentation
Oct 2019 - Apr 2020
Spaichingen, Germany

Requirements Analyst

Eugen Forschner GmbH

Position summary
Requirements Analyst at Eugen Forschner GmbH
Industries
Automotive
Business areas
Product Development
Project Management
  • Created complete specifications for electronic control units
  • Systematically decomposed requirements across software, hardware, mechanics, and project management
  • Developed coverage reports for project control
  • Technologies: Polarion, PostgreSQL, SQLite, Python, SVN
Jul 2017 - Oct 2020
Penzberg, Germany

Requirements Analyst & BI Developer

EMT Penzberg

Position summary
Requirements Analyst & BI Developer at EMT Penzberg
Industries
Aerospace and Defense
Business areas
Business Intelligence
Information Technology
Quality Assurance
  • Created standards-compliant reports for test, systems, and certification departments
  • Developed automated reporting solutions with Tableau and BIRT
  • Ensured traceability for the Bundeswehr and certification authorities
  • Technologies: Tableau, BIRT, MySQL, Jama Software, Python
Jul 2016 - Aug 2019
Waldkirch, Germany

Requirements & Process Expert

SICK AG

Position summary
Requirements & Process Expert at SICK AG
Industries
Manufacturing
Business areas
Business Intelligence
Information Technology
Product Development
  • Establishment of a structured requirements process with product/platform separation
  • Development of Tableau dashboards for project coverage and traceability
  • Integration of Jama Software with existing legacy systems (XRM)
  • Technologies: Tableau, Jama Software, MySQL, MS Access
Jan 2015 - May 2016
Bietigheim-Bissingen, Germany

Technical Project Lead – Parking Assistance ECUs (Agile)

Valeo Schalter und Sensoren GmbH

Position summary
Technical Project Lead – Parking Assistance ECUs (Agile) at Valeo Schalter und Sensoren GmbH
Industries
Automotive
Business areas
Product Development
Project Management
  • Coordination of multidisciplinary teams (software, hardware, mechanics)
  • Customer management and requirements gathering
  • Project management with Oracle-based tracking systems
  • Technologies: Serena Dimensions, Oracle, MS Project
Mar 2011 - Dec 2014
Bietigheim-Bissingen, Germany

Requirements Analyst – Driver Assistance Ultrasonic Products

Valeo Schalter und Sensoren GmbH

Position summary
Requirements Analyst – Driver Assistance Ultrasonic Products at Valeo Schalter und Sensoren GmbH
Industries
Automotive
Business areas
Product Development
  • Preparation of system specifications for ultrasonic-based ADAS products
  • Development of a custom dashboard for project tracking (similar to Tableau)
  • Advanced Doors usage: metrics, automated exports, version tracking
  • Enabling offline requirements analysis without loss of information
  • Technologies: Doors, Oracle, Serena Dimensions, UML
Sep 2010 - Mar 2011
Guyancourt, France

Electrical & Wiring Architect

Renault

Position summary
Electrical & Wiring Architect at Renault
Industries
Automotive
Business areas
Product Development
Quality Assurance
  • Successful specification of prototypes for Kangoo (X61), Trafic (X82), Master (X62) without prior knowledge
  • Adaptation of wiring harnesses and CAN interfaces for new control units
  • Validation in the prototype workshop
  • Technologies: CANoe, CAD, automotive electrical systems
Apr 2010 - Sep 2010
Rueil-Malmaison, France

Project Manager – Automotive Emergency Call

Sagemcom

Position summary
Project Manager – Automotive Emergency Call at Sagemcom
Industries
Automotive
Telecommunication
Business areas
Product Development
Project Management
  • Development of a GSM/GPRS module for Tier-1 suppliers
  • Hardware routing and interface design (CAN, GPS, USB)
  • Successful re-entry of Sagemcom into the automotive market
  • Technologies: GSM/GPRS, CAN, GPS, USB, MS Project
Jul 2009 - Apr 2010
Vélizy-Villacoublay, France

Electronics Project Manager – Cardiac Prosthesis (Medical)

Carmat SAS

Position summary
Electronics Project Manager – Cardiac Prosthesis (Medical) at Carmat SAS
Industries
Healthcare
Business areas
Procurement
Product Development
Project Management
Quality Assurance
  • Approval of the 3rd and 4th versions of the prosthesis specifications
  • Optimization of ultrasound measurements and control loops
  • Supplier management and EMC validation
  • Technologies: Doors, Hardware Validation, Ultrasound Measurement Technology
May 2007 - Dec 2008
Guyancourt, France

FlexRay & AUTOSAR Consultant

Renault

Position summary
FlexRay & AUTOSAR Consultant at Renault
Industries
Automotive
Business areas
Product Development
  • Definition of FlexRay interfaces and message sets for alliance platforms
  • AUTOSAR protocol stack configuration
  • Process documentation for vehicle architects
  • Technical Japanese for alliance collaboration
  • Technologies: FlexRay, AUTOSAR, MS Access
Aug 2006 - Mar 2007
Vélizy-Villacoublay, France

Multimedia Systems Architect

Peugeot Citroën Automobiles

Position summary
Multimedia Systems Architect at Peugeot Citroën Automobiles
Industries
Automotive
Business areas
Product Development
  • Specification of complete multimedia systems (approx. 12,000 requirements)
  • Development of a custom traceability database (without Doors)
  • Management of international variants
  • Technologies: MS Access, Functional Analysis
Jan 2005 - Aug 2006
Guyancourt, France

Supplier Manager – High-End Infotainment

Renault

Position summary
Supplier Manager – High-End Infotainment at Renault
Industries
Automotive
Business areas
Procurement
Product Development
  • Complete redevelopment of functional and HMI specifications from scratch under time pressure
  • 100% compliant prototype delivered for the project milestone
  • EMC and mechanical validation
  • Technologies: CANoe, Functional Analysis
Oct 2003 - Dec 2004

Supplier Manager – Test Equipment

Delphi Diesel Systems

Position summary
Supplier Manager – Test Equipment at Delphi Diesel Systems
Industries
Automotive
Manufacturing
Business areas
Procurement
Supply Chain Management
  • Coordination between development (France), prototype production (UK), production (Spain), and suppliers (Germany)
  • Earliest delivery despite a later project start
  • Mass production with a 30-40 second cycle time
  • Technologies: FMEA, High-Pressure Hydraulics
Jan 2002 - Oct 2003
Colombes, France

Rig Manager – Aircraft Systems Validation

Safran

Position summary
Rig Manager – Aircraft Systems Validation at Safran
Industries
Aerospace and Defense
Business areas
Project Management
  • Management of 15 European partners
  • Coordination of hydraulic, measurement, cooling, and accessory systems
  • Technologies: MS Project, aviation systems
Jun 1999 - Dec 2001
Bordes, France

Test Rig Engineer – Helicopter Turbines

Safran (Turbomeca)

Position summary
Test Rig Engineer – Helicopter Turbines at Safran (Turbomeca)
Industries
Aerospace and Defense
Business areas
Product Development
Quality Assurance
  • Design of a universal onboard computer test rig
  • Reduction of commissioning times
  • Increased supplier feedback
  • Technologies: Brioquery database, turbine electronics
Feb 1998 - Mar 1999
France

Process Engineer – Electrochemistry

Péchiney High Purity

Position summary
Process Engineer – Electrochemistry at Péchiney High Purity
Industries
Metals and Mining
Business areas
Production
  • Cleaning record in electrolysis process
  • +5% increase in productivity for sawing operations
  • Doubling of tool lifespan (carbon electrodes)
  • Technologies: Microsoft Access, process engineering
Jan 1996 - Apr 1997
Moscow, Russian Federation

Research Assistant – Nuclear Energy

Commissariat à l'Énergie Atomique (CEA)

Position summary
Research Assistant – Nuclear Energy at Commissariat à l'Énergie Atomique (CEA)
Industries
Energy
Business areas
Research and Development
  • Publication of a directory of Russian nuclear research centers
  • Work in Russian
  • Technologies: Paradox database

Industry experience

See where this freelancer has spent most of their professional time.

Experienced in Automotive, Aerospace and Defense, Manufacturing, Energy, Healthcare, and Metals and Mining.

Automotive
Aerospace and Defense
Manufacturing
Energy
Healthcare
Metals and Mining
Profile match chart

Business area experience

See which departments and functions this freelancer has contributed to most.

Experienced in Product Development, Business Intelligence, Information Technology, Quality Assurance, Project Management, and Procurement.

Product Development
Business Intelligence
Information Technology
Quality Assurance
Project Management
Procurement
Profile match chart

Summary

Experienced Systems Engineer with 30 years of international expertise in automotive, aviation, and mechanical engineering. Specialized in requirements engineering, functional safety, and data-driven solutions. Proven success in transforming complex technical requirements into actionable specifications and business intelligence solutions.

Skills

Databases & Analytics:

  • Sql (Postgresql, Mysql, Oracle, Sqlite, Snowflake)
  • Python
  • Snowflake

Business Intelligence:

  • Power Bi
  • Tableau
  • Birt
  • Excel/Odbc

Requirements Management:

  • Doors
  • Polarion
  • Jama Software
  • Ptc Windchill/Integrity

Systems Engineering:

  • Mbse (Cameo)
  • Autosar
  • Uml
  • Fmea

Additional Tools & Methods:

  • Power Bi / Dax
  • Qlik Sense
  • Talend
  • Dbt
  • Rest Api
  • Azure Devops
  • Agile / Scrum
  • Bpmn

Languages

French
Native
German
Advanced
English
Advanced
Spanish
Intermediate
Japanese
Intermediate
...and 2 more

Education

Supélec (École Supérieure d'Électricité)

Ingénieur Diplômé, Elektrotechnik & Elektronik · Electrical Engineering & Electronics

Université Paris VI (Pierre et Marie Curie)

Master (DEA), Génie Électrique · Electrical Engineering

Certifications & licenses

Statistics

Experience

Total positions 19
Experience in Automotive 17.5 y
Avg length 1 y 9 m
Longest experience 6 y 2 m

Global experience

Countries worked in 3 (France, Germany, Russian Federation)
Primary country France

Expertise

Recent roles Verification Engineer – Aviation, Requirements & Systems Architect, BI Expert & Agile Product Owner – Business Intelligence
Main industries Automotive, Aerospace and Defense, Manufacturing
Main business areas Product Development, Business Intelligence, Information Technology

Qualifications

Certifications earned 1
Member since
Last update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Have questions? Find more information here.

Pierre-Jean is based in Stuttgart, Germany and can operate in on-site, hybrid, and remote work models.

Pierre-Jean speaks the following languages: French (Native), German (Advanced), English (Advanced), Spanish (Intermediate), Japanese (Intermediate), Russian (Intermediate), Persian (Elementary).

Pierre-Jean has at least 28 years of experience. During this time, Pierre-Jean has worked in at least 19 different roles and for 16 different companies. The average length of individual experience is 2 years and 6 months. Note that Pierre-Jean may not have shared all experience and actually has more experience.

Based on recent experience, Pierre-Jean would be well-suited for roles such as: Verification Engineer – Aviation, Requirements & Systems Architect, BI Expert & Agile Product Owner – Business Intelligence.

Pierre-Jean's most recent position is Verification Engineer – Aviation at Tri.Merge GmbH.

In recent years, Pierre-Jean has worked for Tri.Merge GmbH, ZF Friedrichshafen AG, and Ineos Automotive GmbH.

Pierre-Jean is most experienced in industries like Automotive, Aerospace and Defense, and Manufacturing. Pierre-Jean also has some experience in Energy, Metals and Mining, and Healthcare.

Pierre-Jean is most experienced in business areas like Product Development, Business Intelligence, and Information Technology. Pierre-Jean also has some experience in Quality Assurance, Project Management, and Procurement.

Pierre-Jean has recently worked in industries like Automotive and Aerospace and Defense.

Pierre-Jean has recently worked in business areas like Product Development, Business Intelligence, and Information Technology.

Pierre-Jean attended Supélec (École Supérieure d'Électricité) for Electrical Engineering & Electronics.

Pierre-Jean has 1 certificate: BPMN Certification (Business Process Model and Notation).

Pierre-Jean is immediately available full-time for suitable projects.

Daily rate distribution

0% 25% 50% 75% 100%
33% of experts charge less than €640 per day.
11% of experts charge between €640 and €800 per day.
33% of experts charge between €800 and €960 per day.
11% of experts charge between €960 and €1120 per day.
11% of experts charge €1120 or more per day.
<€640 €640-​800 €800-​960 €960-​1120 €1120+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000
750
500
250
Rate comparison chart
Daily rate avg. 777 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000
750
500
250
Rate comparison chart
Median rate 800 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Calculated based on our freelancers’ daily rates as of 7 Nov 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.