Leonardo Alves Francisco

My work includes: → Pipeline Validation: Designing automated and manual DQ control layers across Bronze/Silver/Gold medallion layers — validating schema enforcement, referential integrity, and business rule compliance. → Defect Lifecycle Management: Operationalizing structured defect creation, triage, ownership assignment, and SLA tracking to ensure full traceability from source to report. → Standards Compliance: Implementing data quality standards aligned to IDMP/PMS and EMA regulatory requirements across ingestion, transformation, and consumption layers. → Pipeline Development: Building ULCM (EMA Union List of Critical Medicines) ingestion pipelines with ATC hierarchy integration and Gold layer design for Power BI consumption. → Observability: Using metrics and feedback loops to reduce recurring issues and improve data trust over time.

My work includes: → RBAC Architecture: Designing and operationalizing role-based access control models aligned with Azure AD / Microsoft Entra — workspace binding strategy, catalog isolation, and UC Permissions API governance across 7 production catalogs. → Metadata Management: Supporting metadata discovery, documentation, and stewardship to improve transparency and traceability across all data assets in Unity Catalog.

→ Access Governance: Auditing cross-workspace access via system.access.audit and building catalog/object/workload inventories with Delta tables for full traceability. → Identity Integration: Leveraging Microsoft Graph API to integrate group and membership information into access governance workflows. → Policy Enforcement: Automating governance workflows and enforcing standards across dev, QA, and production environments.

My work includes: → DQ Framework: Built an end-to-end data quality framework with automated defense layers — blocking and warning pipelines, defect creation workflows, and quality scorecards. → Rule Versioning: Introduced versioning for DQ rules and configurations using Redis and JSON-based structures, enabling controlled rollouts, full traceability, and consistent execution across dev/staging/prod. → Testing Strategy: Designed and executed comprehensive manual and automated test plans across reporting and ETL pipelines to validate complex scenarios and edge cases. → Defect Management: Established a structured defect lifecycle (creation, prioritization, triage, and follow-up) to accelerate resolution and reduce data trust incidents. → Stakeholder Alignment: Coordinated with cross-functional teams to align data quality standards and streamline ozperations end-to-end.