Hamza Khan

I’m a results-driven BI Analyst who leads business intelligence efforts that turn raw data into reliable warehouses, departmental data marts, and decision-ready dashboards. I focus on data analysis, modeling, and engineering that improves accessibility and performance across teams.

As a Team Lead Business Intelligence, I centralized about 90% of company data into a robust warehouse and designed department-specific data marts for Accounting, Payroll, and HR. I optimized dimensional models for query performance and storage efficiency, consulted on database architecture, and delivered executive dashboards that directly influenced C-level decision-making.

I also help teams move faster and more consistently through agile methodologies and strong delivery practices. I increased project turnaround times by 30%, streamlined project management and client communication, and mentored junior team members in data modeling, SQL, Power BI, and ETL—so they build durable, adaptable BI skills.

Previously, I built ETL pipelines using SSIS and ADF, developed Power BI dashboards for Salesforce and TikTok data, and optimized SQL and DAX queries for faster reporting. I’ve also worked as a Data Analyst analyzing sales, inventory, and customer data with Excel/Power Query, improving sales by 50%, and I’ve recently adopted Microsoft Fabric to deliver end-to-end analytics solutions.