Core Analytic - Python & SQL

Work Location: Ithink, thane

🔹 Legel: L73 (3+ years of exp)
🔹 Role Type: Individual Contributor
🔹 Shift Timing: 1:30 PM – 10:30 PM

Roles and Responsibilities

• Review and interpret loss run data and claim-related placement data to assess data availability for analytical reporting
• Identify data gaps or inconsistencies and engage with relevant stakeholders to obtain clarification or additional information required for reporting
• Cleanse raw data in accordance with defined standard operating procedures
• Automate data processing and reporting workflows using Python programming and Server Integration Services
• Standardized datasets to enable flexible analysis and reporting across multiple dimensions
• Develop standard and customized analytical models using Microsoft Power Business Intelligence
• Apply advanced Microsoft Excel functionality, including slicers, nested formulas, and macros, to generate dynamic charts and reports aligned to policy years, including automated output where required
• Design automated standard and customized templates to reduce manual effort, minimize errors, and improve turnaround times

Skills

• Experience in developing dashboards using data visualization tools, including Microsoft Power Business Intelligence
• Experience using advanced Microsoft Excel functionality, including complex formulas, macros, and Visual Basic for Applications
• Working experience with Python programming & Structured Query Language for data processing and automation
• Bachelor’s degree in commerce, Science, or Technology, or progress toward Chartered Insurance Institute certification, which is considered an advantage
• Demonstrates clear and effective verbal and written communication
• Proficiency in reviewing, interpreting, and comprehending detailed information accurately
• Analytical approach to problem identification and solution development
• Experience collaborating effectively within team environments while meeting defined quality standards and delivery timelines