Jesus Jayaro

Senior Data Engineer

Calgary, AB | Open to Remote | Bilingual (English/Spanish)

Senior Data Engineer | Business-Focused Solutions

18+ years bridging operations and technology across oil & gas (Schlumberger, TechnipFMC, Nabors), finance, and manufacturing globally. I design data solutions that deliver measurable ROI. Currently building AI agents in Azure Foundry and Microsoft Fabric for enterprise automation.

ETL Performance
75%
faster through parallelization
Cost Reduction
20-30%
Power BI & Synapse
Response Time
15min
from days (observability)
NPT Reduction
0.2%
of sales (lowest in Americas)

Enterprise Projects & Results

Performance optimization, cloud migrations, real-time analytics, and automation that eliminate manual processes.

Performance & Optimization

ETL Parallelization & Optimization

Refactored sequential ETL into parallel workflows, reducing processing time by 75%

Power BI Capacity Optimization

Reduced capacity usage by 30% through workspace consolidation and report optimization

Synapse DWU Optimization

Cut Synapse costs by 20% through query tuning and resource management

Stored Procedure Optimization

Rewrote legacy procedures for significant performance improvements

ADF & Power Automate Observability

Built monitoring reducing incident response from days to under 15 minutes

Migrations & Modernization

Synapse to Microsoft Fabric Migration

Evaluated migration assistant, delivered production-grade POC for enterprise adoption

On-Prem to Cloud SQL Server Migration

Led full migration from on-premises infrastructure to Azure

SSIS to ADF Migration

Unified all data operations in Azure Data Factory

Server Agent to ADF

Migrated legacy SQL Server Agent jobs to cloud-native orchestration

File Share to SharePoint Migration

Migrated from C# scripts to ADF with optimization and log management

Digital Transformation

Safety PowerApp

Field incident reporting app replacing paper process. Initial notification went from days to seconds

OCR & ML Document Processing

Automated ingestion of 800K scanned documents using computer vision

Service Desk & DevOps Integration

Automatic notifications, task creation, two-step approval, and ticket closure

RPA for Legacy Systems

Automated data ingestion from systems only accessible via front-end

Automatic Document Generation

Power Automate flows for default notices and paper renewal notifications

Enterprise Integrations

Dataverse to Synapse Integration

Unified CRM, LOS, and F&O Dynamics data into analytics platform

UltiPro / Dynamics HR / F&O Integration

End-to-end employee data synchronization across HR systems

SharePoint Ingestion via Graph API

Replaced Power Automate with ADF for scalable document ingestion

Fabric Event-Based Pipelines

Real-time SQL Server integration using Fabric Activator

Multi-Source Integrations

API, FTP, SFTP, ADLS to Synapse and Microsoft Fabric

Leadership & Enablement

Microsoft Fabric POCs

Production-grade examples of integration methods for data engineer training

Power Platform Center of Excellence

Implementation, governance, and cleanup of unused resources

DevOps Setup & Team Lead

Designed ops model and managed cross-functional team

Data Model Refactoring

Refactored legacy rewards program with business stakeholders, implemented new logic

sqlmesh & dbt POCs in Fabric

Evaluated modern transformation frameworks for new warehouse architecture

AI & Intelligent Agents

AML Agent POC

Anti-money laundering agent for automated compliance workflows

Next Best Action Agent POC

Intelligent recommendation agent for customer engagement

Experience & Skills

Career Path

  • 2022-Present
    Senior Data Engineer @ Innovation FCU


  • 2022
    Data Engineer @ Finning (CAT)


  • 2021-2022
    Power Platform Developer @ Innovation CU


  • 2014-2019
    Quality Specialist @ TechnipFMC, Nabors


  • 2007-2010
    Field Engineer @ Schlumberger (Oman, Venezuela)


  • 2005-2006
    Hurricane Research @ University of Florida

Technical Stack

Python SQL Microsoft Fabric Azure Synapse Azure Data Factory Databricks Power Platform Power BI Dynamics 365 Root Cause Analysis ISO 9001 Lean Six Sigma Rust Delta Lake Docker

Key Certifications

  • Microsoft Fabric Data Engineer Associate
  • IBM Data Science Professional Certificate
  • TapRoot Incident Investigation & RCA
  • ISO 9001:2015 Internal Auditor

BSc Mechanical Engineering, University of Florida (2005) | Bilingual: English & Spanish

Open Source & Side Projects

Building tools and exploring emerging technologies in Rust and modern data platforms. These projects demonstrate depth in areas beyond day-to-day enterprise work.

When I'm Not Working

Aurora Chasing Storm Chasing Photography Mountain Biking Urban Farming

Let's Build Something Together

Ready to discuss how I can help your team deliver measurable data engineering results?