Jay Mahendrabhai Joshi
Verified Expert in Engineering
Data Analyst and Developer
Ahmedabad, Gujarat, India
Toptal member since July 9, 2026
Jay is a senior data analyst with 6+ years of experience in data analytics, business intelligence (BI), and data engineering. He built FinSight, an internal platform with a Python back end, AWS pipelines, and a natural-language querying layer that automated financial reporting, cutting 5 to 6 hours of manual work per week. Earlier, as a sole analyst for a US-based fitness company, Jay built their BigQuery warehouse, dashboards, and retention analytics from scratch.
Portfolio
Experience
- Data Modeling - 6 years
- Business Intelligence (BI) - 6 years
- SQL - 6 years
- Python - 6 years
- Data Engineering - 6 years
- Data Visualization - 6 years
- Data Science - 5 years
- Microsoft Power BI - 5 years
Preferred Environment
Databricks, Google BigQuery, Microsoft Power BI, Business Intelligence (BI), React, Python, SQL
The most amazing...
...platform I've built is FinSight, a centralized finance dashboard that cuts 5-6 hours of manual reporting work each week.
Work Experience
Senior Data Analyst, Financial Planning & Analysis
Amagi
- Engineered and deployed AWS EC2-hosted Python pipelines to automate end-to-end data ingestion, transformation, and delivery, eliminating manual reporting workflows for the FP&A team.
- Built FinSight, an internal FP&A intelligence platform with a Python back end, Google OAuth RBAC, and a natural language querying layer. Automated the Budget vs. Actuals pipeline through API integration, reducing 5-6 weekly reporting hours to zero.
- Developed and coded time-series forecasting models, such as ARIMA, SARIMA, GARCH, and Prophet in Python, improving budget forecast accuracy and reducing error rates for CFO-level reporting.
- Designed and shipped interactive dashboards using QuickSight, Power BI, and Looker Studio, consumed by the leadership team, powered by automated data pulls integrated via NetSuite, Salesforce, and other business system APIs.
- Identified and corrected a recurring billing error causing revenue leakage, resolving approximately $100,000 in monthly recurring revenue previously being lost.
- Analyzed employee cab service usage behavior and identified contract optimization opportunities, reducing costs by approximately 20% through data-driven renegotiation.
Data Analyst
Rocky Ventures (The Front Climbing Club)
- Served as the sole data analyst across 3 sister companies simultaneously, owning the entire data stack from warehouse to dashboard.
- Built and managed a Google BigQuery data warehouse from scratch, scheduling SQL pipelines to power daily reporting across payroll, campaign performance, billing, and member retention.
- Developed the entire back-end logic for a customer rewards program, defining the rules engine that determined member tiers and reward eligibility.
- Built a Power BI dashboard, backed by SQL and Python, giving the membership team the ability to segment and analyze different member types across multiple behavioral cuts.
- Developed a churn prediction model in Python with 60% accuracy and 74% sensitivity, deployed it to production, and increased the mode of membership duration by a month.
- Built a manufacturing project-tracking dashboard for climbing wall construction, calculating total build time and labor cost per project based on crew size and salary data.
- Designed and built Power BI dashboards end to end, partnering directly with department heads to translate business requirements into production reporting tools.
- Automated backlog intake using Power Automate, routing department project requests from MS Forms directly into Azure DevOps.
- Built a sprint tracking and analysis tool pulling data directly from multiple departments' Azure DevOps boards, providing estimate-vs-actual time analysis and trimester goal-completion insights across teams.
- Built a Power BI dashboard tracking SendGrid email campaign performance, using member segmentation analysis to determine which segments specific campaigns were targeted to.
Data Analyst Intern
Soul 2 Soul Global
- Helped set up data infrastructure, data collection, processing, and analysis methods.
- Conducted text mining on reviews given by the clients.
- Assisted in reducing the cost per click in Google Ads by 94% and increased the number of clicks by 15-fold.
Associate .NET Consultant
Dynamic Elements Technologies
- Developed APIs for the application and queries for back-end processing in the database.
- Modularized a CRM system based on a variety of requirements from the client’s end.
- Developed applications using built-in AI functions provided by Azure.
Experience
FinSight | FP&A Intelligence Platform
The platform includes a React dashboard for visualizing budget, forecast, and actuals data across the business, plus a natural language querying layer that lets non-technical users ask questions about financial data directly, without writing SQL. I own the full-stack end-to-end, from data pipeline design to back-end architecture to the user-facing dashboard, and the platform is actively used today for financial reporting and decision making.
Member Rewards Program | Back-end and Segmentation Engine
The program increased membership engagement by 40%. I owned this end to end, from the BigQuery data model through the rule logic to the reporting layer used by the membership team to support day-to-day decisions.
Education
Master's Degree in Information Systems
University of Maryland - College Park, Maryland, USA
Bachelor's Degree in Information and Communication Technology
Ahmedabad University - Ahmedabad, India
Certifications
Data Visualization with Python
Coursera (IBM)
Intermediate Python
Datacamp
Python Data Science
Datacamp
Skills
Libraries/APIs
React, Pandas, API Development, PyArrow, PyTorch, Keras, TensorFlow, Matplotlib, NumPy, SciPy, Salesforce API
Tools
Microsoft Power BI, Claude Code, BigQuery, Codex, Amazon QuickSight, Tableau, Microsoft Excel, Power Query, Amazon Athena, Google Analytics
Languages
Python, SQL
Paradigms
Business Intelligence (BI), ETL, Model Context Protocol (MCP), Azure DevOps, Database-driven Web App Development
Platforms
Databricks, Amazon Web Services (AWS), Amazon EC2, Google Cloud Platform (GCP), AWS Lambda, Salesforce, Google Ads, Azure, Microsoft Power Automate, Google Analytics 360
Storage
Database Management, Google Cloud, Database Modeling, Data Integration, PostgreSQL, Relational Databases, Microsoft SQL Server, Data Lakes
Other
Looker Studio, Google BigQuery, Data Mining, DAX, Big Data, Machine Learning, Text Mining, Customer Analytics, Claude Design, ETL Pipelines, Data Warehousing, Data Engineering, Data Science, Data Visualization, Data Analytics, Data Modeling, Data Analysis, Artificial Intelligence (AI), Dashboards, Finance, Product Management, Customer Journey Analytics, Financial Modeling, Gemini API, Large Language Models (LLMs), Web Development, Google Adwords, Azure DevOps Boards, P&L Forecasting, Natural Language Processing (NLP), Google Ad Manager, OAuth, IT Project Management, Functions
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring