Oscar Casrto

I build decision-ready data models from industrial IoT telemetry, combining hands-on automation experience with analytics engineering.

In independent data engineering consulting, I've redesigned BigQuery partitioning and clustering for high-volume telemetry streams, reducing compute costs by 15%. I've also established dbt, SQL, documentation, and version-control standards across client repositories.

At Egger Wood Products, I built Python ingestion protocols for hardware logs and edge telemetry across automated production lines. My SQL and Prefect alerting pipelines helped prevent an estimated 10+ hours of unplanned downtime each month.

I turn operational challenges into standardized MTBF/MTTR KPIs and Power BI semantic layers, while building tested incremental dbt models, observability workflows, and data-quality practices that teams can rely on.