Data Engineer - Expert ODI
EDF
(Energy, water and environment, >10.000 employees)
Keywords
Information Engineering
Data Analysis
Microsoft Azure
Power BI
SQL Databases
Health Care
Insurance Management and Aftercare
Python (Programming Language)
Visualization
Raw Data
Skills
Data Engineer & Analyst | 8 Years Experience
I'm a seasoned Data Engineer and Data Analyst with 8 years of hands-on experience. I've had the privilege of spearheading impactful data projects across diverse sectors, such as energy, healthcare, insurance, retail, and more.
Expertise:
• Data Engineering: I specialize in designing robust data architectures and pipelines.
• Data Analysis: Turning raw data into actionable insights is my forte.
• Technologies: Proficient in Azure, Power BI, SQL, Python and ODI.
Why Work With Me?
• I bring a wealth of experience from diverse industries.
• My skills span the entire data lifecycle, from ingestion to visualization.
• Passionate about leveraging technology to drive impactful business decisions.
Let's Collaborate:
Whether you're embarking on a new data project or looking to optimize existing processes, I'm here to help. My expertise, coupled with a passion for problem-solving, makes me a valuable asset to any data-driven initiative. Let's connect and explore the possibilities!
Looking forward to connecting with fellow data enthusiasts and professionals!
I'm a seasoned Data Engineer and Data Analyst with 8 years of hands-on experience. I've had the privilege of spearheading impactful data projects across diverse sectors, such as energy, healthcare, insurance, retail, and more.
Expertise:
• Data Engineering: I specialize in designing robust data architectures and pipelines.
• Data Analysis: Turning raw data into actionable insights is my forte.
• Technologies: Proficient in Azure, Power BI, SQL, Python and ODI.
Why Work With Me?
• I bring a wealth of experience from diverse industries.
• My skills span the entire data lifecycle, from ingestion to visualization.
• Passionate about leveraging technology to drive impactful business decisions.
Let's Collaborate:
Whether you're embarking on a new data project or looking to optimize existing processes, I'm here to help. My expertise, coupled with a passion for problem-solving, makes me a valuable asset to any data-driven initiative. Let's connect and explore the possibilities!
Looking forward to connecting with fellow data enthusiasts and professionals!
Project history
01/2024
-
Present
01/2020
-
12/2023
Data Engineer/Analyst - Azure, Databricks, Power BI
AXA Partners
(Insurance, 500-1000 employees)
Lead of data projects within the Finance Department's data team
* Lead international workshops with finance teams, actively gathering requirements
for process automation, data visualisation, and introducing new KPIs
* Supervise operational data integration workflows in the ADLS Gen2 data lake
using Qlik Replicate. Develop SQL and PySpark scripts, seamlessly integrating
them into ETL flows through Azure Data Factory
* Execute Star modeling for data marts and Azure Analysis Services cubes,
showcasing proficiency in database design principles
* Pioneer the development of comprehensive reports, dashboards, and Power
BI applications for financial data visualisation projects such as Cash Flow,
Invoice Processing, PnL, Budget Monitoring, and Financial Reconciliation
(AR/AP)
* Apply expertise in PowerQuery (M Code) for modeling datasets and dataflows,
implementing advanced DAX formulas to create impactful Key Performance
Indicators (KPIs)
* Implement Power Automate flows to streamline raw data collection operational
processes, enhancing efficiency and data accuracy
* Develop a comprehensive Power BI report consolidating usage metrics of all
reports across workspaces and Azure Analysis Services cubes, utilising Excel
and Kusto queries via Azure Log Analytic
* Lead the centralisation of data repositories and implement robust data quality
control measures, demonstrating a commitment to data integrity / accuracy
* Actively maintain and continuously improve projects in production (RUN), displaying
dedication to ongoing enhancements and optimisations
* Draft meticulous technical documentation and user manuals, contributing to
effective knowledge transfer and user adoption
* Conduct comprehensive training sessions for end-users, facilitating a smooth
transition and ensuring proficient utilisation of Power BI reports
Developer of AAS cube and Power BI reports for the Business Line Health within
the Customer & Innovation Department's data team
* Actively participate in various workshops with healthcare professional managers
to meticulously define requirements and business rules
* Spearhead the development and industrialisation of insightful Power BI reports,
facilitating the visualisation and in-depth analysis of data derived from
Angel and BonjourDocteur services
* Implement robust Row-Level Security (RLS), strategically restricting access
to health data to ensure compliance and confidentiality for specified users
* Author comprehensive and detailed documentation for Power BI reports, providing
clear guidelines for understanding and utilisation
* Collaborate closely with data engineers and data managers in the seamless
integration of operational data into the datalake, execute star modeling for
datamarts, and play a pivotal role in the creation of Azure Analysis Services
AAS cubes
Skills: Azure Databricks/ Data Factory/ Storage Explorer/ Analysis Services/ Log
Analytics/ DevOps, Spark, SQL, KQL, Power BI, M Code, Power Automate
* Lead international workshops with finance teams, actively gathering requirements
for process automation, data visualisation, and introducing new KPIs
* Supervise operational data integration workflows in the ADLS Gen2 data lake
using Qlik Replicate. Develop SQL and PySpark scripts, seamlessly integrating
them into ETL flows through Azure Data Factory
* Execute Star modeling for data marts and Azure Analysis Services cubes,
showcasing proficiency in database design principles
* Pioneer the development of comprehensive reports, dashboards, and Power
BI applications for financial data visualisation projects such as Cash Flow,
Invoice Processing, PnL, Budget Monitoring, and Financial Reconciliation
(AR/AP)
* Apply expertise in PowerQuery (M Code) for modeling datasets and dataflows,
implementing advanced DAX formulas to create impactful Key Performance
Indicators (KPIs)
* Implement Power Automate flows to streamline raw data collection operational
processes, enhancing efficiency and data accuracy
* Develop a comprehensive Power BI report consolidating usage metrics of all
reports across workspaces and Azure Analysis Services cubes, utilising Excel
and Kusto queries via Azure Log Analytic
* Lead the centralisation of data repositories and implement robust data quality
control measures, demonstrating a commitment to data integrity / accuracy
* Actively maintain and continuously improve projects in production (RUN), displaying
dedication to ongoing enhancements and optimisations
* Draft meticulous technical documentation and user manuals, contributing to
effective knowledge transfer and user adoption
* Conduct comprehensive training sessions for end-users, facilitating a smooth
transition and ensuring proficient utilisation of Power BI reports
Developer of AAS cube and Power BI reports for the Business Line Health within
the Customer & Innovation Department's data team
* Actively participate in various workshops with healthcare professional managers
to meticulously define requirements and business rules
* Spearhead the development and industrialisation of insightful Power BI reports,
facilitating the visualisation and in-depth analysis of data derived from
Angel and BonjourDocteur services
* Implement robust Row-Level Security (RLS), strategically restricting access
to health data to ensure compliance and confidentiality for specified users
* Author comprehensive and detailed documentation for Power BI reports, providing
clear guidelines for understanding and utilisation
* Collaborate closely with data engineers and data managers in the seamless
integration of operational data into the datalake, execute star modeling for
datamarts, and play a pivotal role in the creation of Azure Analysis Services
AAS cubes
Skills: Azure Databricks/ Data Factory/ Storage Explorer/ Analysis Services/ Log
Analytics/ DevOps, Spark, SQL, KQL, Power BI, M Code, Power Automate
01/2017
-
12/2019
Data Engineer - ODI
EDF
(Energy, water and environment, >10.000 employees)
Technical lead for data integration flows for the " MCP" Retail Customer Market in dedicated data warehouses within the
Business IT Department's data team
* Analyse functional requirements with the project managers and participation in strategic choices with the architects
* Develop ELT pipelines with ODI 12c (Variable, Procedure, Mapping, Package, Scenario, Load Plan) and PySpark
* Develop parameter-setting of data integration scripts in SQL, PL/SQL, Hive and HbaseQL
* Data modelling with PowerDesigner and generation of SQL scripts
* Carry out unit, integration and non-regression tests
* Draft technical and functional documentation
* Handle requests for assistance from MCO and aMOA teams
* Analyse and resolve data anomalies in pre-prod and production
* Training new data engineers in the use of ODI 12c
* Supervision of each developer's deliverables before all production releases
* Draft the roadmap for each production release, as well as its end-to-end supervision
Skills: Oracle, ODI 12c, Hbase, Hive, Sqoop, Spark, GitLab, SVN, KSH, PowerDesigner, Jira, Confluence
Business IT Department's data team
* Analyse functional requirements with the project managers and participation in strategic choices with the architects
* Develop ELT pipelines with ODI 12c (Variable, Procedure, Mapping, Package, Scenario, Load Plan) and PySpark
* Develop parameter-setting of data integration scripts in SQL, PL/SQL, Hive and HbaseQL
* Data modelling with PowerDesigner and generation of SQL scripts
* Carry out unit, integration and non-regression tests
* Draft technical and functional documentation
* Handle requests for assistance from MCO and aMOA teams
* Analyse and resolve data anomalies in pre-prod and production
* Training new data engineers in the use of ODI 12c
* Supervision of each developer's deliverables before all production releases
* Draft the roadmap for each production release, as well as its end-to-end supervision
Skills: Oracle, ODI 12c, Hbase, Hive, Sqoop, Spark, GitLab, SVN, KSH, PowerDesigner, Jira, Confluence
10/2016
-
12/2016
Data Engineer/Analyst - Talend
Axège
(Pharmaceuticals and medical technology, 10-50 employees)
* Develop data integrating flows for medico-economic data from hospital centres into a data wharehouse
* Create data visualisation reports using Axege software package
Skills: Talend, Axege, Oracle, PostgreSQL, SQL
* Create data visualisation reports using Axege software package
Skills: Talend, Axege, Oracle, PostgreSQL, SQL
04/2016
-
09/2016
Data Analyst - MSBI, Netezza, Cognos
Toupargel
(Industry and mechanical engineering, 250-500 employees)
* Handle data visualisation requests from marketing and sales teams by developing on-demand reports via SQL scripts
connected to Excel or SSRS
* Carry out macro-checks of the data in the reports generated with that in the Cognos cubes
* Setting-up management rules for generated reports and communication of reports to business teams
* Automation of recurring requests via stored procedures scheduled with ODI 11g
Skills: Netezza, Cognos, SSRS, ODI 11g, SQL, NZPLSQL, LATEX
connected to Excel or SSRS
* Carry out macro-checks of the data in the reports generated with that in the Cognos cubes
* Setting-up management rules for generated reports and communication of reports to business teams
* Automation of recurring requests via stored procedures scheduled with ODI 11g
Skills: Netezza, Cognos, SSRS, ODI 11g, SQL, NZPLSQL, LATEX
Certifications
Local Availability
Open to travel worldwide
