Hitesh Bharat Gohil
Senior Data Analyst @ Optum
- Role
- Senior Data Analyst at Optum
- Location
- Bellevue, WA, US
- LinkedIn followers
- 500 followers
About Hitesh Bharat Gohil
Hitesh is a Senior Data Analyst at UHG-Optum with 5+ years of experience in turning complex healthcare data into strategic business decisions.He has led enterprise-scale data initiatives that have reduced business risk exposure by over $200M, uncovered $110M+ in missed billing opportunities, and resolved multimillion-dollar claim discrepancies. His work sits at the intersection of data engineering, analytics, and business strategy — building not just dashboards, but trusted end to end data systems and fostering a self-service analytics culture.He specializes in-Designing scalable ETL/ELT pipelines (Azure Data Factory, Azure Databricks, Alteryx, dbt)-Building governed enterprise data marts and KPI frameworks-Statistical analysis, forecasting, and experimentation (A/B testing, hypothesis testing)-Transforming manual processes into automated, production-grade workflows-Data quality engineering and monitoring systemsIf you have any questions or opportunities that align with my skill set, do contact me.Contact Information : h••••••••@gmail.com
Experience
Senior Data Analyst
Jun 2022 — Present · Seattle, WA, US
Created an end-to-end data pipeline using Alteryx, Python to analyze and visualize prospect client data into Tableau dashboards, delivering business insights that identified high-risk clients and mitigated $50M+ in potential risk• Engineered a data-driven billing analytics framework that uncovered $100M in annual missed billing; provided actionable insights and recommendations that enabled senior leadership to redesign Optum’s billing process• Built and automated ETL workflows in Alteryx by eliminating 100% manual work and daily reporting dependency• Developed cloud-based ELT pipelines in Azure Data Factory to ingest and store raw data in Databricks Delta tables, improving data reliability and report performance• Implemented a self-service reporting suite integrating ADF, Alteryx – SQL, and Power BI to streamline data quality checks; reduced research time by 80% and enabled early outlier detection for Operations SMEs• Formulated a statistical risk prediction model in Python for identifying 340B pharmacy claims during the RFP process, increasing prediction accuracy from 7% to 51% and improving client risk evaluation decisions• Developed a scalable data mart to support 10+ interactive dashboards in PowerBI for 5+ stakeholder teams, reducing report latency by 97% • Collaborated with Finance team to conduct SQL based data reconciliation, diagnosing a $1.2M claim discrepancy• Analyzed and defined new KPIs for pharma rejections that enabled stakeholders to successfully dispute $300K+ • Partnered with clinicians to build Power BI performance monitoring tool for outlier detection, improving data visibility and enabling proactive decision-making• Designed and implemented data models in Power BI by integrating Azure and Databricks sources to support dynamic, executive-level dashboards
Education
University at Buffalo
Master's degree, Industrial Engineering
2018 — 2020
KJ Somaiya College of Engineering, Vidyavihar
Mechanical Engineering
2014 — 2018
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.