I am a Data Engineer and BI Engineer with 8+ years of hands-on experience designing scalable data pipelines, analytical data models, and automated reporting systems across multiple industries. I specialize in end-to-end data engineering, including ingestion, transformation, orchestration, and optimization using Azure Data Factory, Databricks (PySpark), SQL, Python, and modern cloud architectures. My BI experience centers on Power BI (DAX, modeling, semantic layer design, visualization) to deliver self-service analytics and enterprise dashboards. I have a deep understanding of Lakehouse, Medallion, Warehouse, Delta Lake, and Fabric-based architectures to build reliable data ecosystems. I thrive in cross-functional teams, translating business needs into scalable, production-ready solutions, and I enjoy enabling data-driven decision-making across IT, Finance, HR, and Operations.

AYUSH BHOLA

I am a Data Engineer and BI Engineer with 8+ years of hands-on experience designing scalable data pipelines, analytical data models, and automated reporting systems across multiple industries. I specialize in end-to-end data engineering, including ingestion, transformation, orchestration, and optimization using Azure Data Factory, Databricks (PySpark), SQL, Python, and modern cloud architectures. My BI experience centers on Power BI (DAX, modeling, semantic layer design, visualization) to deliver self-service analytics and enterprise dashboards. I have a deep understanding of Lakehouse, Medallion, Warehouse, Delta Lake, and Fabric-based architectures to build reliable data ecosystems. I thrive in cross-functional teams, translating business needs into scalable, production-ready solutions, and I enjoy enabling data-driven decision-making across IT, Finance, HR, and Operations.

Available to hire

I am a Data Engineer and BI Engineer with 8+ years of hands-on experience designing scalable data pipelines, analytical data models, and automated reporting systems across multiple industries. I specialize in end-to-end data engineering, including ingestion, transformation, orchestration, and optimization using Azure Data Factory, Databricks (PySpark), SQL, Python, and modern cloud architectures.

My BI experience centers on Power BI (DAX, modeling, semantic layer design, visualization) to deliver self-service analytics and enterprise dashboards. I have a deep understanding of Lakehouse, Medallion, Warehouse, Delta Lake, and Fabric-based architectures to build reliable data ecosystems. I thrive in cross-functional teams, translating business needs into scalable, production-ready solutions, and I enjoy enabling data-driven decision-making across IT, Finance, HR, and Operations.

See more

Language

English
Fluent
Hindi
Fluent

Work Experience

Reports Architect (Data Engineering & BI) at Congruex Asia Pacific LLP
July 1, 2021 - Present
Built and optimized Azure Data Factory and Databricks (PySpark) pipelines to process 1.5M+ daily records from Salesforce, SQL Server, SharePoint, and Azure Blob Storage. Migrated legacy on-prem reporting workflows to Azure cloud to improve performance and scalability. Modernized Salesforce ingestion by migrating pipelines to Microsoft Fabric Data Pipelines, landing raw data into Fabric Lakehouse (Bronze) and creating curated datasets using Fabric Notebooks and Warehouse for Direct Lake Power BI reporting. Drove modernization by migrating multiple ADF pipelines to Microsoft Fabric Data Pipelines (FDF), standardizing ingestion, scheduling, monitoring, and reducing maintenance overhead. Developed analytical data models for sales acquisition costs, improving invoicing accuracy by 100%. Created Power BI dashboards for leadership using star-schema models, optimized DAX, and deployed via Power BI Service. Wrote and tuned SQL queries, stored procedures, and functions. Automated recurring tasks
Senior Associate – Ops (Data Engineering & BI) at WNS Global Services
November 1, 2019 - July 1, 2021
Designed and automated data processing pipelines to ingest and refresh data from IQVIA, Close-up, and SQL Server at scheduled intervals. Built parameterized, drill-down, and drill-through Power BI reports for global markets to track monthly and annual performance. Developed optimized Power BI data models and implemented Row-Level Security (RLS) to manage access for multiple manager groups. Ensured reliable, scalable reporting by maintaining automated workflows and performing routine data quality checks.
Senior Associate (BI/Analytics) at Cognizant Technology Solutions
August 1, 2017 - July 1, 2019
Built ad-hoc and automated Power BI and Excel dashboards for clients and internal managers. Extracted, transformed, and loaded data from multiple sources into Power BI to support interactive reporting. Delivered insights on global functional and technology performance, enabling data-driven decisions on digital transformation trends. Ensured data accuracy and consistency through routine processing and structured data preparation.

Education

Add your educational history here.

Qualifications

Bachelor of Technology
January 11, 2030 - January 1, 2013

Industry Experience

Life Sciences, Manufacturing, Professional Services, Software & Internet, Healthcare, Other