Über Juan C.
I am an Enterprise Data Architect specializing in Data Vault and open-source data platforms
Competencies
- Enterprise Data Warehouse Architecture
- Data Vault 2.0 (Raw Vault, Business Vault)
- Open-Source Data Platforms (PostgreSQL, Apache ecosystem)
- Data Platform Modernization
- Modern Data Stack (dbt, ELT architectures)
Typical missions
- Architecture of Enterprise Data Warehouses
- Migration from legacy BI and ETL platforms
- Architecture, design and implementation of Data Vault 2.0 models
- Performance optimization of large-scale data pipelines
- Technical leadership and mentoring for data engineering teams
Technologies
- Data Vault 2.0
- PostgreSQL
- SQL
- dbt
- Spark
- BigQuery
- Redshift
- Apache Hop
- Pentaho
- SQLMesh
What I do
- I combine data architecture expertise with hands-on data engineering experience and regularly support teams as a lead data engineer in complex data platform projects.
- I typically work on enterprise-scale data platforms and modernization programs involving large data volumes and complex legacy BI environments.
- I support organizations from architecture design to implementation and platform stabilization in production environments.
Deutsch
Muttersprachlich oder zweisprachig
Spanisch
Muttersprachlich oder zweisprachig
Englisch
Verhandlungssicher
Französisch
Konversationssicher
Katalanisch
Grundkenntnisse
Projekt- und Berufserfahrung
- divibib GmbHSenior Pentaho ConsultantPRESSE & MEDIENNovember 2019 - Heute (6 Jahre und 7 Monate)Wiesbaden, Germany• Taking operational responsibility (DevOps) and stabilisation• Further development of the BI solution (Kettle/Pentaho Data Integration, Pentaho BA Server and PostgreSQL)• Streamline development and deployment processes• Automate partitioning by cluster• Fixing security vulnerabilities of the Pentaho BA Server (9.3 CE)• Development of an enterprise data warehouse according to Data Vault 2.0 as a single source of truth using Apache Hop, SQLMesh and PostgreSQL• Implementation of workshops to develop the requirements• Reverse Engineering and optimising legacy code with ChatGPT• Replacement of the Pentaho solution
- Thales Management & Services Deutschland GmbH,Senior Pentaho ExpertApril 2018 - Dezember 2020 (2 Jahre und 8 Monate)Ditzingen, Germany• Independent technical implementation support for business intelligence solutions and the development of data cubes and dashboards for the areas of logistics/materials management and Air Traffic Transport (ATM)• Development and testing of new cubes and reports with JasperReports• Provision of ad-hoc queries on JasperReports Server• Creation of technical concepts and design for new requirements (data model, structures, flows, and visualization)• Conducting requirements gathering workshops• Development and implementation of database-based monitoring and scheduling for Pentaho Data Integration• Support in the migration of project structures (SAP PS) and costs from multiple SAP systems to a single target SAP system• Migration of file directories to the file-based PDI repository• Support and conducting training courses as part of the migration of the version control system from Subversion to Git• Optimisation of development and deployment processes
- AG der Dillinger Hüttenwerke,Senior BI ConsultantMASCHINENBAUJanuar 2019 - Mai 2019 (4 Monate)Dillingen/Saar, SL, Germany• Support for Scalefree in modelling an enterprise data warehouse according to Data Vault 2.0 for the technical domain• Creation and modelling of the Business Vault (intermediate layer of a Data Vault containing business logic)• Performance optimisation of SQL queries on PostgreSQL• Knowledge transfer and presentation of results• Project documentation
Empfehlungen
Sei die erste Person, die Juan C. empfiehlt
Teile Deine Erfahrung aus der Zusammenarbeit mit diesem Freelancer.
Diese Freelancer passen auch zu Ihren Kriterien
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
Ausbildung und Abschlüsse
- "Diplom-Informatiker"Universität Karlsruhe"Diplom-Informatiker"
- Fernuniversität