MUHAMMAD SHAKIR
BI | ETL Engineer
Faisalabad
Summary
Results-driven Business Intelligence Engineer with 5+ years of experience in designing, developing, and implementing end-to-end data pipelines and business intelligence solutions. Skilled across the Microsoft BI Stack, Azure ecosystem, and Microsoft Fabric with expertise in ETL/ELT, data modeling, and analytics. Proficient in Power BI for enterprise reporting, including RLS, deployment pipelines, governance, and publishing apps. Experienced in PySpark, Fabric Lakehouse, and Delta tables for modern data engineering solutions. Recognized for stakeholder collaboration, requirements gathering, and transforming data into actionable insights through compelling storytelling and visualizations.
Overview
6
6
years of professional experience
4
4
Certifications
3
3
Languages
Work History
Sr. BI | ETL Engineer
BRICKCLAY
01.2020 - Current
- Designed, developed, and implemented ETL/ELT pipelines using SSIS and Azure Data Factory.
- Implemented PySpark based transformations and worked with Fabric Lakehouse & Delta tables, Dataflows for modern big data solutions.
- Leveraged Azure Synapse Analytics and Azure Data Lake Storage for large-scale data processing and integration.
- Built and optimized data warehouse models (facts, dimensions, staging layers) for scalable analytics.
- Developed and monitored SQL Jobs, alerts, and SSIS packages via SQL Server Agent.
- Built semantic models in Azure Analysis Services and Power BI for enterprise-wide reporting.
- Designed and published Power BI dashboards and apps, applying row-level security (RLS), deployment pipelines, and governance best practices in Power BI Service.
- Delivered stakeholder-driven insights, gathering requirements and translating them into actionable KPIs, dashboards, and stories that influenced strategic decisions.
- Developed and deployed SSRS reports and SSAS cubes with advanced DAX and MDX measures.
- Delivered analytics solutions in Microsoft Fabric, leveraging its integration with Power BI and Lakehouse architecture.
- Supported operational teams through project transitions, ensuring adherence to technical standards, scalability, and stability.
Education
MSc - Information Technology
University of Sargodha
06.2019
Bachelor of Commerce - undefined
Government Commerce College
06.2015
Skills
Data Engineering ( SQL, SQL Server Integration Services)
Microsoft Azure (Data Factory (ADF), Azure Synapse Analytics, Azure Data Lake Storage, Azure SQL)
Microsoft Fabric (Dataflows, Delta tables, Lakehouse, Warehouse, Pipeline, Semantic Model, Pyspark notebook)
SQL Optimization
MS SQL Server (T-SQL, Stored Procedures, Views, Functions)
SQL Optimization & Performance Tuning
Indexing strategies (Clustered, Non-Clustered, Covering Indexes, Statistics)
Data Warehousing(Star Schema, Snowflake, Fact, Dimension)
Data Modeling, Data Cleaning, Transformation & Profiling
Business Intelligence & Reporting (Power BI Desktop, Looker Studio, Metabase, Power Query)
SSAS (DAX & MDX), RLS, SSRS
Azure DevOps (Boards, Wiki, Repo)
CI/CD Pipelines
GitHub
Jira
Stakeholder Collaboration & Requirement Gathering
Data Storytelling & Visualization
Strong Communication & Presentation Skills
Time Management & Conflict Resolution
Decision Making & Problem Solving
Team Leadership & Collaboration
Team Player
Continuous Learner
Self-Motivated
Certification
Microsoft Certified: Data Analyst Associate December 2020
Interests
Learning new things, Travelling, Sports (Cricket, badminton)
Timeline
Sr. BI | ETL Engineer
BRICKCLAY
01.2020 - Current
Bachelor of Commerce - undefined
Government Commerce College
MSc - Information Technology
University of Sargodha