Sanjana Mendadala
@sanjanamendadala
Data Analyst who turns healthcare and insurance data into trusted KPIs, dashboards, and automated ETL insights.
United StatesWhat I'm looking for
I’m a Data Analyst with 4 years of experience across healthcare, insurance, and marketplace analytics, delivering data validation, trend analysis, metric standardization, dashboards, and decision-ready reports. I enjoy being the bridge between complex datasets and stakeholder clarity.
In my current role at Definitive Healthcare, I develop and maintain ETL workflows using SQL, Python, Databricks, and Azure Synapse Analytics, integrating healthcare data from sources like Azure Cosmos DB, MySQL, and Oracle. I build Tableau dashboards, Power BI reports, and SSRS datasets for claims, clinical, provider, member, and operational KPIs—then support analysis with advanced SQL and KQL. I also automate ingestion/transformation/reconciliation with Python and Apache Airflow, reducing manual effort by 20%, and add data-quality checks to improve early detection by 15%.
Earlier, at Niva Bupa, I designed ETL using Informatica PowerCenter, S2T mappings, Alteryx, Python, and SQL, and I optimized large queries across Teradata, Snowflake, Redshift, and AWS for performance and reliability. At Cars 24, I gathered requirements, translated them into technical specs, built dashboards and paginated reporting, and supported dimensional modeling (star and snowflake schemas) and UAT with structured testing and documentation.
Experience
Work history, roles, and key accomplishments
Developed and maintained ETL workflows integrating healthcare data for reporting and analytics. Built Tableau, Power BI, and SSRS assets, automated ingestion/validation with Airflow, and implemented data-quality checks.
Graduate Research Assistant
Auburn University at Montgomery
May 2024 - May 2025 (1 year)
Analyzed innovation ecosystem research data and supported business and economic development insights. Cleaned and analyzed qualitative and quantitative datasets, performed literature and benchmark analysis, and produced reports and presentations for stakeholders.
Data Analyst
Niva Bupa Health Insurance
Jul 2022 - Jun 2023 (11 months)
Designed ETL workflows to integrate healthcare data for reporting and analytics. Built and standardized RxClaim/claims KPIs in BI tools, optimized query performance across data warehouses, and delivered ad hoc reporting based on stakeholder needs.
Gathered business requirements and translated them into technical specifications for reporting, data modeling, and analytics. Built dashboards and reports, implemented Databricks ETL pipelines with Python, and supported KPI reporting with star and snowflake schemas.
Assisted with dimensional modeling and reporting data structure development, collaborating with DBAs to improve tables and relationships. Supported data cleansing/validation, documentation, and UAT testing for dashboards and data-model changes.
Education
Degrees, certifications, and relevant coursework
Auburn University at Montgomery
Master of Science in Information Technology, Information Technology
Completed a Master of Science in Information Technology at Auburn University at Montgomery in May 2025.
Vignan’s University
Bachelor of Technology, Information Technology
Completed a Bachelor’s in Information Technology at Vignan’s University in June 2020.
Tech stack
Software and tools used professionally
Availability
Location
United StatesAuthorized to work in
Job categories
Skills
Interested in hiring Sanjana?
You can contact Sanjana and 90k+ other talented remote workers on Himalayas.
Message SanjanaGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
