Open to opportunities

Mahad Ahmad

@mahadahmad

Message

Data analyst with 3+ years building Power BI, BigQuery SQL pipelines, and executive dashboards that drive decisions.

Pakistan

Message

What I'm looking for

I’m looking for a role where I can build trusted BI dashboards and scalable SQL/ETL pipelines, partnering with stakeholders to translate complex marketing, sales, and finance data into decisions.

I’m a Senior Data Analyst with 3+ years of experience building Power BI dashboards, optimizing SQL, and engineering reliable data pipelines. I’ve delivered end-to-end financial reconciliation in BigQuery—aligning revenue, COGS, fees, ad spend, and cost of returns—and used multi-layer transformations (staging to mart) to make metrics consistent and audit-friendly.

I partner with stakeholders to turn complex data into actionable insights, including executive reporting tracking $5.9B in pipeline and 7,500+ leads weekly. I’m strong in DAX, Power Query, T-SQL, Python, and ETL tools like SSIS and Azure Data Factory, and I’ve automated validations, HubSpot integrations, and data sync workflows to improve reporting reliability and reduce manual effort.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Analyst

Current

Omnisec Solutions

Jan 2026 - Present (6 months)

Led validation and financial reconciliation of BigQuery data models using multi-layer SQL transformations and SCD Type 2 cost history. Built executive Power BI dashboards and analyzed cost of returns to identify margin erosion drivers from Amazon source tables.

BigQuery SQL Power BI DAX Data Modeling Financial Reconciliations Python Data Validation Margin Analysis

Data Analyst

Zones IT Solutions

Jan 2024 - Dec 2025 (1 year 11 months)

Designed and maintained Power BI dashboards for marketing and sales, including lead tracking, WoW/YoY logic, drill-through analysis, and segmentation. Built automated data validation queries and engineered SSIS-to-Azure Data Factory pipelines, plus HubSpot API integrations using Python and Power Automate.

Power BI DAX SQL Server SSIS Azure Data Factory Power Automate Python HubSpot Data Validation ETL KPI Analysis Funnel Analysis Segmentation

Data Analyst

IntegCubes

Apr 2023 - Dec 2023 (8 months)

Collaborated with ACWA Power to deliver executive dashboards for portfolio, revenue/exchange, and HR analytics. Engineered SSIS and Talend Studio data migration workflows and built a real-time Mitigation Action Tracker in Power BI to support project management.

Power BI DAX SSIS Talend SQL Server PostgreSQL Dashboarding HR Analytics Data Migration Data Visualization

Data Analyst

Egeeks Global

Aug 2022 - Apr 2023 (8 months)

Transformed raw data into actionable insights for a diverse set of clients, tailoring data solutions and Power BI dashboards to each client’s objectives and KPIs. Delivered clear dashboards to support informed decision-making across multiple industries.

Power BI Data & Analytics Dashboarding

Education

Degrees, certifications, and relevant coursework

COMSATS University Islamabad (Wah Campus)

Bachelor of Science, Electrical Engineering

2017 - 2022

B.S. in Electrical Engineering at COMSATS University Islamabad (Wah Campus). Completed coursework supporting engineering foundations and applied technical skills.