Ritvik Jain

About Ritvik Jain

Data Analyst with 3.5+ years of experience in healthcare and insurance domains, specializing in data governance, data quality validation, and business intelligence. Proficient in SQL, Snowflake, Databricks, Python, Power BI, Tableau, and Excel (VBA, advanced formulas) for transforming large-scale datasets into actionable insights. Proven track record of developing data governance frameworks, automating validation processes, and delivering interactive dashboards that improve operational efficiency and compliance. Skilled in collaborating with cross functional teams to define data ownership, streamline ETL pipelines, and ensure HIPAA compliant analytics for data-driven decision-making.

Experience

1. Data Analyst

   Cigna Healthcare

   Feb 2024 — Present · NJ, US

   Supported enterprise data governance initiatives by validating, cleaning, and standardizing 100k+ healthcare records, ensuring accuracy, consistency, and adherence to HIPAA and organizational standards. Queried, cleaned, and analyzed large-scale datasets (claims, pharmacy, patient, and provider data) using SQL, Snowflake, and Databricks, generating insights that supported 10+ business-critical reports per month. Collaborated with business, clinical, and technical stakeholders to document data lineage, ownership, and standard definitions, improving data reliability across 5+ key data domains. Built interactive Power BI dashboards and Databricks reports to monitor data quality, system performance, and operational trends, viewed by 50+ team members and leadership. Automated routine data validation processes using SQL and Python, reducing manual checks by ~40% and identifying recurring pipeline issues. Developed Excel models with advanced formulas and VBA macros to support ad-hoc reporting, validation, and governance workflows, saving 5+ hours per week in manual work. Assisted in monitoring large healthcare datasets on big data platforms to ensure reliable performance and accessibility for analytics, supporting scalable workflows for multiple teams. Maintained comprehensive documentation of datasets, transformations, and workflows to support data governance, knowledge sharing, and audit readiness.

Education

• Sathyabama Institute of Science & Technology, Chennai

  Bachelor's degree

• Stevens Institute of Technology

  Master's degree