Acerca de 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.
Alemán
Bilingüe o nativo
Español
Bilingüe o nativo
Inglés
Competencia profesional completa
Francés
Competencia profesional básica
Catalán
Nociones
Solo teletrabajo
Lleva a cabo sus proyectos principalmente en remoto
Experiencia
- divibib GmbHSenior Pentaho ConsultantPRENSA & MEDIOSnoviembre de 2019 - Hoy (6 años y 7 meses)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 Expertabril de 2018 - diciembre de 2020 (2 años y 8 meses)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 ConsultantINGENIERÍA MECÁNICAenero de 2019 - mayo de 2019 (4 meses)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
Recomendaciones
Sé el primero en recomendar a Juan C.
Ayuda a este freelance a destacar compartiendo tu experiencia.
Estos perfiles de freelance también coinciden con tus criterios
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
Formación
- "Diplom-Informatiker"Universität Karlsruhe"Diplom-Informatiker"
- Fernuniversität