Andrés Santos Lopez is a skilled Senior Data Engineer with extensive experience building end-to-end data solutions across multiple industries. With expertise in Python, SQL, Azure Data Stack, and PowerBI, combined with a Civil Engineering background from BarcelonaTech, Andrés excels at translating complex data challenges into actionable business insights.
💼 Professional experience
Agilytic
Data Engineer
Since 2025
- Public Sector: Defined the architecture and best practices for a new data platform in Microsoft Fabric, leveraging the Medallion Architecture. Integrated CI/CD pipelines using Azure DevOps for automated updates. Developed custom data connectors and data pipelines to integrate data from internal systems. Collaborating closely with business stakeholders to define and implement Data Governance policies and standards.
- Intensive onboarding, including Databricks Certification, integration with Hubspot and Odoo
Sabbatical
2023-2025
Undertook a sabbatical to focus on personal development, explore new career directions, and manage significant family and project milestones.
Kerry Group
Data Engineer 2021 - 2023
- Development, deployment, and maintenance of data pipelines supporting financial reporting, marketing, and sales dashboards in PowerBI.
- Introduced data quality best practices for both current and new data warehouse developments. Coordinated the creation of quality checks within the teams and supervised their implementation.
- Developed an early warning system to forecast market trends in critical raw material commodities for the business. Integrated multiple data sources to provide an automated and unique view for commodity analysis.
- Disaster event data from GDACS
- USDA agricultural import/export data combined with commodity spot and futures prices for fundamental analysis
- Integration of google earth engine imagery processing for the computation of NDVI and NDMI indexes measuring vegetation health
- Integration of data related to major global geopolitical events
- Developed a solution in PowerBI to calculate the Nutri-Score as well as other nutritional scores in other markets. The solution provided an always online and central solution for the marketing team.
- Integrated the market product information to identify nutritional scores with potential for improvement using Kerry technology.
EY Luxembourg
Senior Consultant Digital Transformation 2018-2021
- Enhancement of a Data Management framework for a major public investment bank. Improved reporting policies, procedures, and governance frameworks in alignment with the DAMA-DMBOK principles. I supported the operations department in understanding and implementing Data Governance.
- Designed and deployed a cloud-based data data warehouse using Azure SSIS and Data Factory to power PowerBI dashboards. This reporting solution provided a comprehensive analysis of SME creation and closure rates over a 25-year period, incorporating key parameters such as industry, general manager’s age, location, legal status, reason for closure, and business survival rates.
- Developed and implemented business process automation solutions across several business functions and industries.
- Multinational steel manufacturer: Vendor Compliance and Onboarding, HR Payroll Processing, Finance Accounts Receivable reporting
- Major cargo airline: Tax reporting, Account reconciliation
- Major insurance company: Claims processing
- Developed PoC for process automation supporting business development opportunities.
🦾 Certifications, trainings
Methodologies
- Project Management (PMP, Scrum)
- Data Platform Architecture
- Data pipeline (ETL, Data Warehousing)
- Data Modelling
- Reporting and Dashboarding
- Web scraping
- Business Process Modelling
Software & programming
- Azure Data Stacks (Azure Data Factory, Azure Databricks, Fabric)
- Fabric Data Engineer Associate (DP-700)
- Python, PySpark and R
- SQL
- PowerBI
- REST API
- Web Development (HTML, CSS)
🎓 Academic credentials
- MSc Civil Engineering, Construction BarcelonaTech, 2017
🇺🇳 Languages
🇬🇧 English: fluent
🇪🇸 Spanish: native
🇫🇷 French: intermediate
🔐 Proprietary and confidential. 💡 Profile CVs are provided for illustration purposes. ✅ Planning of specific experts will be secured upon formal agreement.