Open to opportunities

Aaftab Gowani

@aaftabgowani

Message

I’m a Senior Data Engineer and BI specialist delivering secure, scalable analytics end-to-end.

Zimbabwe

Message

What I'm looking for

I’m looking for a role where I can own end-to-end analytics—ETL, semantic modeling, and secure Power BI reporting—while partnering with stakeholders to improve data quality, performance, and reliability in a modern cloud environment.

I’m a Data Engineer and BI professional with 8+ years of experience delivering end-to-end analytics—from ETL development and data modeling to reporting and business analysis. I focus on building and modernizing ETL pipelines and designing dimensional/aggregation data models optimized for self-service Power BI, with deep expertise in semantic model design, DAX measures, row-level security (RLS), and gateway configuration.

Across Azure and Oracle ecosystems, I’ve implemented scalable cloud data models, integrated heterogeneous source systems, and optimized SQL/Oracle PL/SQL for query performance, validation, and reconciliation. I partner with stakeholders to drive data quality, reporting adoption, and continuous improvement, while owning documentation artifacts like data dictionaries and pipeline/model specifications to keep systems audit-ready.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Engineer

Current

Charter Communications

Jun 2024 - Present (2 years)

Enhanced and partially modernized Informatica-based ETL pipelines, aligning on-prem source integrations with Azure cloud targets while preserving data lineage and auditability. Built scalable data models and Power BI semantic models (DAX, RLS, gateway configuration) and partnered with stakeholders to troubleshoot production issues and improve performance and reliability.

Informatica Azure Data Factory Databricks Pyspark Data Modeling Power BI DAX SQL Data Lineage

Data Engineering Senior Analyst

Accenture Solutions Pvt. Ltd.

Feb 2021 - Dec 2022 (1 year 10 months)

Designed and optimized ETL workflows with Azure Data Factory, Databricks, and PySpark, improving transformation accuracy and efficiency by 30%. Optimized SQL to reduce query execution time by 25%, implemented CI/CD for automated ETL deployments (reducing deployment errors by 30%), and reduced manual effort by 40% through ADF triggers and activities; mentored junior engineers and reduced onboarding

Azure Data Factory Databricks Pyspark SQL CI CD ETL Development Query Optimization Data Warehousing Mentorship

Programmer Analyst

Bitwise Solutions Pvt. Ltd.

Sep 2019 - Feb 2021 (1 year 5 months)

Implemented ETL pipelines using Azure Data Factory and Databricks, streamlining processing workflows and reducing execution times by 30%. Developed and optimized PySpark scripts to improve processing speed and reduce memory usage by 30%, integrated Azure Key Vault to achieve 100% security policy compliance, and optimized Azure Data Lake/SQL solutions to improve query performance by 25% while impro

Azure Data Factory Databricks Pyspark Azure Blob Storage Azure SQL Azure Key Vault Data Integration Agile Delivery ETL

Associate Consultant

Capgemini India Pvt. Ltd.

Aug 2016 - Aug 2019 (3 years)

Migrated and optimized ETL workflows by transitioning from Ab Initio to Informatica and designing scalable data pipelines for complex data integration. Automated and validated data processes using Unix shell scripting, Tivoli workflows, and custom Python utilities, improving operational efficiency by 35%, and built interactive Power BI dashboards to enable near real-time decision-making.