Data Engineer Royal Bank of Scotland
Architected and scaled an enterprise Snowflake-based data platform, defining target architecture, conceptual, logical, and physical data models, and enterprise data standards. The platform supported fivefold data growth and improved processing performance by 20%.
Co-led data strategy and governance initiatives covering governance policy, RBAC, data quality, and metadata and catalog management. Designed ETL/ELT pipelines, data warehousing, and migration solutions using dbt, Python, SSIS, and AWS DMS, improving pipeline efficiency by 25%.
Partnered with BI, analytics, operations, and business teams to deliver scalable architecture and expand Power BI and Tableau adoption, producing $200K in cost savings. Served as a data architecture SME, led mentoring for engineers and analysts, and guided architectural reviews, performance improvements, and compliance initiatives.
Created bank-wide Test-Driven Development and Trunk-Based Development frameworks adopted across more than 10 applications, improving code quality, release safety, and delivery efficiency.