BILLAL ALLOUCHE
Data Engineer at Hager group
Salary / Daily rate
Strasbourg, France
Mobility: Basel, Luxembourg, ...
Freelance, open to permanent contract
Can come onsite
Skills
Languages
About me
Intro
Motivated Data Engineer with substantial work experience in international and multicultural environments. Interested in data analysis, data warehousing and data quality, along with proficiency in SQL, Informatica, Power BI and Python Good analytical skills gained through work experience as a research engineer in France and South Korea as well as PhD studies in Condensed Matter Physics. Quick learner with a good ability to delve into fields not previously studied or known.
Work experience
Data Quality Analyst/Engineer
Hager Group
Sep 2023 - Present
3 years 2 months
Obernai, France
- Assess and monitor Data Quality at the Group level - Develop and maintain Insightful Dashboards - Develop and maintain Informatica Cloud ETL pipelines - Microsoft Azure Cloud (certified) - Power BI - Problem-solving
University of Strasbourg
Sep 2020 - Present
6 years 2 months
Strasbourg, France
Adjunct Lecturer
Sep 2022 - Present
4 years 2 months
Strasbourg, France
Teaching PL/SQL hands-on course at the Faculty of Mathematics and Computer Science : - Modeling and querying relational databases; - PL/SQL procedures and functions; - Triggers; - Indexing and query optimization.
Data Analyst/Engineer
Sep 2020 - Aug 2023
3 years
Strasbourg, France
- Developing, expending and maintaining Talend ETL Projects: extraction of data from Oracle transactional databases, transformation and integration into a PostgreSQL data warehouse; - Design of data models (star schema) for data warehousing; - Optimizing existing Talend projects for better performance; - Querying and reporting using SQL and SAP Business Objects; - Design of Business Objects for automated reporting; - Data analysis and reporting using Excel, Python and SAP Business Objects; - Database reliability: automated periodic SQL queries to check for inconsistent entries or missing data; - Reporting to decision makers (Microsoft Office and Latex); - Collaborating with différent stakeholders in order to validate a data warehouse; -Dashboarding using DigDash; - Competences gained in: data modeling, SQL, Web Intelligence, Excel and Python.
Data Analyst
Council of Europe
Jul 2020 - Aug 2020
2 months
Strasbourg, France
- Extraction, analysis and visualization of social media data (Facebook, LinkedIn, YouTube, Instagram and Twitter); - Python scripting for data extraction via the Instagram Graph API as well as the YouTube API; - Development of a Python based tool for data transformation and loading; - Dashboarding using Tableau software.
Data Analyst
Divalto
Feb 2020 - May 2020
4 months
Entzheim, France
- Predictive analysis of logs from a Cloud platform; - Development ETL + visualization flows using the logstash-Elasticsearch-Kibana stack tool; - Data analysis using Python (Pandas, Matplotlib and other libraries).
Data Science : Professional training
ICAM
Oct 2019 - Mar 2020
6 months
Région de Strasbourg, France
Subjects studied: Databases and Data Warehousing; Data Integration (Alteryx, Talend), Analytics and Visualisation (Tableau, PowerBI); Web Technologies (HTML); Machine Learning (scikit-learn); Project Management.
Postodoctoral Research Scientist
Gwangju Institute of Science & Technology
Oct 2017 - Oct 2019
2 years 1 month
Gwangju, South Korea
- Design, fabrication and study of a Graphene based nano devices; - Writing and publishing academic research; - Organizing and presenting at academic conferences and other events;
Lecturer in Physics of Condensed Matter (ATER)
Université de Picardie Jules Verne
Oct 2014 - Aug 2016
1 year 11 months
Amiens, France
- Course design, teaching and assessment for undergraduate-level courses on General Physics and Electronics; - Co-supervised Bachelor’s and Master’s theses and mentored students.
Education
École Doctorale Sciences, Technologie, Santé Amiens
PhD in Physics, Condensed Matter and Materials Physics
2011 - 2015
3 years 9 months
Institut national des Sciences appliquées de Rouen
Master's degree, Materials Science - chemistry & Biology - polymers and surfaces
2010 - 2011
1 year 1 month
UFR Physique & Ingénierie / University of Strasbourg
Master of Engineering (MEng), physics and materials science
2008 - 2010
2 years 1 month