Open to opportunities

Gerardo Orellana

@gerardoorellana

Staff Data Engineer driving scalable platforms and team growth with Snowflake, dbt, and cloud innovation across global organizations.

Ecuador

Message

Experienced Staff Data Engineer with expertise in Snowflake, dbt, AWS, and cloud data pipelines. Proven leader building scalable platforms, optimizing data workflows, and mentoring teams. Holds a master’s in Data Science, certified in SnowPro Core and machine learning. Passionate about solving complex problems and advancing technology to deliver business value in multicultural environments.

Experience

Work history, roles, and key accomplishments

Current

Staff Data Engineer

Current

Paylocity

Feb 2025 - Present (8 months)

Design and implement organization-wide data engineering components and lead DBT platform execution; lead data pipeline projects from requirements to delivery and mentor team members to raise platform and engineering capabilities.

Event Driven Architecture dbt Snowflake Python AWS CDC Jinja Data Warehouse Architecture Project Management

Senior Data Engineer

Paylocity

Sep 2022 - Feb 2025 (2 years 5 months)

Designed and implemented shared data platform components and ingestion frameworks; developed AWS infrastructure with Pulumi/CDK and optimized core Snowflake components to support company-wide reporting.

Pyspark DBT Snowflake Python Pulumi AWS CDK Airflow Data Lakes Infrastructure as Code Data Lake

Senior R&D Software Engineer

BairesDev

Aug 2021 - Aug 2022 (1 year)

Engineered cloud and serverless data ingestion, transformation, and delivery features; optimized SQL-heavy processes and designed REST APIs to normalize and store large datasets in SQL databases.

ETL SQL MySQL Python AWS Serverless Data Processing API Design Performance Tuning

Senior Software Developer

Indurama

Jun 2018 - Aug 2021 (3 years 2 months)

Designed and developed integrations between on-premise and cloud ERP systems via REST APIs and batch processes; built high-availability client apps and pipelines to ingest manufacturing data for downstream use.

Pl SQL REST APIs ETL Oracle Database Python Java Django PL SQL SQL System Integration

Research Assistant

Universidad del Azuay

Oct 2017 - Jun 2018 (8 months)

Researched and evaluated text-similarity and NLP methods, built proof-of-concept pipelines for model inference, and authored academic reports to inform departmental NLP project strategies.

Natural Language Processing Python Jupyter Applied Machine Learning Data Analysis Academic Writing Model Deployment Experimentation

Software Developer

Indurama

Oct 2014 - Aug 2015 (10 months)

Led a multidisciplinary team to develop marketing and data-acquisition software using Oracle APEX and PL/SQL; redesigned legacy solutions and delivered new products tailored to business needs.