Open to opportunities

Mumtaz Amjad

@mumtazamjad

Message

I build scalable analytics-ready data warehouses, models, and ELT pipelines.

Pakistan

Message

What I'm looking for

I'm looking to advance in dbt-based analytics engineering, building scalable analytics-ready data layers, improving data quality, and translating business requirements into structured transformation logic.

At Royal Cyber, I design analytics-ready Snowflake data models and build scalable SQL transformations for enterprise reporting and business intelligence.

I've built and optimized 30+ ELT pipelines across staging, core, and data mart layers, resolved 80+ data-quality issues, and worked with dbt models and workflows for modular transformations.

At ZONG CMPAK, I led enterprise reporting, standardized KPI definitions, enabled self-service analytics that reduced ad-hoc requests by 30%, and mentored a team of 12 analysts.

Across telecom, insurance, and healthcare, I've built 60+ warehouse pipelines, designed dimensional models, integrated sources with Talend and SQL, and maintained reliable data through validation, historical tracking, and incremental loads.

Experience

Work history, roles, and key accomplishments

Assistant Manager – BI & Analytics

ZONG CMPAK

Jan 2022 - Dec 2023 (1 year 11 months)

Led enterprise reporting ensuring consistent KPI definitions across teams. Enabled self-service analytics reducing ad-hoc requests by 30% and standardized reporting frameworks improving stakeholder satisfaction by 60%.

Business Intelligence Reporting KPI Standardization Team Management Stakeholder Management

Senior Data Engineer

ZONG CMPAK

Jan 2020 - Dec 2022 (2 years 11 months)

Built 60+ pipelines into enterprise data warehouse and designed Star and Snowflake schema models for analytics. Delivered executive dashboards for CXO and business teams and optimized SQL transformations for performance.

Data Warehouse SQL Data Modeling Star Schemas Dimensional Modeling (Star And Snowflake Schemas)Dashboarding Performance Optimization

ETL Consultant

Teradata

Jan 2017 - Dec 2019 (2 years 11 months)

Integrated multiple data sources using Talend ETL and SQL, ensuring ~99% data accuracy through validation and testing. Implemented historical tracking and incremental load logic and used Talend TDM for test data management.

Talend ETL SQL Data Validation Historical Tracking Incremental Load Test Data Management

IT & Network Support Officer

Telenor

Jan 2014 - Dec 2017 (3 years 11 months)

Provided IT and network support services, ensuring system reliability and user assistance.

Senior Data Engineer

Royal Cyber Inc.

Jan 2024 - Present (2 years 8 months)

Designed and implemented analytics-ready data models in Snowflake for enterprise reporting. Built and optimized 30+ ELT pipelines, resolved 80+ data quality issues, and translated business requirements into scalable SQL transformation logic.

Snowflake ELT SQL Data Modeling Data Quality DBT