Gaurav Trivedi

Data Engineer

India3 yrs 2 mos experience

Most Likely To Switch

Key Highlights

Expert in building automated data pipelines.
Proficient in Power BI and data modeling.
Strong analytical mindset focused on data accuracy.

Stackforce AI infers this person is a Data Engineer specializing in analytics and cloud-based solutions.

Contact

Skills

Core Skills

Azure Data FactoryAzure DatabricksPower BiPython

Other Skills

ADLS Gen2Azure SQLDAXPandasPySparkMicrosoft SQL ServerSQLMS SQL ServerPower QueryBig Data AnalyticsCloud Computing

About

Hi, I’m an Analytical Engineer I work at the intersection of analytics and data engineering, building automated, scalable data pipelines while also delivering business-ready insights through dashboards and reports. • Experienced in designing end-to-end data workflows using Azure Data Factory, Azure Databricks, ADLS Gen2, and Azure SQL, transforming raw data into curated datasets for analytics and reporting. • Strong background in Power BI, DAX, and data modeling, creating optimized semantic models and interactive dashboards for business users. • Proficient in Python (Pandas, PySpark) and SQL for data ingestion, transformation, enrichment, and automation. • Hands-on experience converting manual, analyst-driven processes into cloud-based, scheduled pipelines, improving performance, data quality, and reliability. • Industry experience across E-commerce, Sales, FMCG, and Billing, supporting data-driven decision-making. • Collaborated with stakeholders across India, Australia, and Canada, translating business requirements into scalable technical solutions. • Strong analytical mindset with focus on data accuracy, performance optimization, and usability. Core Skills Azure Databricks | Azure Data Factory | ADLS Gen2 | Azure SQL | Delta Lake | Power BI | DAX | SQL | Python | Pandas | PySpark | Data Modeling | ETL/ELT

Experience

3 yrs 2 mos

Total Experience

1 yr 7 mos

Average Tenure

2 yrs 3 mos

Current Experience

Telus digital

Senior Data Analyst (Azure Data Engineer)

Mar 2024 – Present · 2 yrs 3 mos · Remote

● Built an end-to-end invoice data processing pipeline using ADLS Gen2 and Azure Databricks, triggered by file arrival and scheduled jobs, applying PySpark/SQL transformations to enrich legacy metadata and reducing processing time by 75% (30 mins → 7 mins) while storing curated data in Delta Lake/Azure SQL.
● Architected an end-to-end Azure data pipeline ingesting SQL Server data from 4 regions (US, Canada, Australia, UK) using Azure Data Factory, performed cross-region data transformation and unification using Azure Databricks (PySpark), and delivered regional and consolidated global dashboards through Power BI via direct Databricks connection.
● Designed and delivered enterprise analytics dashboards by integrating data from MS SQL Server, SharePoint, and Excel into an Azure-based platform (ADLS Gen2, Azure SQL, Databricks), implementing optimized data models and DAX-driven business logic, improving reporting efficiency by 30% and enabling faster decision-making
● Automated invoice data processing pipeline using Python (Pandas) on Azure Databricks, reducing processing time by 85% (3 Hour → 15 mins). Integrated with Azure Data Lake Storage Gen2 for scalable storage and automated reporting workflows, improving accuracy and eliminating manual effort.
● Developed MS Power Automate flows to streamline the process reducing manual efforts by 30% by automating email tracking, data logging and sending customized reminders using MS 365 apps.
●Utilized MS SQL Server to extract, manipulate, and analyze large datasets, resulting in actionable insights that improved operational efficiency. Developed complex SQL queries and reports to support data-driven decision-making, enhancing reporting accuracy.

Azure Data FactoryAzure DatabricksADLS Gen2Azure SQLPower BIDAX+4

Qdegrees

Business Intelligence Analyst

Jan 2023 – Dec 2023 · 11 mos

● Developed an interactive Power BI dashboard to analyze the impact of customer churn on month-over-month revenue at Vi Telecom. Leveraged a substantial dataset of 60 million customer tags used Power Query for data transformation and manipulation, categorized by state and type, to uncover insights into revenue loss trends .
● Created Python data extraction automation with Pandas for efficient retrieval of specific data, incorporating Macros for user-friendly audit sheets for quality analysts in UpGrad and Dr. Batra's POC projects.
● Developed Hitachi dashboard through Power BI data modeling, effectively analyzing daily customer queries from diverse platforms (Twitter, Facebook, Instagram & LinkedIn etc.) used star schema concept of modelling. Ensured timely resolution within a 10-minute turnaround time & publishing on Power BI services and utilized an on-premises gateway for seamless data connectivity , with subsequent reporting and collaborating with stakeholders .
● Conducted data analysis on Vodafone's extensive EKYC data using Python, Numpy, and Pandas. Identified contributions of different circles across India and analyzed the impact of various identity-proof types by implementing data-cleaning techniques. Visualized insights using Matplotlib, Seaborn, and Plotly Express.
● Crafted SQL queries, managed SQL data, and utilized Power BI with DAX for impactful dashboards, providing hourly and daily productivity insights of quality analysts for stakeholders, aiding data-driven decisions.

Power BIPythonPandasSQLDAX