Insurance Data Analyst, HOA

Accountabilities: Write, maintain, and optimize SQL queries across BigQuery and SQL Server for recurring reporting, business analysis, and ad hoc requests. Build and maintain Power BI dashboards that track key insurance KPIs, including quotes, binds, retention, premium, and business mix. Conduct descriptive and diagnostic analyses to identify trends, performance drivers, anomalies, and opportunities across the insurance portfolio. Evaluate product and business changes using cohort analysis, pre/post analysis, trend analysis, and other analytical approaches to quantify their impact. Support competitive intelligence initiatives by gathering, organizing, analyzing, and summarizing competitor information to inform pricing and product decisions. Partner with Product Managers and business leaders to translate analytical findings into clear, actionable recommendations. Maintain high standards of data accuracy and integrity through quality checks, reconciliations, source validation, and thorough documentation. Work independently on complex, cross-functional issues with potential mid- to long-term business implications, proactively identifying problems and opportunities. Use analytical and automation tools, including Python or R and AI-enabled tools, to improve research, analysis, and operational efficiency. Requirements Bachelor’s degree in Business, Finance, Economics, Statistics, Actuarial Science, or a related discipline. At least 3 years of professional experience, including 1+ years working in personal lines insurance within data analysis, actuarial, product analytics, or a related function. Strong SQL capabilities with hands-on experience using BigQuery and/or SQL Server. Advanced experience developing, maintaining, and interpreting Power BI dashboards and reports. Excellent Microsoft Office skills, particularly advanced Excel capabilities and strong attention to detail. Proficiency in Python or R for analytical work, automation, or data processing. Familiarity with AI-powered tools for accelerating research, analysis, and productivity. Experience working with global and/or U.S.-based business teams. Strong written and verbal English communication skills, with the ability to clearly explain analytical findings to business stakeholders. Demonstrated ability to independently manage complex problems, determine appropriate approaches, and make sound decisions with limited direction. Self-motivated and proactive approach, with a demonstrated ability to identify issues and opportunities before they become larger problems. Strong analytical, critical-thinking, organizational, and problem-solving skills. Ability to work approximately 8 hours per day, including 4 core U.S. hours of overlap from 7:30 PM–11:30 PM IST and 4 flexible hours. Reliable remote-work setup with a quiet workspace and internet connectivity of at least 30 Mbps download and 10 Mbps upload. Benefits Annual compensation of INR 693,800–971,300 , depending on experience, skills, knowledge, market alignment, and geographic location. Fully remote work arrangement. Medical insurance. Accident insurance. Retirement benefits. 12 company-paid holidays annually. 2 flexible holidays. Privilege/earned leave. Casual and sick leave. Paid maternity and paternity leave. Weekly wellness events and broader wellness programs. Opportunity to work with global and U.S.-based teams. High-autonomy environment with meaningful ownership and opportunities to influence business decisions. Inclusive workplace focused on collaboration, accountability, diverse perspectives, and professional growth.