Open to opportunities

Divyansh Soni

@divyanshsoni

Message

Data analyst specializing in scalable ETL, cloud pipelines, and business intelligence for finance.

United States

Message

What I'm looking for

I seek roles where I can build scalable cloud ETL/BI solutions, collaborate cross-functionally, drive data-driven decisions, and grow in cloud/data engineering.

I am a results-driven data analyst with experience building scalable ETL and big-data pipelines on Azure and AWS, developing interactive BI solutions with Power BI and Tableau, and delivering actionable financial and operational insights that improve ROI and reduce manual effort. I have led portfolio and campaign analyses, automated data workflows with Airflow and Glue, and implemented data solutions that cut processing time and staff effort significantly.

My work blends strong programming (Python, PySpark, SQL), cloud and data-integration expertise (Databricks, Synapse, Redshift, ADLS, S3), and business-focused visualization to enable real-time decision making. I collaborate across teams using Agile practices to translate stakeholder needs into repeatable, reliable analytics and reporting.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

JPMorgan Chase & Co.

Feb 2025 - Present (7 months)

Streamlined financial reporting with Power BI and DAX, saving 2 hours weekly and ensuring timely nonprofit reports; built Azure Databricks PySpark pipelines to process terabytes/day into ADLS and Azure Synapse for trading and risk insights, and led financial analysis for 35+ client portfolios to deliver ROI and cost insights.

Power BI DAX Pyspark Databricks Azure Synapse ADLS Python Financial Analysis ETL

Data Analyst

Illinois Institute of Technology

May 2024 - Dec 2024 (7 months)

Designed ETL workflows for 5,000+ student records with Python, Airflow and SQL, reducing staff effort by 75%; built Tableau dashboards and automated SEVIS processing with VBA and advanced Excel, cutting manual effort by 60% and accelerating analysis time from 10 to 6 hours weekly.

Python Apache Airflow SQL Tableau Advanced Excel VBA ETL Data Visualization

Data Analyst

Accenture

Jan 2020 - Dec 2022 (2 years 11 months)

Built automated ETL pipelines with AWS Glue and S3 to deliver real-time partner and campaign insights, increased partner revenue 15% and Lenovo partner program ROI 25% via performance modelling on Redshift; conducted A/B tests that raised redemptions 10%.

AWS Glue AWS S3 Amazon Redshift Tableau Python SQL A B Testing ETL Agile

Education

Degrees, certifications, and relevant coursework

Illinois Institute of Technology

Master of Science, Computer Science

2023 - 2024

Activities and societies: Designed and implemented ETL workflows, automated SEVIS data processing, and built interactive Tableau dashboards for institutional analytics.

Master of Science in Computer Science program completed with focus on data engineering, analytics, and ETL workflows applied to institutional datasets.