The role involves designing, building, and optimizing ETL pipelines using Microsoft Fabric and Medallion Architecture to power data-driven decisions across the firm. Responsibilities also include improving infrastructure scalability, monitoring data quality, and supporting business intelligence tools.