
Muhammad Shoaib
Verified Expert in Engineering
Data Warehousing Developer
Málaga, Spain
Toptal member since December 18, 2019
Muhammad is a data architect, BI, and data engineering specialist with 13+ years of experience delivering comprehensive data solutions, including data warehousing, ETL/ELT, BI, and modern data stack implementations for enterprise clients across the US and Europe. He has a proven track record in full-lifecycle project delivery, advanced data modeling, architecture design, and leading managed services across pharmaceutical, telecommunications, financial, and regulatory sectors.
Portfolio
Experience
- Data Engineering - 13 years
- SQL Server Integration Services (SSIS) - 13 years
- Business Intelligence (BI) - 13 years
- Data Warehousing - 13 years
- SQL - 13 years
- Data Build Tool (dbt) - 5 years
- Azure Data Factory (ADF) - 4 years
- Snowflake - 4 years
Preferred Environment
Data Engineering, Data Warehousing, Data Build Tool (dbt), Data Analytics, Microsoft Power BI, Azure Data Factory (ADF), Apache Airflow, Microsoft BI Stack, Snowflake, Business Intelligence (BI)
The most amazing...
...thing I've done is deliver enterprise-wide data solutions, from modeling to managed services, enabling insights and compliance.
Work Experience
Data Architect | Data Engineer (Business Intelligence, Data Warehouse, and ETL/ELT)
Self-employed
- Designed and implemented end-to-end data analytics and visualization solutions, delivering actionable insights to stakeholders across multiple business units.
- Collaborated with business and technical teams to define project scope, translating requirements into scalable architecture and implementation plans.
- Orchestrated cross-team collaborations to unify fragmented data sources, enabling a single source of truth for enterprise reporting.
DataOps Engineer
PepsiCo Global - Main
- Monitored daily ETL pipelines, processing over two million records across multiple data sources, ensuring 99.9% data accuracy and timely availability for reporting.
- Collaborated with business stakeholders to gather requirements, translating them into actionable data solutions that supported strategic decision-making.
- Maintained production data pipelines, resolving system failures within SLA and ensuring uninterrupted access to critical operational data.
Senior Principal BI/DWH Engineer
360factors, Inc.
- Managed the data warehouse production environment, monitoring 100% of ETL processes daily and resolving data anomalies within SLA, ensuring 99.9% data accuracy.
- Led end-to-end project lifecycle activities, including planning, estimation, development, testing, and deployment, delivering projects on time with zero critical production defects.
- Spearheaded knowledge-sharing sessions, upskilling 5+ team members in best practices for database design, ETL optimization, and machine learning implementation.
Principal BI/DWH Engineer
360factors, Inc.
- Modeled and implemented the data warehouse architecture, analytics data stores, and reporting for a SaaS-based platform.
- Developed target data models, including data policies for sensitive data assets, security policies, back-up, and recovery specifications.
- Applied techniques to optimize performance with large data sets at both the ETL and reporting levels.
- Migrated the data from a client's existing running application to a newly deployed system to make their data operational and meaningful as per the new system.
Senior ETL/DWH/BI Engineer
Afiniti
- Worked closely with analysts and data scientists to develop meaningful data to model machine learning algorithms.
- Verified the quality and integrity of data as part of this process (including reconciling key metrics).
- Assisted in both ad-hoc requests and regular reports for various business segments.
- Collaborated with several teams to understand their business needs and translate them into actionable data analysis and reports.
- Planned, designed, and streamlined ETL tasks, verifying data quality and integrity as part of this process.
Senior ETL/DWH/BI Consultant
Qordata (formally known as Streebo IM)
- Led the team of consultants on different engagements of ETL and data warehousing.
- Researched, wrote, and edited the documentation and technical requirements, including evaluation plans, test results, technical manuals, and formal recommendations and reports.
- Developed end-to-end, various data-driven solutions, including analysis, architecture, design, development, deployment, and maintenance.
- Offered thought-leadership and proficiency in the architecture, design, and evolution of the data management system while interacting with business users to ensure BI data architecture and organizational needs are met.
- Participated in organizational growth by providing in-house technical training, conducting interviews, and enhancing processes, standards, and other related activities that contribute toward operational excellence.
Technical Consultant on ETL, Data Warehouse (DWH), and Business Intelligence (BI)
Streebo
- Designed and implemented various reports and prepared dashboards.
- Engineered the process to extract data from multiple sources and performed data preprocessing using ETL tools.
- Provided technical support in database implementation and deployment.
- Performed load-optimization process for Kalido DIW, SSIS packages, and Microsoft SQL Server stored procedures for a worldwide assurance company.
- Contributed to the POC of an MDM for a medical malpractice insurance company.
Experience
A Comparative Study of Data-mining Techniques for HCV Patients’ Data
Reusability of Data Marts
Managed Services
Data Engineering for AI Models
Design and Implementation of a Data Warehouse for a SaaS Platform
Education
Bachelor of Science Degree in Computer Science
University of Karachi - Karachi, Pakistan
Certifications
Talend Data Integration Certified Developer using Talend Studio
Qlik
Microsoft Certified: Azure Data Engineer Associate
Microsoft
Microsoft Certified Solutions Associate: SQL Server 2012/2014
Microsoft
Skills
Libraries/APIs
REST APIs
Tools
SSAS, Talend ETL, Talend Data Integration, Microsoft Power BI, Tableau, Microsoft Access, Microsoft Excel, IBM InfoSphere (DataStage), Spotfire, Apache Airflow, VPN, Looker, BigQuery, Power BI Desktop, GitLab CI/CD, Power BI Embedded
Languages
SQL, Python, Visual Basic for Applications (VBA), Snowflake, Visual Basic, C#
Paradigms
ETL Implementation & Design, ETL, Business Intelligence (BI), Database Design, Continuous Integration (CI), Continuous Development (CD)
Platforms
Azure, Azure SQL Data Warehouse, Microsoft BI Stack, Airbyte, Azure Synapse Analytics, Amazon Web Services (AWS), Salesforce
Storage
Microsoft SQL Server, Databases, Data Pipelines, Database Modeling, Database Management, SQL Server Integration Services (SSIS), MySQL, Azure SQL Databases, PostgreSQL, Database Administration (DBA), Relational Databases, Data Integration, Azure SQL, DB, Amazon S3 (AWS S3), Cloud Firestore, Azure Cosmos DB
Frameworks
ASP.NET, .NET
Other
Data Modeling, Data Analysis, Data Analytics, Data Architecture, Star Schema, Data Warehousing, Data Engineering, ETL Development, ETL Tools, Data Build Tool (dbt), Data Transformation, Database Schema Design, Data Orchestration, Data Collection, ETL Pipelines, Data Cleansing, Data Center Infrastructure, Communication, Design, Team Leadership, Data Migration, Computer Science, Consulting, DAX, Data Warehouse Design, Azure Data Factory (ADF), Monte Carlo, CI/CD Pipelines, Dashboards, Data Visualization, Machine Learning, Data Science, FTP, SFTP, APIs, MotherDuck, Airtable, Reporting, Data Reporting, Google BigQuery, Dashboard Design, Data Dogs, Sage ERP, Customer Relationship Management (CRM)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring