Genaro Diaz

Rebuilt a fragile legacy Python pipeline into a medallion-architecture pipeline on Snowflake, scaling from 2 to ~150 client organizations. Reduced Power BI load times from 30-60+ seconds to 5-10 seconds and cut Snowflake costs by tuning Time Travel retention and refactoring queries.

Designed and implemented pipelines feeding Looker and QuickSight dashboards, and led migration of PostgreSQL from IBM Cloud to AWS, reducing costs by 12%. Refactored SQL and Glue jobs improving execution time by 45%.

Ran a gap analysis between Oracle SCM fields and the existing Snowflake model, closing gaps by ingesting missing attributes and remapping tables. Extended the Snowflake data model and built supporting pipelines with views, stored procedures, tasks, and streams.

Advised a hydroelectric power company on the architecture and roadmap for a new data lake as part of its digital transformation strategy. Conducted cross-departmental stakeholder interviews and documented the target architecture for the data lake and ingestion pipelines.

Led development of data ingestion processes from SFTP into Snowflake, ensuring data accuracy and availability. Reverse-engineered and documented 12 legacy SAS ETL workflows, rebuilt them in Snowflake with dynamic SQL and JavaScript stored procedures, and integrated them into Airflow orchestration.

Implemented Matillion ETL as a low-code, self-service tool for non-technical departments. Built batch and near real-time data pipelines and APIs on AWS and Snowflake, and led migration of legacy Oracle data warehouses to S3 and Snowflake.

Moved a client's data platform from an on-premise Oracle server to Microsoft Azure, eliminating a single point of failure. Replaced Data Factory loads with Databricks jobs, rebuilt the data warehouse on Azure Synapse with a star schema and bronze/silver/gold layers.

Developed ETL/ELT processes and reports supporting data-driven decisions across government agencies. Led a re-engineering project that automated a manual process, cutting completion time from one week to 40 minutes, and optimized dashboards with a caching strategy.

Built a sales data mart from Excel sources and the SAP Lumira dashboard on top of it, owning both the ETL and the front end. Developed Oracle PL/SQL logic and MicroStrategy reports.

Bachelor's degree in Systems Engineering from the National Technological University, Regional Faculty Córdoba, completed in 2017.

Completed the Azure Databricks Core Technical Training (ADB) and the AWS Data Engineer program.