Mayela Zambrano

• Led migration of an on-prem warehouse toward Azure Fabric Lakehouse, orchestrating pipelines that called partner APIs and landed Parquet files for downstream transformations. Implemented medallion architecture (bronze/silver/gold) with PySpark for scalable, testable ELT.

• Built enterprise Power BI dashboards for executive leadership and aligned data models to KPIs to enable self-service analytics.

• Drove data modeling standards and performance tuning across Fabric Lakehouse tables to keep refreshes predictable at scale.

Helped research systems within the company and improve processes for carrying out their day-to-day operations

• Ingested and organized healthcare data from Kafka streams and batch sources into the enterprise data warehouse, normalizing into Teradata with domain-specific schemas (tables, views, stored procedures).

• Integrated upstream Informatica ETL feeds and maintained subject-area databases for business units; enforced data contracts and lineage.

• Scheduled and monitored pipelines with Control-M, improving on-time SLAs and incident response.

• Delivered and maintained MicroStrategy and Power BI dashboards; managed 10+ dashboards used by 100+ stakeholders and reduced reporting errors by ~40% via data quality checks and DQ monitors.

• Partnered with analysts and product owners to translate business rules into robust SQL/PySpark transformations and semantic models.