Hello, I am
Sagar Soni.
1
SQL Project
About Me
I’m a Data Engineering professional with 4+ years of experience in data analytics, focused on building scalable, reliable, and efficient data pipelines that transform raw data into meaningful business insights.
My technical skills include SQL, Python, PySpark, Apache Spark, Azure Databricks, Microsoft Fabric, and ETL/ELT pipelines, with a focus on data transformation, data quality, data warehousing, and Medallion Architecture (Bronze, Silver, and Gold).
I build real-world data pipelines, including:
- Designing pipelines to ingest, clean, transform, and process data.
- Implementing Bronze, Silver, and Gold layers using modern lakehouse architectures.
- Working with Delta Lake, incremental data processing, and data optimization.
- Building data workflows using Azure Data Factory, Azure Databricks, and Microsoft Fabric.
My goal is to build reliable data solutions that improve efficiency, enable better decision-making.
Building Reliable Data Pipelines That Drive Business Growth.
Key Skills
Python
SQL
PySpark
Databrick
Microsoft Fabric
dbt
Apache Airflow
Apache kafka
Apache Spark
Azure
Data Warehouse
Delta Lake
ADLS Gen2
ELT/ETL
Data Modeling
Git
Azure Data factory
My Projects
My Experience
𝗔𝗧𝗟𝗜𝗤 𝗧𝗘𝗖𝗛𝗡𝗢𝗟𝗢𝗚𝗜𝗘𝗦
𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗜𝗻𝘁𝗲𝗿𝗻 | Sep 2026 – Present
• Engineered 5+ batch ETL pipelines using Azure Data Factory, ADLS Gen2, Azure Databricks, and PySpark.
• Implemented Bronze, Silver, and Gold data layers using Medallion Architecture and Delta Lake.
• Developed 20+ dbt models, including fact and dimension models, with data quality tests.
• Integrated curated datasets with Microsoft Fabric and Power BI for analytics and reporting.
• Automated dbt validation workflows using GitHub Actions.
𝗖𝗔𝗦𝗘𝗣𝗢𝗜𝗡𝗧 𝗣𝗩𝗧. 𝗟𝗧𝗗.
𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 & 𝗠𝗜𝗦 | Mar 2026 – Jul 2026
• Processed and transformed 500K+ business records using SQL, Python, Advanced Excel, and Power Query.
• Developed 5+ interactive Power BI dashboards for KPI monitoring and business performance analysis.
• Automated 3+ recurring reporting workflows using Python scripts, Excel formulas, and AI-assisted tools.
• Delivered accurate reports and actionable business insights to support data-driven decision-making.
𝗘𝗠𝗜𝗡𝗘𝗡𝗧 𝗣𝗔𝗣𝗘𝗥 𝗜𝗡𝗗𝗨𝗦𝗧𝗥𝗜𝗘𝗦 𝗟𝗟𝗣
𝗠𝗜𝗦 & 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 | Jan 2024 – Mar 2026
• Processed and analysed 2M+ business records for reporting and operational performance tracking.
• Extracted, cleaned, validated, and transformed datasets using SQL, Python, Advanced Excel, and Power Query.
• Maintained 65+ reports and dashboards supporting 5+ business teams.
• Streamlined operational and reporting workflows using Google Apps Script and Google Workspace tools.
• Developed interactive Looker Studio dashboards and automated recurring reports using advanced spreadsheet functions and AI tools such as ChatGPT and Gemini.
𝗛𝗔𝗦𝗛𝗧𝗔𝗚 𝗜𝗡𝗙𝗢𝗦𝗬𝗦𝗧𝗘𝗠
𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 | Jan 2022 – Dec 2023
• Queried and analysed 200K+ business records using SQL, Python, and Advanced Excel.
• Developed 10+ Power BI dashboards and recurring reports for KPI monitoring and business analysis.
• Streamlined recurring reporting using advanced Excel functions, including LOOKUPs, IF, SUMIF, COUNTIF, and FILTER.
• Supported 3+ business teams by maintaining structured datasets and delivering accurate, timely reports.
Awards & Certificate
Let's Connect
Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.