Spain
• Developed multiple projects for diverse clients, implementing solutions with Google Cloud technologies, particularly Google Cloud Platform (GCP), including BigQuery, Cloud Storage, Cloud Run, Cloud Functions, Looker, Looker Studio, and Google Sheets. • Applied expertise in data analysis and data pipeline automation (ETL/ELT) using languages and tools such as Python, SQL, dbt, and Excel, as well as databases like Oracle, Microsoft SQL Server, and PostgreSQL.
• Data analysis in databases (Microsoft SQL Server and PostgreSQL) and in BigQuery using SQL • Creation of Business Intelligence reports and dashboards in Looker and Looker Studio • Development of the new Operations analytical model to be consumed at the report level in Looker and Looker Studio. The main technologies and tools I used for this project were: ◦ dbt (data build tool) ⁃ ETLs from BigQuery to BigQuery (SQL) ⁃ Creation of ad hoc models and materializations (tables, views, incremental models, etc.) ⁃ Generation of snapshots, etc. ◦ ETLs from databases (PostgreSQL and Microsoft SQL Server) to BigQuery using Python and/or Scala ◦ Looker and Looker Studio (main reporting tools) ◦ Git ◦ Azure DevOps (development in CI/CD) ◦ Apache Airflow and Apache Spark (intermediate level, hands-on experience) • Migration of BI reports made in QlikView to Looker and Looker Studio • Data analysis and reporting in Excel • I reported directly to the Director of Operations, conducting analyses independently. I coordinated projects (BI reports) collaborating with the IT Director of Operations and both internal and external stakeholders • Role focused on Data Analysis and Business Intelligence, with a strong technical component that allowed me to manage the entire data flow (end-to-end)
• Data analysis in databases (Microsoft SQL Server and PostgreSQL) and in BigQuery using SQL • Creation of Business Intelligence reports and dashboards in Looker and Looker Studio • Development of the new Operations analytical model to be consumed at the report level in Looker and Looker Studio. The main technologies and tools I used for this project were: ◦ dbt (data build tool) ⁃ ETLs from BigQuery to BigQuery (SQL) ⁃ Creation of ad hoc models and materializations (tables, views, incremental models, etc.) ⁃ Generation of snapshots, etc. ◦ ETLs from databases (PostgreSQL and Microsoft SQL Server) to BigQuery using Python and/or Scala ◦ Looker and Looker Studio (main reporting tools) ◦ Git ◦ Azure DevOps (development in CI/CD) ◦ Apache Airflow and Apache Spark (intermediate level, hands-on experience) • Migration of BI reports made in QlikView to Looker and Looker Studio • Data analysis and reporting in Excel • I reported directly to the Director of Operations, conducting analyses independently. I coordinated projects (BI reports) collaborating with the IT Director of Operations and both internal and external stakeholders • Role focused on Data Analysis and Business Intelligence, with a strong technical component that allowed me to manage the entire data flow (end-to-end)
• Data analysis in databases (Microsoft SQL Server and PostgreSQL) and in BigQuery using SQL • Creation of Business Intelligence reports and dashboards in Looker and Looker Studio • Development of the new Operations analytical model to be consumed at the report level in Looker and Looker Studio. The main technologies and tools I used for this project were: ◦ dbt (data build tool) ⁃ ETLs from BigQuery to BigQuery (SQL) ⁃ Creation of ad hoc models and materializations (tables, views, incremental models, etc.) ⁃ Generation of snapshots, etc. ◦ ETLs from databases (PostgreSQL and Microsoft SQL Server) to BigQuery using Python and/or Scala ◦ Looker and Looker Studio (main reporting tools) ◦ Git ◦ Azure DevOps (development in CI/CD) ◦ Apache Airflow and Apache Spark (intermediate level, hands-on experience) • Migration of BI reports made in QlikView to Looker and Looker Studio • Data analysis and reporting in Excel • I reported directly to the Director of Operations, conducting analyses independently. I coordinated projects (BI reports) collaborating with the IT Director of Operations and both internal and external stakeholders • Role focused on Data Analysis and Business Intelligence, with a strong technical component that allowed me to manage the entire data flow (end-to-end)
• Developed recommendation systems with Machine Learning using Python and BigQuery ML. • Created reports and performed data analysis, extracting data from the Data Warehouse.