Hi there! I'm Mohil Jain, a results-driven data analyst with 4+ years of experience translating complex datasets into actionable insights across finance, healthcare, and technology. I enjoy turning busy data into clear, strategic recommendations using SQL, Python, R, ETL processes, and advanced BI tools. I design data pipelines, predictive models, and interactive dashboards to optimize decision-making, and I thrive in Agile, cross-functional teams that value data-driven outcomes. I have delivered impact at American Funds, Molina Healthcare, and ZS Associates by combining analytics, storytelling, and automation. I’m passionate about improving data quality and operational efficiency, and I love collaborating with product, marketing, and strategy teams to align insights with business goals.

Mohil Jain

Hi there! I'm Mohil Jain, a results-driven data analyst with 4+ years of experience translating complex datasets into actionable insights across finance, healthcare, and technology. I enjoy turning busy data into clear, strategic recommendations using SQL, Python, R, ETL processes, and advanced BI tools. I design data pipelines, predictive models, and interactive dashboards to optimize decision-making, and I thrive in Agile, cross-functional teams that value data-driven outcomes. I have delivered impact at American Funds, Molina Healthcare, and ZS Associates by combining analytics, storytelling, and automation. I’m passionate about improving data quality and operational efficiency, and I love collaborating with product, marketing, and strategy teams to align insights with business goals.

Available to hire

Hi there! I’m Mohil Jain, a results-driven data analyst with 4+ years of experience translating complex datasets into actionable insights across finance, healthcare, and technology. I enjoy turning busy data into clear, strategic recommendations using SQL, Python, R, ETL processes, and advanced BI tools. I design data pipelines, predictive models, and interactive dashboards to optimize decision-making, and I thrive in Agile, cross-functional teams that value data-driven outcomes.

I have delivered impact at American Funds, Molina Healthcare, and ZS Associates by combining analytics, storytelling, and automation. I’m passionate about improving data quality and operational efficiency, and I love collaborating with product, marketing, and strategy teams to align insights with business goals.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Work Experience

Data Analyst at American Funds
February 1, 2024 - November 5, 2025
Designed and optimized ETL pipelines (AWS Glue, Athena, S3) processing 12M+ investor records from multiple data sources. Built churn-prediction models using Python (scikit-learn logistic regression) achieving 87% accuracy to inform retention strategies. Created Power BI dashboards with advanced DAX, drill-throughs, and slicers, reducing reporting time by 30% and boosting campaign targeting efficiency by 20%. Implemented data validation, NULL scans, and distribution tests with engineering teams, driving 99.9% accuracy and a 22% reduction in errors. Performed cohort analysis and clustering to identify investor behavior patterns, contributing to an 18% increase in engagement. Automated data-cleaning scripts to standardize pipelines, cutting manual effort by 40% and improving governance through SQL-based rules. Collaborated with Product, Marketing, and Client Strategy to define KPIs and align insights with retention goals, and designed executive dashboards to monitor fund performance and d
Data Analyst Intern at Molina Healthcare
December 1, 2023 - December 1, 2023
Extracted and processed healthcare claims data (GCP BigQuery, SQL, Python) with 99.8% accuracy across inpatient, outpatient, and pharmacy claims. Conducted clustering and regression analyses to identify chronic conditions driving 18% higher annual costs, informing cost-control strategies. Built Looker dashboards with anomaly detection and data blending, cutting report access time by 25%. Automated claims validation scripts in Python, reducing manual processing time by 30%. Designed predictive models to forecast hospitalization risks to help prioritize high-risk members and support care coordination. Ensured HIPAA-compliant workflows and presented weekly insights to leadership to influence budgeting and outreach programs.
Data Analyst at ZS Associates
August 1, 2022 - August 1, 2022
Led analysis of pharmaceutical sales data across 6 regions, improving forecasting accuracy by 15% and enabling 10% sales growth in underperforming markets. Developed time-series forecasting models with 95% confidence, optimizing regional marketing spend. Designed Azure Data Factory ETL pipelines processing 2M+ rows with 100% data integrity. Created Tableau dashboards with real-time drill-downs, increasing reporting efficiency by 30% and reducing decision time by 15%. Applied R regression models to quantify marketing spend impact, showing 7% sales uplift per 10% budget increase. Collaborated with Sales, Marketing, Product, and Engineering in Agile sprints; automated data cleaning with Python (Pandas, NumPy) to cut preprocessing time by 35%. Integrated Salesforce and DynamicsCRM data into pipelines and built KPI dashboards to monitor sales growth, product adoption, and regional performance. Supported ad-hoc requests by delivering SQL-based reports (reduced turnaround by 40%).

Education

Master of Science in Business Analytics at Drexel University
September 1, 2022 - March 1, 2024
Bachelor of Technology at Symbiosis University of Applied Sciences
August 1, 2017 - June 1, 2021

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Healthcare, Software & Internet, Professional Services